Running queries
Once you’re connected, you write and run queries in a query tab. This page covers the editor, the results grid, transactions, and the command palette.
The SQL editor
Section titled “The SQL editor”Verql’s editor is powered by Monaco (the same engine behind VS Code), so it feels familiar: syntax highlighting, multiple cursors, find-and-replace, and so on. The language adapts to your connection — SQL for relational databases, and the appropriate language for non-SQL drivers.
Autocomplete
Section titled “Autocomplete”As you type, the editor suggests:
- SQL keywords for your database’s dialect
- Table and column names pulled from the live schema of your connection
This means completions reflect your database, not a generic word list. If suggestions look stale, reconnecting refreshes the schema cache.
Opening a query tab and running a query
Section titled “Opening a query tab and running a query”- Open a new query tab with Cmd/Ctrl+N.
- Write your query, then run it. The results appear in the grid below the editor.
You can keep several query tabs open at once, each against the same or different connections.
The results grid
Section titled “The results grid”Query results are shown in an AG Grid table. From there you can:
- Scroll, sort, and resize columns
- Select rows and cells
- Feed results into the chart panel or export them
Selecting a row also updates the inspector, which shows that row’s values in a readable layout.
Transactions
Section titled “Transactions”For PostgreSQL and SQLite connections, each query tab can run inside a transaction instead of auto-committing every statement. A transaction toolbar gives you:
| Control | What it does |
|---|---|
| Auto-commit toggle | Turn auto-commit off to start running statements inside a transaction. |
| Commit | Make the transaction’s changes permanent. |
| Rollback | Discard everything since the transaction began. |
| Isolation level | Choose the transaction’s isolation level. |
| Read-only | Run the transaction in read-only mode for safe exploration. |
A connection can also default to manual-commit via a per-connection Auto-commit by default setting. If you try to close a tab while a transaction is still open, Verql prompts you to commit or roll back first so you don’t lose track of pending changes.
Transaction controls are available today for PostgreSQL and SQLite. Other drivers can light up the same toolbar as they add support.
The command palette
Section titled “The command palette”Press Cmd/Ctrl+Shift+P to open the command palette. It surfaces editor actions, app commands, and any commands added by plugins — a fast way to find a feature without hunting through menus. Start typing to filter, then press Enter to run.
Next: Exploring your schema →