Related Work

Several tools address migration safety and schema change management for PostgreSQL.

Some of our lint rules are ported from these tools.

Migration Safety

• Eugene - Lint and trace lock behaviour of SQL migrations for PostgreSQL
• Squawk - Linter for PostgreSQL migrations and SQL
• pgfence - PostgreSQL migration safety CLI with lock mode analysis, risk scoring, and safe rewrite recipes
• Strong Migrations - Catch unsafe migrations in development (Ruby / ActiveRecord)

Migration Execution

• pgroll - PostgreSQL zero-downtime migrations made easy