studio / launch · 01 — Three shapes
One binary. Three boundaries.
Studio runs against any connection your engine has. Bind it to localhost for solo work, hand a teammate the read-only token, or open it on a VPN for the team. Same command, different flags.
Shared staff
Read-only
02 — Mode boundaries
What each role can do.
Reads are universal. Writes are gated by mode. Staff can mutate but every write triggers a typed confirm. Viewers cannot mutate at all.
| Capability | dev | staff | viewer |
|---|---|---|---|
| Browse rows | yes | yes | yes |
| Run SELECT in SQL | yes | yes | yes |
| Edit / insert / delete rows | yes | with confirm | no |
| Run DDL (alter / drop) | yes | with confirm | no |
| Apply migrations | yes | with confirm | no |
| Restore artifacts | yes | with confirm | no |
| Manage connections | yes | yes | no |
03 — Audit
Every mutation, written down.
Pass --audit-log and every write request appends a JSON line to disk. Default location lives under the workspace data dir; pass a path to put it where your log shipper can read.
Combined with the engine's _zanith_migration_steps audit table, this gives you both the row-level change and the request that caused it.
04 — Hardening
Conservative defaults. Explicit unlocks.
Bind to 127.0.0.1
By default, Studio binds to localhost. Use --host only when you mean it.
Bearer tokens
Admin or read-only token required for non-localhost binds. No token, no service.
Read-only mode
GETs only, plus probe / explain / refresh. Nothing that mutates.
Append-only audit
NDJSON to disk. Every write request captured with actor, ip, diff.
Prod-confirm dialogs
Tag a connection 'prod' and every mutation needs a typed confirmation.
No persistent sessions
Tokens are checked per request. Refresh on rotate, no logout flow needed.
Six doors. All open.
Back to Studio
Overview, contrast, eight surfaces.
/studioWorkspace level
Cross-database — every connection, activity, search.
/studio/workspaceTables surface
Browse, edit, bulk operations, sensitive masking.
/studio/tablesSQL playground
Multi-tab editor, plans, watch, charts.
/studio/sqlSecurity tab
Lock graph, RLS, roles, permission matrix.
/studio/securityCatalog
Views, sequences, triggers, functions.
/studio/catalog