Compare two SQLite databases
See what changed between two SQLite files.
Open two SQLite files in DiffyPick and it lists every table, column and index that differs — then generates the SQL to line them up. SQLite is free, forever.
Why it is harder than it should be
SQLite has no server and no built-in schema-compare GUI, so spotting what changed between two files usually means eyeballing .schema output.
DiffyPick reads both files directly and shows the difference as a clean, per-object list.
The manual way
You can run .schema on both databases and diff the text, or reach for sqldiff — but sqldiff is CLI and mostly about row data, not a schema sync.
And SQLite can only ALTER away so much: dropping a column tied to a key, index or constraint — or changing a key — needs a full table rebuild.
DiffyPick generates that table-rebuild SQL for you, and shows it before it runs.
With DiffyPick
Open both files
Pick the two SQLite files — each file is its own database.
Compare
Every differing table, column, index and trigger is listed as a diff, color-coded and searchable.
Review and sync
Preview the generated SQL — including any table rebuilds — pick what to apply, and run it.
What you get
- Free for SQLite — no account, no time limit.
- A per-object diff, not a text dump.
- Table-rebuild SQL generated for the changes SQLite cannot ALTER.
- Upgrade to compare PostgreSQL, MySQL, SQL Server and MariaDB when you need it.
Compare your SQLite files now — free.
SQLite is free with no account and no time limit. Add the other engines whenever you like.