Database Explorer
Browse your PostgreSQL tables, run SQL queries, and import CSVs—all from the Console. Go to Database in the sidebar.
Viewing data
Click any table in the left sidebar to open it. Data loads in pages—use the controls at the bottom to navigate. Resize columns, search with Cmd+F, and toggle between ISO and local timestamps.
Editing data
By default you're in read-only mode. Switch to Write mode in the header to enable editing.
With Write mode on:
- Double-click any cell to edit (except
id) - Select rows and press
Deleteto remove them - Undo with
Cmd+Zbefore saving
Modified cells turn yellow, deleted rows turn red. Click Review SQL to see what will run, then Save changes to execute. Everything runs in a transaction.
Write mode works in all environments, including production. Review the SQL before saving.
Running queries
Click Query in the sidebar for a SQL editor with syntax highlighting and autocomplete. Run queries with Cmd+Enter.
Results appear in a grid below. For queries that don't return data (UPDATE, DELETE), you'll see a success message.
The Ask question button generates SQL from plain English if you're not sure of table or column names.
Importing CSVs
- Open the table you want to import into
- Click Import at the bottom
- Drop your CSV file
- Map columns to database fields
- Review and click Import
Schema visualizer
Click Schema in the sidebar for an interactive diagram of your models and relationships. Pan and zoom to explore, or download as PNG.
External access
Need to connect a database client or BI tool? Create credentials in Database → Settings:
- Click Create user
- Save the credentials immediately (they won't be shown again)
You'll get a primary URI (read-write) and a read-only replica URI. Delete users anytime from the same settings page.