SQLary

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.

SQLary running a saved revenue query with its parameter bar, results grid and sidebar treeSQLary running a saved revenue query with its parameter bar, results grid and sidebar tree
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}}
Top customers query with its parameter bar and enabled conditionsTop customers query with its parameter bar and enabled conditions
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}}
Revenue query with country and channel dimension chips switched onRevenue query with country and channel dimension chips switched on
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
SQL editor with the autocomplete popup suggesting joins from the live schemaSQL editor with the autocomplete popup suggesting joins from the live schema
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
Collapsible EXPLAIN plan tree showing joins, aggregate and sort nodesCollapsible EXPLAIN plan tree showing joins, aggregate and sort nodes

Try SQLary on your own database