zanith

studio / workspace · 01 — Above the database

Every database in one place.

Workspace is what you see before you pick a database. Every server you've connected to, sorted by what you used last. Health badges tell you which ones are reachable. ⌘1, ⌘2, ⌘3 jump back to the most recent.

zanithSTUDIOhomeserversactivitysettingsServers4 connected · sorted by recentprod_dbprodok14 tables · 4.2M rows · 3.1 GBlast used 12m agoconnecteditstagingstagingok14 tables · 4.2M rows · 3.1 GBlast used 2h agoconnecteditdev_localdevok14 tables · 4.2M rows · 3.1 GBlast used nowconnecteditanalytics_rorowarn14 tables · 4.2M rows · 3.1 GBlast used 1d agoconnectedit+ Add connection
4 workspace tabshealth badgesrecent-first sort⌘1 ⌘2 ⌘3 quick-switchv0.2 · shipped

02 — What a card holds

Six pieces of metadata per connection.

Connections are richer than a hostname and a password. The metadata you set once shows up everywhere a query runs — in the sidebar, on confirmation dialogs, in audit rows.

color tag

user-set, persists in the sidebar

read-only flag

writes refuse without confirmation

auth

password / private key / SSH tunnel

ssl

disable / require / verify-full

schema

search_path · target a non-default schema

notes

free-form, surfaces in the sidebar

03 — Activity, unified

One log for every database.

SQL runs, migrations applied, DDL operations, recovery actions — all stored locally per workspace. Filter by connection, by kind, by time. Export as NDJSON when you need it for a post-mortem.

recent activity · all connections7 events
  • sqlprod_dbSELECT FROM users WHERE …12s ago
  • migratestaging20260501_113022_add_last_login applied4m ago
  • ddldev_localALTER TABLE products ADD COLUMN price_cents8m ago
  • recoverprod_dbrestore-column users.legacy_uuid14m ago
  • sqlanalytics_roSELECT count(*) FROM orders1h ago
  • ddlstagingDROP INDEX users_old_email_idx1h ago
  • migrateprod_db20260428_141755_add_user_indexes applied2d ago
allsqlmigrateddlrecover

04 — Cross-database

Three things only the workspace can do.

Search, diff, and run-everywhere — capabilities that need more than one connection at the same time.

Cross-DB table search

Type a name. Studio searches every connection's introspected schema and shows where it lives.

Schema diff

Pick two connections. See tables added, removed, columns changed — one report, ranked by risk.

Workspace-scoped saved queries

A query that runs on every connection. Open the panel, pick a target, hit run. Same SQL, four results.