Schema Browser
The Schema Browser is the right panel in the workspace. A hierarchical tree of every database, schema, table, view, function, type, and index for the active connection. Search, context menu, quick actions.
Tree structure
Database (current connection)
├─ Schemas
│ ├─ public
│ │ ├─ Tables (12)
│ │ │ ├─ orders
│ │ │ │ ├─ Columns (8)
│ │ │ │ ├─ Indexes (3)
│ │ │ │ ├─ Constraints (2)
│ │ │ │ └─ Triggers (1)
│ │ │ └─ ...
│ │ ├─ Views (4)
│ │ ├─ Materialized Views (1)
│ │ ├─ Functions (15)
│ │ ├─ Types (3)
│ │ └─ Sequences (8)
│ └─ analytics
└─ Extensions
The tree is virtualized — a million tables don't lag.
Search
Top of the panel — search bar. Type to filter. Prefix t: limits to tables, f: to functions, i: to indexes:
users — finds anything containing the substringt:order — tables onlyf:jsonb_* — functions starting with jsonb_
⌘+F with focus in the tree jumps to the search bar.
Refresh
After creating a table from another client, the tree won't auto-refresh. Refresh:
- ⌘+R
- The ↻ button in the panel header
- Right-click → Refresh node — refreshes a specific node (faster on big trees)
Context menu
Right-click any node — opens a menu. Actions depend on the node type:
Table
| Action |
What |
| SELECT (Top 100) |
Opens a tab with SELECT * FROM ... LIMIT 100 |
| EXPLAIN preview |
Show plan for a typical query |
| Edit table… |
Opens the Object Editor |
| Show DDL |
Shows CREATE TABLE with all constraints |
| Drop table… |
Asks for confirmation by typing the table name |
| Show in ERD |
Opens the table in the ERD diagram |
| Backup table… |
Ad-hoc backup of a single table |
If extensions are active — these appear:
- Repack… (if
pg_repack) — see pg_repack
- Configure as partitioned… (if
pg_partman) — see pg_partman
- Convert to hypertable… (if
timescaledb) — see TimescaleDB
Column
| Action |
What |
| Add to query |
Inserts the column name into the active editor |
| Find references |
Finds FOREIGN KEY and views using this column |
| Edit column… |
Opens a mini-form (type, default, nullable) |
Index
| Action |
What |
| Show DDL |
Shows CREATE INDEX |
| REINDEX CONCURRENTLY |
Prod-safe index rebuild |
| Drop index… |
With confirmation |
Quick object creation
In the panel header — + New button. A dropdown appears:
- Table
- View
- Materialized view
- Function
- Type (enum, composite)
- Index
- Sequence
All open the Object Editor.
Double-click
| Target |
What happens |
| Table |
Opens SELECT * FROM ... LIMIT 100 in a new tab |
| View |
Same |
| Function |
Opens DDL in the editor |
| Column |
Inserts the name into the active editor |
JSONB scanning
For each jsonb column ide99 collects, in the background, the keys it sees and their types — needed for autocomplete (data->>'<TAB> shows real keys). Details: JSONB editor → path autocomplete.
You can trigger scanning manually: ⌘+Shift+J with focus on a jsonb column.
Next