studio / catalog

The objects browse
tools forget.

Views, materialized views, sequences, functions, triggers, enums, extensions — each with its real definition, ready to copy into a migration.

Studio docs ← Overview

zanith studio — catalogpostgres · prod

viewactive_userscopy definition

vieworg_revenue

matviewmonthly_mrr

viewpending_invites

-- active_users · view definition

CREATE VIEW active_users AS

SELECT id, email, last_seen_at FROM users

WHERE active = true

AND last_seen_at > now() - interval '30 days';

18 views · 105 objectsread from pg_catalog

views · matviews·sequences · functions·copyable definitions

02 — Click into one

Each kind has its own surface.

Views

REFRESH

Definition viewer with copy. Materialized views get a one-click REFRESH MATERIALIZED.

Sequences

nextval

Current value at a glance. nextval, setval, RESTART — all without leaving the tab.

Triggers

BEFORE INSERT

Timing, events, table affiliation. Full pg_get_triggerdef in a copyable code block.

Functions

plpgsql

Returns, args, language, kind. Source viewer for plpgsql, sql, and any installed language.

Indexes

Indexes, on every
table.

Every index, per table. Method, columns, uniqueness, on-disk size — read straight from the catalog.

Build without locking. CREATE INDEX CONCURRENTLY by default, with live progress. Writes keep flowing.

Drop the dead ones. Unused indexes are flagged by scan count — drop them in a click.

users · indexes4 indexes · 3.6 MB

users_pkeyPKbtree (id)1.2 MB

users_email_idxUNIQUEbtree (email)412 KB

users_last_login_idxbtree (last_login)248 KB

users_metadata_ginGINgin (metadata)1.8 MB

CREATE INDEX CONCURRENTLYusers_role_idx0%

no table lock · writes continue

04 — One-click actions

Six tasks no terminal required.

REFRESH MATERIALIZED

On any materialized view, with a confirm dialog.

Browse view rows

Click open. The view becomes a regular table page.

nextval()

On a sequence. Returns the new value, updates the panel.

setval / RESTART

Fix a sequence after a bulk import. With a confirm.

Drop index

From the table info drawer. CONCURRENTLY by default.

Copy definition

View, trigger, function — copyable source for migrations.

05 — Sideways

Objects connect everything.

Tables surface

Open any view as a table page — its rows, browsable and filterable.

/studio/tables

SQL playground

Copy a function or view definition straight into a query tab.

/studio/sql

Security

Policies, roles, and grants are catalog objects too — inspect them.

/studio/security

Workspace level

Diff the catalog across connections — what objects differ where.

/studio/workspace

Launch + auth

Ship Studio — three deployment shapes, hardening, audit.

/studio/launch

Studio overview

The system, the contrast, the bundled architecture.

/studio