SQLite Database Diff - Compare Two Databases

Compare two SQLite databases and find schema and data differences. Identify added, removed, and modified tables and rows.

Database A (Base)

Drop base database here

Drop compare database here

Load two databases and click Compare

Schema differences (tables, columns, types) and optionally data differences (added, removed, modified rows).

Rows are matched by primary key. If a table has no primary key, all columns are used for comparison.

No. Both databases are loaded locally using SQL.js. Nothing leaves your browser.

Schema comparison works well for any size. Data comparison may be slow for tables with many rows.

Column order differences are detected and reported as schema changes.

Yes. Export as JSON for programmatic use or as text for documentation.

Modified columns (type changes, nullability) are reported. Data comparison only covers matching columns.

Yes. For modified rows, both old and new values are shown for changed columns.

Not automatically. The tool reports differences; you can write migration scripts based on the output.

Standard SQLite files: .sqlite, .db, .sqlite3, .db3