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 autocomplete: table names, column names, SQL keywords, and functions.
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 per connection. 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.
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 capped at 1000 maximum.
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.