pg-schema-diff vs Skeema
pg-schema-diff
github.com
Skeema
skeema.ioSide by side
| Figure | pg-schema-diff | Skeema |
|---|---|---|
| Price from | — | $54.08/mo |
| Free plan | — | Yes |
| Free trial | — | — |
| Open source | — | — |
| Windows | — | Yes |
| macOS | — | Yes |
| Linux | — | Yes |
| Self-hosted | Yes | — |
| Plans published | 0 | 6 |
| Spec score · Database Schema Comparison Tools | 6.9 (#18) | 7.9 (#7) |
| Spec score · Database Migration Tools | 6.9 (#29) | 7.8 (#17) |
| Purpose | pg-schema-diff compares Postgres schemas and generates SQL migrations to move between them with minimal downtime and locks. | Skeema is a declarative SQL-based schema management utility that applies changes expressed as CREATE statements in a repository to MySQL and MariaDB tables and routines. |
| Support | The contribution guide says maintainers will try to respond to bug reports, feature requests, and questions within one week. | Public technical support is available to all CLI users through GitHub issues, while private technical support is included with Max. |
Plans
Skeema
- CommunityFree
- Plus$124 a month
- Max$499 a month
- Skeema Cloud Linter$649 a year
- Plus$1,238 a year
- Max$4,988 a year
In their own words
pg-schema-diff
pg-schema-diff has no write-up on Specifiction yet; its figures are above.
Skeema
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.