The database client that thinks in queries, not tabs.
Saved queries with variables, toggleable filters and group-by dimensions, schema-aware autocomplete and a readable EXPLAIN, in a native app.


Reusable queries
Variables & conditions
Define named parameters and conditional WHERE clauses you can toggle on and off without editing the raw SQL.
{{#where}}
[[o.status = {{status}}]]
{{/where}}
LIMIT {{limit:raw}}

Data exploration
Dimensions
Toggle group-by dimensions as chips. The SELECT list and GROUP BY clause update to match, with no rewriting of the aggregation.
{{#dimensions}}
[[c.country]]
[[o.channel]]
{{/dimensions}}
SELECT {{dimensions:select}} count(*) AS orders
FROM orders o
JOIN customers c ON c.id = o.customer_id
{{dimensions:group_by}}

Schema intelligence
Autocomplete
Suggestions for keywords, functions, tables and alias-qualified columns, plus foreign-key aware JOIN and ON completions from your live database.
SELECT o.id, c.email FROM orders o JOIN


Query optimisation
EXPLAIN, visualised
Run EXPLAIN from the toolbar. The rolled-back transaction keeps the data untouched, and the plan renders as a collapsible tree.
EXPLAIN ANALYZE <your query> -- runs the query, then rolls the transaction back


Try SQLary on your own database
Download for macOS (Apple Silicon)
Also available for Windows (x64)