Documentation

Download Varium SQL for macOS, Windows, or Linux from the homepage — no account required to start. On first launch you land on the connections screen, where every database you connect to is saved for next time.

Click New Connection to add a database, or Quick Connect to jump straight back into the last one you used.

Varium SQL supports PostgreSQL, MySQL, MariaDB, SQLite, SQL Server, and MongoDB. Each connection can be configured two ways:

• Basic — host, port, username, password, database name
• URL — paste a full connection string (e.g. postgresql://user:pass@host:5432/db)

SQLite connections point to a local .db file instead — type a path to an existing file, or a new one to create it.

For databases behind a bastion host, enable SSH Tunnel and provide the jump host's credentials (password or private key). Varium SQL opens the tunnel automatically and routes the connection through it.

Use Test Connection before saving to confirm the server is reachable without connecting for real. Each saved connection also has a Query Guard level — see below.

The editor is a full Monaco-based SQL editor with syntax highlighting, schema-aware autocomplete, and AI-powered suggestions as you type — press Tab to accept an AI suggestion inline.

• Ctrl/⌘ + Enter — run the whole query (or script, for multi-statement SQL)
• Ctrl/⌘ + Shift + E — run only the statement under the cursor
• Ctrl/⌘ + Shift + F — format the SQL
• Esc / Ctrl/⌘ + C — stop a running query

Tabs can be scoped globally (shared across every connection) or per-connection, whichever fits your workflow — switch this anytime from File → Settings.

Results render as a dense, virtualized table that stays smooth even with very large result sets. Switch between Table, Card, JSON, Chart, and Pivot views from the toolbar above the results.

Columns

• Drag a column's right edge to resize it, or drag its header to reorder it
• Pin a column left or right from its header menu — it stays visible while you scroll
• Filter any single column, or use the search box to filter across every column at once
• Sort by clicking a header; see per-column stats (min/max/distinct/nulls) from the chart icon

Editing

• Double-click any editable cell to edit it in place; primary keys are read-only
• Long values open in a floating editor instead of a cramped inline box — the same overlay also lets you peek at long read-only values without editing them
• Check the boxes on the left to select multiple rows, then delete them all at once
• Right-click a cell for more options: copy as JSON/CSV/INSERT, jump to a foreign key's referenced row, or delete the row

A result set is only editable when Varium SQL can trace every row back to a single table with a primary key — you'll see a badge in the results header explaining whether editing is available and why.

Describe what you want in plain language and the AI Assistant panel writes the SQL for you, aware of your current schema. Keep multiple conversations going and pick up any of them later from the history menu.

Press Ctrl/⌘ + K from anywhere to search connections, tables, and actions without leaving the keyboard.

Pick from 18 free themes (38 with Pro) from View → Themes.

Query Guard™ is a per-connection safety net against accidental destructive queries on the databases you care about most:

• Unguarded — no extra confirmation (good for local/dev databases)
• Guarded — confirms before destructive statements (UPDATE/DELETE without a WHERE, DROP, TRUNCATE)
• Protected — the strictest level, meant for production databases

Set the level once when you create the connection, and change it anytime from Edit Connection.

The full, up-to-date list is always available in the app from Help → Keyboard Shortcuts.