SQL Editor
A full read/write Postgres console for the databases you provision.
Tabs
Each query lives in its own tab. Hit + in the tab strip to open a new one, double-click a tab title to rename, and × to close it. Tabs are in-memory only — save anything you want to keep.
Running queries
Press ⌘↵ (or Ctrl↵ on Windows/Linux) to run the active tab. Results appear below the editor with row count, affected count, and elapsed milliseconds. Result sets are capped at the first 1,000 rows.
Saved queries
Click the + next to Saved in the sidebar to name and persist the active query. Saved queries live in localStorage, scoped to the current browser. The Update saved button in the toolbar overwrites the snippet you most recently loaded.
Examples
The Examples section in the sidebar has copy-and-tweak starters for common operations: listing user tables, creating a table, inserting rows, selecting recent rows.
Limits
- Query length: 50,000 characters.
- Result rows: capped at 1,000 (excess marked as
truncated). - One concurrent connection per request (queries are sequential).
What the row cap actually does
The 1,000-row cap is a display limit, not a query limit. Your statement runs in full against Postgres and the reported rowCount is the real total — only the rows sent back to the browser are trimmed, and the response is flagged truncated so the editor can tell you. Add your own limit / offset when you want to page through a large result.
Every run also stamps the database as recently used, which is what resets the idle-pause clock described in Plans & billing.
Errors and safety
Postgres errors come back verbatim — the message you see is the one the server produced, not a rewritten summary — so a typo or a constraint violation reports the real cause and line.
The editor is genuinely read/write: there is no statement allow-list, so drop, truncate and delete all do exactly what they say against your live database. Requests are rate-limited and every query is scoped to a database you own.
Shortcuts
⌘↵ Run active tab ⌘K Open command palette Double-click tab Rename