Everything you expect.
A few things you won’t believe.

Every feature, sorted into three shelves: the table stakes, the premium stuff, and the genuinely new. Each one carries an honest mark — ✓ ships ◐ building ○ next — so nothing in progress reads as finished.

The needed

Every tool in this category has these. Ours just happen to be excellent.

Nine engines

SQL Server, PostgreSQL, MySQL, SQLite, DuckDB, ClickHouse, Oracle, libSQL/Turso, and Redis.

Tabs with memory

Each tab keeps its own connection; reopen the app and everything is exactly where you left it.

Run exactly what you mean

Whole document, selection, or current statement — and cancel actually stops the server-side query.

Autocomplete that knows scope

Keywords, tables, columns, aliases, and stored-procedure arguments as you type.

A formatter with a safety contract

Output is re-lexed and verified token-for-token; anything off returns your SQL untouched.

History & saved queries

Every run logged locally; named queries and templates one click away.

A real editor

Find & replace, folding, multi-cursor, column select, split view, proper IME input.

Export everywhere

CSV, JSON, Markdown, HTML, XML, SQL — and real .xlsx workbooks, not CSVs in a trench coat.

Explorer with DDL

Drill-down tree, object definitions, script as CREATE / ALTER / DROP.

Credentials done right

OS keyring storage, fail-closed TLS, Entra ID sign-in, one-file import/export.

Palette & keybindings

Every command one fuzzy search away, rebound to your muscle memory.

Native everywhere

One GPU-rendered app for macOS, Windows, and Linux.

The bonus

The premium feel — details you’d start missing on day one anywhere else.

Plans, translated ✓ ships

Execution plan findings in plain language, ranked by the cost they explain, each with its fix attached. Compare two plans side by side.

Edit rows in generated forms ✓ ships

Right-click a row for a form built from the table’s own metadata — foreign-key dropdowns, CHECK constraints validated before the save leaves the app.

Diff & snapshot results ✓ ships

Compare two result sets row by row — adds, removes, and unchanged, with mismatched schemas called out. Name a snapshot and diff against it later.

Charts & conditional formatting ✓ ships

Chart any result set, color-scale a column, add data bars — and export the chart as SVG.

Look inside cells ✓ ships

JSON and XML open as collapsible, searchable trees; binary opens as a hex dump.

Nine admin tools ✓ ships

Activity monitor, backup/restore, schema compare, Query Store, Extended Events, template explorer, guided table/index/FK designers, procedure mode.

Organize like you think ✓ ships

Group servers by client → project → environment, give each its own colors and icons, watch connection health, and wander the relationship graph.

Azure that behaves ✓ ships

Entra sign-in, subscription-grouped server discovery, and a firewall rule offered the moment the server says no.

Everything is a file ✓ ships iCloud ○ next

History, snippets, connections, settings — plain files on disk. Grep them, back them up, drop them in git.

Try it in your browser ✓ ships

The actual app, compiled to WebAssembly, running in a tab against a sample database — before you download anything.

The magic

The genuinely novel parts. The reason this page exists.

A directive language for results ✓ ships

The arrangement of your results lives in the query itself, as ordinary SQL comments: which columns lead, how they’re formatted, when they light up, what they chart. Arrange a result in the UI and SQLly writes the comment — open the file on any machine and it comes back identical. Read the docs

Pivot, built in ✓ ships

A cross-tab without a wizard, a separate tool, or a single line of PIVOT SQL. Two comments describe the rows, columns, and aggregate; the result grid reshapes itself and the arrangement travels with the file. Read the docs

Computed columns ✓ ships

Add a column to the result with a formula, not another pass of SQL. ! names refer to the columns you already selected; place the new column anywhere in the grid. Read the docs

Natural-language dates ✓ ships

Type the date the way you say it. SQLly writes the real literal and keeps your words beside it as a comment — and one command refreshes every dated literal against today, so a saved query never goes stale. Read the docs

Table value introspection ✓ ships

Completions that read your data, not just your schema: finish a WHERE comparison from the column’s real values, and on a foreign-key column, the referenced names instead of bare ids. Read the docs

Query the schema you’re building ✓ ships

Your live database is the foundation; newer local DDL files win. SQLly swaps them in for IntelliSense, so you write SQL against the schema that’s coming — before it lands. Read the docs

IntelliSense for half-written DDL ✓ ships

Sketch a table that isn’t valid yet and SQLly overlays its best guess on the real schema — tagged as inferred, with its confidence, never passed off as authoritative. Read the docs

Prod answers to your thumb ◐ building

Require Touch ID or Windows Hello to connect — or before anything that isn’t a SELECT. Rules ride the same hierarchy as everything else: set it on a client, inherit it everywhere. Read the docs

Fifty million rows, flat memory ✓ ships

Results stream in and spill to disk; the grid pages from disk while memory stays flat. Fifty rows or fifty million, the app doesn’t blink. Read the docs

A tunnel the relay can’t read ◐ building

Reach databases your machine can’t see — end-to-end encrypted through a relay that routes your traffic but can never read it. From any device, no VPN ritual. How it works

Also in the spells drawer: SQLly Embedded — the whole workbench inside your own web app ✓ · every IntelliSense bug report becomes a permanent regression test ✓ · live DDL git blame ○ · foreign keys complete as names, everywhere ✓ · the magic-string decoder ○

That’s the highlights reel — not the whole pig

SQLly has a great deal more to offer than fits on one page. Wander the docs for everything else, then give it a try — it’s free.