Database Browser
Explore your PostgreSQL schema in tpaw — browse tables, views, sequences, enums, functions, extensions, and roles with the sidebar browser.
The Database Browser is the sidebar panel that gives you a complete view of your PostgreSQL schema. Click any object to open it, inspect its structure, view relationships, or browse its data. It's your map of the database.
Schema objects
The sidebar organizes schema objects into collapsible groups:
| Group | What you'll find |
|---|---|
| Tables | All user tables — click to open in Data Grid |
| Views | Views and materialized views |
| Sequences | Sequence objects with current value |
| Enums | Custom enum types and their values |
| Functions | Function signatures, arguments, and return types |
| Extensions | Installed PostgreSQL extensions |
| Roles | Database roles, login privileges, and membership |
Opening objects
Tables: Click a table name to open it in the Data Grid. The table loads with all rows and supports inline editing, filtering, sorting, and pagination.
Views: Click a view to browse its rows in a read-only Data Grid.
Sequences: Click a sequence to see its current value, increment, min/max bounds, and cycling settings.
Enums: Click an enum type to see all its label values.
Functions: Click a function to view its definition, argument names/types, and return type.
Extensions: Shows the extension name, version, and schema.
Roles: Shows role attributes including LOGIN, SUPERUSER, and group memberships.
Table Structure view
When a table is open in the Data Grid, switch to the Structure tab to inspect columns, indexes, and foreign keys:
- Columns — name, data type, nullable, default value, with PK/FK/unique badges
- Indexes — index name, columns, type (btree, gin, etc.), and uniqueness
- Foreign Keys — referenced table and column, with navigation links
From the Structure view you can also:
- Add a column — click the + button, fill in name/type/nullable/default
- Alter a column — click a column row to edit its properties
- Drop a column — select a column and click delete (destructive, requires confirmation)
ERD Diagram
Click View Diagram on a schema to open the ERD Diagram — an interactive SVG showing all tables as draggable nodes with column lists and foreign key relationships as curved edges. See the ERD Diagram page for full details.
Schema Diff
Use Schema Diff to compare the schemas of two connected PostgreSQL databases side by side. Select a source and target connection, click Compare, and tpaw shows an object-level summary of added, removed, and modified tables, enums, indexes, and other objects — plus a full DDL diff in Monaco. See the Schema Diff page for full details.
Refreshing the schema
The schema cache updates automatically on connect. To manually refresh (e.g., after a migration run from another tool), click the Refresh button to reload schema objects.
Searching the schema
Press Cmd+K to open the command palette and type a table or view name to jump to it directly.