Database Explorer

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 Delete to remove them
  • Undo with Cmd+Z before 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

  1. Open the table you want to import into
  2. Click Import at the bottom
  3. Drop your CSV file
  4. Map columns to database fields
  5. 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:

  1. Click Create user
  2. 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.