diffesq.

Compare two SQLite databases — privately, in your browser

To compare two SQLite databases, drop both files into Diffesq: every table becomes a tab, with schema changes (tables, columns, indexes, views), per-column statistics, and key-matched row differences — without uploading either database. Declared primary keys are used to match rows automatically.

The database is read entirely on your device by SQLite compiled to WebAssembly, served from this site — no third-party CDN, no server. Encrypted databases are detected and rejected with a clear message.

Compare two SQLite databases

How it works

  1. Open the Diffesq workbench and drop a .sqlite or .db file on each side.
  2. Diffesq reads each database's tables, indexes and views on your device, then compares schema, statistics, and rows keyed on each table's primary key.
  3. Review the layers per table, adjust keys or tolerance, and export the results — all locally.

What the comparison covers

  • Tables added/removed; per-table column changes; index and view definition changes.
  • Per-column statistics compared side by side, exact even for very large tables.
  • Primary-key row matching with composite keys and numeric tolerance options.
  • BLOB columns compared by content hash; unicode and RTL text render correctly.
  • Cross-format comparison against CSV, Parquet, JSON Lines, and Arrow files.
  • Exports: Markdown/JSON reports, changed rows as CSV, and the schema diff as text.

Free vs Pro

Structured-file comparisons run in full on your device on the free tier, with about a third of the results shown as a preview; Pro unlocks the complete results and clean, unwatermarked exports (HTML, Markdown, JSON, PDF).

See Pricing for plans — $6/month, $48/year, or $119 once.

Privacy

Every comparison runs locally in your browser. Your files are never uploaded — there is no server that receives them, and the page keeps working with Wi-Fi turned off. Details in the Privacy Policy.

Frequently asked questions

Can it open encrypted (SQLCipher) databases?

No — encrypted databases can't be read without decryption. Diffesq detects them and tells you to export an unencrypted copy instead of showing a wrong result.

Do I need an account?

No. Comparisons run without any signup. Pro features unlock with a license key — still no account or login.

Does it work offline?

Yes — once the page has loaded, parsing, comparing, and rendering all happen on your device. Turn off Wi-Fi and it still works.

Related