Query Editor
The heart of QueryGlow. A powerful, Monaco-based SQL environment with built-in safety features and optional AI assistance.
Editor Features
Monaco Editor
Built on the same engine as VS Code. Full syntax highlighting with multi-dialect support—automatically adjusts syntax for MySQL vs PostgreSQL.
Press Ctrl+Space for schema-aware autocomplete: table names, column names with data types, SQL keywords, and functions. Type table. for dot-notation.
Query History
Every query you execute is automatically saved with a timestamp. Click any past query to reload it into the editor.
Stores the last 1,000 queries across all connections. Searchable history list.
Saved Queries
Save frequently-used SQL with names, descriptions, and tags for quick access from the sidebar.
Per-connection organization. Edit and delete anytime.
Multiple Queries
Write several queries in the editor at once. Highlight a specific query and pressCtrl+Enterto execute only that one.
Results appear below the editor with execution time.
EXPLAIN Visualizer
Click “Explain” next to “Run” to get a visual query plan. Nodes are color-coded by execution time. Expand any node for buffer stats and row estimates.
Smart warnings detect sequential scans and suggest CREATE INDEX statements. Works with all six engines: PostgreSQL, MySQL, MariaDB, SQLite, CockroachDB and TimescaleDB.
SQL Autocomplete
Schema-aware completions that know your database. Tables, columns with data types, SQL keywords, and functions — all context-aware.
Dot-Notation (Auto-Trigger)
Type a table name followed by a dot to see all columns with their data types.
film. → film_id, title, release_year...Context-Aware Suggestions
Press Ctrl+Space for completions based on cursor position.
FROM → tables | SELECT → columns + tablesKeywords & Functions
60 SQL keywords and 40 functions with auto-parentheses.
COU → COUNT() with cursor insideSchema Auto-Refresh
After CREATE, ALTER, or DROP TABLE, the schema reloads automatically.
New tables appear in autocomplete instantlyNote: Databases with 200+ tables show a subset for performance. Alias support (e.g., SELECT u. FROM users u) is planned for a future release.
Safe Mode (Default: ON)
The Query Editor includes built-in protection against accidental data loss.
Auto LIMIT
Queries without a LIMIT clause automatically get LIMIT 1000 added. Existing LIMIT values are respected up to a hard cap of 50,000 rows.
Blocked Operations
DROP TABLE,TRUNCATE, andDELETE/UPDATE without WHERE are blocked.
Configure via QUERYGLOW_ALLOW_DESTRUCTIVE=true to enable Power Mode. See Environment Variables.
Always Blocked (Cannot Be Enabled)
These operations are blocked regardless of Safe Mode setting—they can never be executed through QueryGlow:
DROP DATABASESHUTDOWNINTO OUTFILELOAD_FILExp_cmdshellCOPY TO/FROM PROGRAMSQL comments are stripped before security checks to prevent bypass attempts.
AI Assistant (BYOK)
QueryGlow integrates with major LLMs to write SQL for you. Because we are self-hosted, you "Bring Your Own Key" (BYOK). We don't markup the price.
✓ Privacy: Only schema metadata (table/column names) is sent. No actual row data ever leaves your server.
⚡ Rate Limited: 30 requests per minute to prevent API cost abuse.
Keyboard Shortcuts
| Shortcut | Action |
|---|---|
| Ctrl+Enter | Execute current query (or highlighted selection) |
| Ctrl+Space | Trigger autocomplete (tables, columns, keywords, functions) |
On Mac, use Cmd instead of Ctrl.