Production operations
for SQLite at scale
SQLite runs everywhere now — Turso, Cloudflare D1, the edge, every mobile app. The operations tooling never caught up. Litescope is the missing toolchain: diff, validate, migrate, and monitor — one database or an entire fleet.
Schemas change. Nobody's watching.
A migration runs clean. Monitoring stays green. Three weeks later a column is gone, a foreign key is broken, and a backup you never tested can't be restored.
Postgres has a decade of tooling for this. SQLite — now running production workloads on Turso and D1 — has almost none. You're left with sqldiff and hope.
Litescope closes the gap with the operations primitives production databases need.
Every operation, one binary
A pure-Go CLI with zero dependencies. Works on local files and remote databases through the same commands.
See what changed
Human-readable schema and data diff between any two databases. JSON, Markdown, and HTML output for CI and PR comments.
Lock migrations to a spec
Snapshot the expected migration once, then fail CI loudly if anything unexpected changes.
Trust your backups
PRAGMA integrity verification plus schema and row-count comparison against a reference. Catch a bad backup before you need it.
Generate & apply safely
Turn a diff into runnable SQL, then apply it with an automatic backup, a single transaction, FK verification, and rollback on any failure.
Catch drift continuously
Baseline a known-good schema, then watch for unplanned changes with webhook alerts to Slack and Discord.
Operate hundreds at once
Discover, baseline, drift-check, and migrate an entire Turso org or D1 account — in parallel, from one command.
One database is monitoring.
A hundred is a fleet.
Per-tenant SQLite is exploding — and nobody has tooling for the day you're running 300 of them. Litescope does.
- →Auto-discovery. Query a Turso org or D1 account and register every database into a checked-in config.
- →Parallel drift detection. “309 ok, 1 drifted, 1 unreachable” across the whole fleet in seconds. Exit 1 gates your CI.
- →Staged migrations. Roll one migration out across the fleet, halting at the first failure so a bad change can't cascade.
- →Canary rollouts. Apply to the first N databases, verify, then continue — with per-database backups and rollback.
Free to use. Pro for power users.
Core operations are free forever. Pay once for continuous monitoring and advanced features.
- diff, schema, validate, check
- migrate — generate & apply
- Turso, D1 & local sources
- Up to 3 named connections (GUI)
- Everything in Free
- monitor watch — continuous drift detection
- Webhook alerts (Slack, Discord)
- Drift reports & audit history
- fleet — parallel ops across Turso & D1
- Unlimited named connections (GUI)
| Feature | Free | Pro — $49 |
|---|---|---|
| Core CLI | ||
| diff — schema & data diff | ✓ | ✓ |
| validate — migration locking | ✓ | ✓ |
| check — integrity & backup verify | ✓ | ✓ |
| migrate — generate & apply with rollback | ✓ | ✓ |
| Monitoring | ||
| monitor snapshot & one-off check | ✓ | ✓ |
| monitor watch — continuous drift detection | ✗ | ✓ |
| monitor schedule — cron-based checks | ✗ | ✓ |
| Webhook alerts (Slack, Discord) | ✗ | ✓ |
| --save-report drift history | ✗ | ✓ |
| Fleet (Turso & D1) | ||
| fleet check — parallel drift across all DBs | ✗ | ✓ |
| fleet migrate — staged rollout with canary | ✗ | ✓ |
| GUI (Desktop App) | ||
| Named connections | 3 max | Unlimited |
| Drift Monitor panel | ✗ | ✓ |
Up and running in seconds
One pure-Go binary. No runtime, no dependencies.