pgroll
7.3#3 in database migration toolsFree planFree planLinuxmacOSSelf-hostedWindows
Visit
| Fact | pgroll | Skeema |
|---|---|---|
| Database compatibility | pgroll supports PostgreSQL versions 14 and later and says it works with any PostgreSQL service, including RDS and Aurora. | The site lists support for MySQL 5.5–9.7, MariaDB 10.1–12.3, Percona Server, and—on Premium—AWS Aurora MySQL 5.7–8.4. |
| Purpose | pgroll is an open-source command-line tool for safe, reversible PostgreSQL schema migrations that keep multiple schema versions available simultaneously. | 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. |
pgroll suits developers managing PostgreSQL schema changes who want old and new versions to coexist during application rollout. Teams using PostgreSQL 14 with row-level security should weigh its documented limitation.
Skeema suits teams managing MySQL or MariaDB schema changes through SQL files and repository workflows. Its sharding and drift features may be useful where schemas span multiple servers or databases.