Documentation
Everything you need to get started with MigrationPilot.
Getting Started
Quick Start
Get started with MigrationPilot in under 2 minutes.
Configuration
Configure MigrationPilot with a YAML config file or package.json.
GitHub Action
Run MigrationPilot as a GitHub Action to catch unsafe migrations in pull requests.
CI Integration
Integrate MigrationPilot with GitHub Actions, GitLab CI, Bitbucket Pipelines, and other CI systems.
Programmatic API
Use MigrationPilot as a library in your Node.js applications.
CLI Reference
Complete reference for all MigrationPilot CLI commands and options.
Framework Guides
Step-by-step setup for your migration framework.
Prisma
TypeScript / JavaScript
Prisma uses declarative schema files and generates SQL migrations via prisma mig...
Django
Python
Django generates Python migration files that execute SQL. Use sqlmigrate to extr...
Knex.js
JavaScript
Knex.js uses JavaScript migration files. Write raw SQL migrations for best resul...
TypeORM
TypeScript / JavaScript
TypeORM generates migration files with up/down methods. Use query logging to ext...
Drizzle ORM
TypeScript
Drizzle generates SQL migration files via drizzle-kit....
Sequelize
JavaScript
Sequelize uses JavaScript migration files with queryInterface methods....
Ruby on Rails
Ruby
Rails Active Record migrations are Ruby files. Extract SQL with schema statement...
Ecto (Elixir)
Elixir
Ecto migrations are Elixir modules. Use raw SQL execute statements for best resu...
Flyway
SQL
Flyway uses versioned SQL migration files (V1__description.sql). Perfect fit for...
Liquibase
SQL / XML / YAML
Liquibase supports multiple changelog formats. Use SQL changelogs for best resul...
Alembic
Python
Alembic migrations are Python files. Use alembic upgrade --sql to extract SQL....
goose
Go / SQL
goose uses SQL or Go migration files. SQL migrations work directly with Migratio...
dbmate
SQL
dbmate uses plain SQL migration files. Perfect fit for MigrationPilot....
Sqitch
SQL
Sqitch uses change-based SQL migration scripts organized in deploy/revert/verify...
Rules Reference
80 safety rules covering locks, data safety, and best practices.
All Rules
Browse all 80 safety rules with severity, examples, and configuration.
Cloud Provider Guides
Production context setup for your PostgreSQL provider.
Amazon RDS for PostgreSQL
Amazon RDS manages PostgreSQL instances with automated backups, failover, and sc...
Google Cloud SQL
Cloud SQL provides fully managed PostgreSQL instances on Google Cloud....
Neon
Neon is serverless PostgreSQL with branching, autoscaling, and instant provision...
Supabase
Supabase provides a PostgreSQL database with auth, storage, and realtime built i...
Railway
Railway provides instant PostgreSQL databases with automatic backups and easy de...
Crunchy Data (PGO)
Crunchy Data provides enterprise PostgreSQL via PGO (Postgres Operator) on Kuber...
Aiven for PostgreSQL
Aiven provides managed PostgreSQL with multi-cloud support and advanced monitori...
CockroachDB
CockroachDB is a distributed SQL database with PostgreSQL wire compatibility....
DigitalOcean Managed Databases
DigitalOcean provides managed PostgreSQL with automated failover, backups, and s...