Writing queries
Autocomplete suggests tables, columns, keywords, and functions from your live schema, for PostgreSQL, MySQL, MSSQL, and ClickHouse. Query zones let you keep several queries in one file, separated by--- delimiter lines. Each zone runs independently.
- Click inside a zone to focus it.
- Run (or Ctrl+Enter) executes the focused zone.
- Add a
---line to create a new zone.
Running queries
Place the cursor in a zone and Run (or Ctrl+Enter). Results appear below the editor with sorting, column resizing, and copy. On error, the database message shows inline. Use Fix with AI to get a corrected query.Saving queries
Click Save, name the query, and it’s stored per connection. Open saved queries from the Saved queries panel, where you can rename, duplicate, or delete them.AI in the editor
Generate / modify SQL
Press Ctrl/⌘+K in a zone and describe what you want. A diff
shows the change before you apply it. Subscription feature.
Fix on error
Fix with AI appears next to an error and suggests a correction you apply in one click.
Subscription feature.