Chain steps like array methods — filter, sort, group, join. See the CTE-based SQL it generates. Runs 100% locally.
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.
Supports any SQLite file up to the limits of your disk. Large files work fine — queries stream results in pages.
Free, open source, no account required.
Releases coming soon — watch the repo to be notified.
Once published, the app auto-updates — no manual re-downloads needed.