DBDiff vs Skeema

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.

Skeema is a declarative, SQL-based schema management utility for applying repository changes to MySQL and MariaDB tables and routines. It generates SQL DDL from schema files and provides diff, lint, push, and pull commands. Configurable linter rules identify unsafe changes, and Skeema verifies generated ALTER TABLE statements in a workspace before proceeding. For online schema changes, it supports database-native alterations and external tools including pt-online-schema-change and gh-ost, with execution configurable by environment and table size. Schema directories can map to multiple servers or schemas, and the utility can detect drift across shards. Listed compatibility includes MySQL 5.5–9.7, MariaDB 10.1–12.3, and Percona Server; AWS Aurora MySQL 5.7–8.4 is listed for Premium. Skeema Cloud Linter can provide automatic diff and lint output for related GitHub commits. All editions can use SSL/TLS, while Premium adds client certificates, CA verification options, and SSH tunnels. The Community plan is free at free. Plus costs $124 a month and Max costs $499 a month.