zanith

studio / catalog · 01 — The other objects

Postgres has more than tables.

Views, sequences, triggers, functions, indexes — the objects every database has and most table-first tools ignore. Studio gives them the same surface as tables, with the operations you actually run on each.

catalog · current schema51 objects total

Views

8
  • v_active_users
  • v_revenue_daily
  • mv_top_products
  • + 5 more

Sequences

12
  • users_id_seq
  • orders_id_seq
  • session_token_seq
  • + 9 more

Triggers

9
  • users_set_updated_at
  • orders_audit
  • products_search_vec
  • + 6 more

Functions

22
  • compute_lifetime_value()
  • search_products(text)
  • tsv_update()
  • + 19 more
4 object kindsindexes per-tablerefresh materializedsetval / restartv0.2 · shipped

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.

03 — Indexes

Per-table index UI. No SQL required.

Every table's info drawer carries the index list. Drop, create CONCURRENTLY, pick a method (btree / gin / gist / hash / brin) without touching SQL.

indexes · users+ Create index
  • users_pkey
    btree (id)
    PRIMARY
    1.2 MBDrop
  • users_email_idx
    btree (email)
    UNIQUE
    412 KBDrop
  • users_last_login_idx
    btree (last_login)
    248 KBDrop
  • users_metadata_gin
    gin (metadata)
    1.8 MBDrop

create index · method picker

btreedefault · range queriesginjsonb · array · full-textgistgeospatial · range typeshashequality onlybrinhuge tables · summary

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

Six doors. All open.

→ live

Back to Studio

Overview, contrast, eight surfaces.

/studio
→ live

Workspace level

Cross-database — every connection, activity, search.

/studio/workspace
→ live

Tables surface

Browse, edit, bulk operations, sensitive masking.

/studio/tables
→ live

SQL playground

Multi-tab editor, plans, watch, charts.

/studio/sql
→ live

Security tab

Lock graph, RLS, roles, permission matrix.

/studio/security
→ live

Launch + auth

Three deployment modes.

/studio/launch