PRAGMA inspector. FTS5 management. JSON tree viewer. Visual query plans. A native macOS app purpose-built for the features other tools ignore.
Download for macOS
Integrity checks, fragmentation analysis, storage breakdown, and one-click maintenance. Tune PRAGMAs visually — WAL mode, cache size, synchronous level. No more memorizing obscure commands.
Create FTS5 indexes, configure tokenizers, test queries with match highlighting. Finally treat full-text search as a first-class feature.
Expand JSON columns into navigable trees. Query nested fields visually. Stop squinting at raw JSON strings in table cells.
EXPLAIN QUERY PLAN visualized as interactive cards. Spot full table scans, understand join order, and see bytecode detail for every step.
Run queries N times, see min/median/p95/max timing. Heat-map overlays on query plan cards highlight where time is spent. Compare before and after adding an index.
Diff two SQLite databases side by side. See missing tables, changed columns, new indexes. Generate the migration SQL to bring one in sync with the other.
Auto-generated ER diagrams with crow's foot notation. Foreign keys visualized as connections. Show or hide tables, zoom and pan to explore.
See every SQL statement executed with timing, row counts, and full detail. Filter by source, click to inspect. Know exactly what happened and when.
Cmd+P opens a command palette with fuzzy search across tables, views, snippets, history, and 30+ actions. Navigate your database without touching the mouse.
Auto-discovers SQLite databases in running simulators. One click to open your app's CoreData or SwiftData store. No more digging through ~/Library.
BLOB columns rendered as visual previews — images, PDFs, archives, even nested SQLite databases. Export or replace binary data directly.
Query Cloudflare D1 and Turso databases directly. Save connections as favorites. Same full-featured UI for local and remote databases.
Tables, views, indexes, triggers — all in a navigable tree.
Syntax highlighting, autocomplete, and Tree-sitter parsing.
Inline editing, filtering, sorting, and pagination built in.
CSV, JSON, SQL, and full database dumps.
Connect to D1 databases via API. Query remotely.
Opens databases read-only. Prevents accidental writes.
Attach and query across databases in one session.
Swift + AppKit. No Electron. Instant startup.
Real SQL parsing, not regex. Accurate highlighting and structure.
Open SQLCipher databases with AES-256 encryption.
Cmd+P command palette. Fuzzy-search tables, views, and actions.
Save, tag, and reuse your most frequent queries.
Create and alter tables, indexes, and triggers visually.
Multiple SQL tabs with independent results per tab.
Open databases from your terminal with one command.
Click foreign key values to jump to the referenced row.
Auto-decodes Z_-prefixed tables to original entity names.
Detects external database changes and refreshes automatically.
Open databases appear in macOS Spotlight results.
Bind ? placeholders with a type-aware input dialog.
Open databases and run queries from Shortcuts app.
| Feature | QueryLight | DB Browser | Base | TablePlus | DataGrip |
|---|---|---|---|---|---|
| Native macOS | ✓ | ✕ | ✓ | ✓ | ✕ |
| SQLite-focused | ✓ | ✓ | ✓ | ✕ | ✕ |
| PRAGMA inspector | ✓ | ✓ | ✕ | ✕ | ✕ |
| FTS5 management | ✓ | ✕ | ✕ | ✕ | ✕ |
| JSON tree viewer | ✓ | ✕ | ✕ | ✓ | ✓ |
| Visual query plans | ✓ | ✕ | ✕ | ✕ | ✓ |
| Health dashboard | ✓ | ✕ | ✕ | ✕ | ✕ |
| Autocomplete | ✓ | ✓ | ✓ | ✓ | ✓ |
| Inline editing | ✓ | ✓ | ✓ | ✓ | ✓ |
| Cloudflare D1 | ✓ | ✕ | ✕ | ✕ | ✓* |
| Performance profiler | ✓ | ✕ | ✕ | ✕ | ✕ |
| Schema diff | ✓ | ✕ | ✕ | ✕ | ✓ |
| ER diagram | ✓ | ✕ | ✕ | ✕ | ✓ |
| Encrypted databases | ✓ | ✓ | ✕ | ✓ | ✓ |
| Price | $39.99 $26 | Free | ~$25 | $99/yr | Free* |
DB Browser for SQLite is a great free tool. QueryLight is for developers who want deeper SQLite-specific features and a native Mac experience. *DataGrip free for non-commercial use. D1 support via third-party JDBC driver.
One-time purchase. Yours forever.
$26 for the 26th birthday — launch price until May 9, 2026
One-time purchase. Free major upgrades forever.
Found a bug or have a suggestion? Let us know.