DBDiff compares two local or remote databases and creates a migration file from their differences. Its drivers support MySQL, PostgreSQL and SQLite, and its diff can include tables, views, materialized views, triggers, routines, types, domains, sequences, row-level-security policies and data. YAML settings and CLI options let users include or exclude tables, exclude columns, filter rows and set schema or data scope by table. DBDiff can generate up and down SQL in native SQL, Flyway, Liquibase XML or YAML, Laravel Migrations, or custom templates. A built-in runner includes commands to create, apply, roll back, inspect, validate, repair and baseline migrations. For Supabase, an option selects PostgreSQL and enables SSL; the tool reads the public schema and excludes managed auth and storage schemas. Pre-built binaries are available for Windows, macOS and Linux without PHP, Node or Composer. PHAR and Composer installations require PHP 8.1 or newer. DBDiff is open source under the MIT license.
Who it is for
DBDiff suits developers and database teams who need to compare supported databases and generate migrations. Its runner and migration integrations may fit teams managing schema changes through a CLI or compatible migration tool.
What is good
- Compares MySQL, PostgreSQL and SQLite.
- Generates up and down migration SQL.
- Includes a migration runner with validation commands.
- Pre-built binaries need no PHP, Node or Composer.
- Supports table and row filtering.
What to know first
- Supabase diffs cover only the public schema.
- PHAR and Composer installs require PHP 8.1 or newer.
- Some PostgreSQL changes cannot migrate dependent objects automatically.
Verdict
DBDiff combines database comparison, migration generation and migration-running commands in one open-source tool. Check its Supabase scope and documented PostgreSQL migration limits against your database setup.
Compared on database schema comparison tools
- Migration scripts
- Yes
- Database scope
- multi-engine
- CI/CD integration
- Yes
- Supported platforms
- cross-platform
