Built for SQLite. Nothing else.

The SQLite GUI that actually understands SQLite

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

$39.99 $26 launch price until May 9, 2026 — SQLite's birthday. No subscription. macOS 14+.

QueryLight app — SQL editor, data grid, schema browser, and JSON inspector

What sets QueryLight apart

Database health and PRAGMAs, at a glance

Integrity checks, fragmentation analysis, storage breakdown, and one-click maintenance. Tune PRAGMAs visually — WAL mode, cache size, synchronous level. No more memorizing obscure commands.

PRAGMA inspector — storage stats, configuration, recommendations, and one-click maintenance

Only in QueryLight

Full-text search, managed visually

Create FTS5 indexes, configure tokenizers, test queries with match highlighting. Finally treat full-text search as a first-class feature.

FTS5 Manager — tokenizer config, content mode, prefix sizes for full-text search indexes

JSON columns as structured data

Expand JSON columns into navigable trees. Query nested fields visually. Stop squinting at raw JSON strings in table cells.

JSON tree viewer — expand nested objects, arrays, and values with color-coded types

See how SQLite executes your query

EXPLAIN QUERY PLAN rendered as a flow diagram. Spot full table scans, understand join order, compare plan changes side by side.

Visual query plan — SCAN and SEARCH cards with bytecode view

Only in QueryLight

Know exactly how fast your queries run

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.

Performance profiler — 10 runs with min/median/p95/max timing on a full table scan

Compare databases and generate migrations

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.

Schema diff — side-by-side comparison with migration SQL generation

See your schema as a relationship diagram

Auto-generated ER diagrams with crow's foot notation. Foreign keys visualized as connections. Show or hide tables, zoom and pan to explore.

ER diagram — entity cards with columns and foreign key relationships

Everything you expect, and more

Schema Browser

Tables, views, indexes, triggers — all in a navigable tree.

Query Editor

Syntax highlighting, autocomplete, and Tree-sitter parsing.

Data Grid

Inline editing, filtering, sorting, and pagination built in.

Import & Export

CSV, JSON, SQL, and full database dumps.

Cloudflare D1

Connect to D1 databases via API. Query remotely.

Read-Only Default

Opens databases read-only. Prevents accidental writes.

Multiple Databases

Attach and query across databases in one session.

Native Performance

Swift + AppKit. No Electron. Instant startup.

Tree-sitter Parsing

Real SQL parsing, not regex. Accurate highlighting and structure.

Encrypted Databases

Open SQLCipher databases with AES-256 encryption.

Quick Open

Cmd+P command palette. Fuzzy-search tables, views, and actions.

Query Snippets

Save, tag, and reuse your most frequent queries.

Schema Editor

Create and alter tables, indexes, and triggers visually.

Multi-tab Editor

Multiple SQL tabs with independent results per tab.

CLI Tool

Open databases from your terminal with one command.

How QueryLight compares as of March 2026

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.

QueryLight

$39.99 $26

One-time purchase. Yours forever.

$26 for the 26th birthday — launch price until May 9, 2026

All v1 features
PRAGMA inspector & Health Dashboard
FTS5 management
JSON tree viewer
Visual query plans & profiler
Schema diff & ER diagrams
Encrypted databases & Cloudflare D1
Free v1 updates forever
No subscription. No telemetry.

Buy QueryLight — $26

Support development

Supporter

$79.99

One-time purchase. Free major upgrades forever.

Everything in QueryLight
Pro features in every future major version
Support an indie developer
No subscription. No telemetry.

Buy Supporter — $79.99