Production Safety
Pro feature — requires an active Pro or Early Access license. Get Early Access free →
Production Safety is a set of guardrails that activate when you connect to a Production environment. Every feature here is designed to slow you down — on purpose.
Production Overlay
When you connect to a Production environment, a persistent red banner appears at the top of the app and stays visible regardless of which panel you're in.
This is intentional friction. It makes the context switch (from staging to production) viscerally obvious.
Write Confirmation Prompts
Any statement that modifies data — INSERT, UPDATE, DELETE, DROP, TRUNCATE, ALTER — triggers a confirmation dialog before execution:
- Shows the full statement to be executed
- Estimates the number of affected rows (where possible)
- Requires you to click Execute to proceed
This cannot be disabled on Production environments.
Audit Log
Every query executed on a Production environment is recorded:
| Field | Value |
|---|---|
| Timestamp | When the query ran |
| SQL | Full statement text |
| Rows affected | Count returned by the driver |
| Status | Success / Error |
| Duration | Execution time in ms |
The audit log is stored locally and can be exported as CSV. Access it from Project → Audit Log in the toolbar.
Snapshot & Rollback
Before running a write on Production, Zentro can automatically take a snapshot — a SELECT of the rows that would be affected, saved locally.
If the write goes wrong, open the snapshot to generate rollback INSERT/UPDATE statements.
Enable in Settings → Production → Auto-snapshot before writes.
Snapshots work for single-table writes (UPDATE table WHERE ..., DELETE FROM table WHERE ...). Complex multi-table writes are not auto-snapshotted.
Vault
The Vault stores connection credentials in an AES-256 encrypted local store, protected by a master password separate from App Lock.
Use Vault when you manage credentials that need to be shared or exported securely (the vault file can be exported encrypted and imported on another machine).
Configure in Settings → Security → Vault.
PII Blur
Mark specific columns as PII. Their values are replaced with •••••• in the Data Grid by default — you must click a cell to reveal the real value.
To mark a column: right-click the column header in the Data Grid → Mark as PII.
PII markers persist per table, per project, across sessions. Useful when screen sharing or recording demos.