Chain steps like array methods — filter, sort, group, join — and watch the rows change at every step. The SQL is always on screen. SQLite and MySQL, 100% local.
SELECT * FROM orders
| id | customer_id | status | total | created_at |
|---|
Designed for developers who understand data but find raw SQL friction-heavy.
Chain WHERE, SELECT, ORDER BY, GROUP BY, JOIN, and raw SQL steps. Each step shows its intermediate result — like .filter().map() for your database.
Every pipeline generates readable, debuggable SQL using named CTEs. Copy it, paste it anywhere — or just learn from what the visual builder produces.
WITH step_1 AS ( SELECT * FROM orders WHERE status = 'delivered' ) SELECT * FROM step_1 ORDER BY total DESC
Stage INSERT, UPDATE, and DELETE changes. Review a full diff before applying. Commits as a single atomic transaction — one constraint failure rolls it all back.
Hover any foreign key cell to reveal a → table chip. Click it to jump to the referenced table pre-filtered to that row. A breadcrumb trail keeps you oriented.
No cloud, no subscription, no data leaves your computer. Quarry talks directly to your .db file via Rust — zero latency, maximum privacy.
Previews stay small and fast on large tables; full results are fetched only when you export.
Free, open source, no account required.
Loading latest release…
Not sure which Mac you have? Check → About This Mac. Looking for older versions or other platforms? See the GitHub releases page.
Once installed, the app auto-updates — no manual re-downloads needed.