DBDiff vs pg-schema-diff
DBDiff
dbdiff.devpg-schema-diff
github.comSide by side
| Figure | DBDiff | pg-schema-diff |
|---|---|---|
| Price from | — | — |
| Free plan | — | — |
| Free trial | — | — |
| Open source | — | — |
| Windows | Yes | — |
| macOS | Yes | — |
| Linux | Yes | — |
| Self-hosted | — | Yes |
| Plans published | 0 | 0 |
| Spec score · Database Schema Comparison Tools | 7.8 (#8) | 6.9 (#18) |
| License | DBDiff is distributed under the MIT license. | The repository lists the project under the MIT license. |
| Purpose | DBDiff compares two local or remote databases and generates migration files from their schema and data differences. | pg-schema-diff compares Postgres schemas and generates SQL migrations to move between them with minimal downtime and locks. |
| Support | Users can open GitHub issues, and the site provides a contact route for commercial support enquiries. | The contribution guide says maintainers will try to respond to bug reports, feature requests, and questions within one week. |
In their own words
DBDiff
DBDiff compares local or remote databases and creates migration files from their differences. Its drivers support MySQL, PostgreSQL and SQLite, and its schema and data diffing covers tables, views, materialized views, triggers, routines, types, domains, sequences and row-level-security policies. YAML settings and command-line options can include or exclude tables, omit columns, filter rows, and set schema or data scope by table. Migration output includes up and down SQL in native SQL, Flyway, Liquibase XML or YAML, Laravel Migrations and custom templates. A built-in runner offers commands to create, apply, roll back, inspect, validate, repair and baseline migrations. A Supabase option selects PostgreSQL and enables SSL, but limits that diff to the public schema, leaving managed auth and storage schemas out. Pre-built binaries are available for Windows, macOS and Linux without PHP, Node or Composer; PHAR and Composer installs need PHP 8.1 or newer. DBDiff is free, open source under the MIT license.
pg-schema-diff
pg-schema-diff has no write-up on Specifiction yet; its figures are above.