pgquarrel vs Skeema

pgquarrel compares PostgreSQL database schemas and produces SQL commands to bring a target schema in line with a source. It connects to PostgreSQL servers and reads catalog metadata directly, rather than depending on tools such as pg_dump. The project describes deploying schema changes to testing, staging, or production as its main use. Filters can narrow comparisons to selected object types or include and exclude schemas by pattern. Output goes to stdout by default, with options to save it to a file, print a summary, or place changes in one transaction. pgquarrel does not manipulate table data with INSERT, UPDATE, DELETE, or COPY. Its documented object coverage includes both complete and partial support; inheritance and roles are noted absences, and not all PostgreSQL objects are supported. Output may not work as expected when the source PostgreSQL version is newer than the target. The software is free under the BSD-3-Clause license, distributed as source through GitHub or a Git clone, and the listed latest release is 0.7.0.

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.