Skip to main content
v1.0 — Production ready release

Database diff that
actually ships

Compare any two databases, detect schema drift and data divergence, and generate a safe, reviewable SQL migration pack — in seconds.

brew install deepdiff-db
Supports
MySQLmysqlv0.1
PostgreSQLpostgresv0.1
SQLitesqlitev0.1
SQL Servermssqlv0.8
Oracleoraclev0.9

Everything you need to sync databases safely

A single static binary. Zero native dependencies. Works with your existing CI pipeline.

Schema Drift Detection

Instantly detect added/removed tables, column type changes, nullability drift, index and foreign key changes between any two databases.

SQL Migration Packs

Auto-generate a fully transactional SQL migration pack. DELETE + INSERT for changed rows, ALTER TABLE for new columns — ready to review and apply.

Streaming Large Datasets

Keyset-paginated batch hashing keeps memory flat at O(batch_size) regardless of table size. Parallel table processing cuts wall-clock time by 4×.

Conflict Resolution

Detect rows that differ in both databases. Resolve with configurable ours/theirs/manual strategies or interactively via the CLI.

Interactive HTML Reports

Generate a self-contained HTML report with schema diff viewer, data diff visualizer, conflict highlights, and SQL migration preview.

5 Database Engines

MySQL, PostgreSQL, SQLite, Microsoft SQL Server, and Oracle Database — all with a single static binary and zero native dependencies.

From zero to diff in 60 seconds

One config file. Three commands. Your databases are in sync.

See the full workflow →
bash
# 1. Check connections
deepdiffdb check

# 2. Run a full diff
deepdiffdb diff --html

# 3. Generate migration pack
deepdiffdb gen-pack

# 4. Review + apply
deepdiffdb apply \
  --pack diff-output/migration_pack.sql

Ready to bring your databases in sync?