MigrationPilot

MigrationPilot is a static analysis tool for PostgreSQL schema migrations that parses SQL using the libpg-query PostgreSQL parser, classifies locks, flags dangerous patterns with 83 safety rules, scores risk, and suggests safe alternatives — all without touching a database. Current stable version is 1.5.0, released as an npm package and GitHub Action. Key differentiators: works offline via static analysis, supports CLI/Library/GitHub Action, auto-detects 14 migration frameworks, includes a git hook, and generates SARIF output for code scanning. Requires Node.js >=22.