SQL Editor
The SQL editor is the core of Zentro. It's built for speed: type a query, run it, see results — all without leaving the keyboard.
Overview
- Multi-tab editing — open multiple queries per environment
- Syntax highlighting for PostgreSQL, MySQL, SQL Server, and SQLite dialects
- Inline error reporting from the database engine
- Results rendered in the Data Grid, sortable and filterable
Running Queries
| Action | Shortcut |
|---|---|
| Run selected query (or entire editor) | Ctrl+Enter |
| Run all statements | Ctrl+Shift+Enter |
| Format SQL | Shift+Alt+F |
| New editor tab | Ctrl+T |
| Close tab | Ctrl+W |
When you select a portion of text and press Ctrl+Enter, only the selection is sent to the database. This lets you iterate on a single statement inside a larger script.
Auto-complete
The editor provides context-aware suggestions:
- Keywords —
SELECT,FROM,WHERE,JOIN, etc. - Table names — pulled from the active connection's schema
- Column names — available after you type a table name
Trigger auto-complete manually with Ctrl+Space.
Schema metadata is fetched when you connect and refreshed automatically when you switch environments. To force a refresh, right-click the schema tree and choose Refresh.
Multiple Statements
You can write multiple SQL statements in one editor tab, separated by semicolons. When you run all (Ctrl+Shift+Enter), each statement executes in order. Results for each are shown in separate result tabs at the bottom.
Saved Scripts
Queries you want to keep can be saved from the editor with Ctrl+S. Saved scripts appear in the Saved Scripts panel (left sidebar) and are organized per project.
→ See Saved Scripts & History
Result Panel
After a query runs, results appear in the bottom panel:
- Data Grid — tabular view, sortable by column, copy as CSV / JSON
- Affected rows — shown for
INSERT,UPDATE,DELETE - Execution time — displayed per query
- Errors — inline, with the database engine's message
→ See Data Grid & Table View