Migrationpilot
MCP server mickelsamuel/migrationpilot/io.github.mickelsamuel/migrationpilot
83 rules to catch dangerous PostgreSQL migrations before production. Lock analysis + auto-fix.
claude mcp add migrationpilot -- npx -y migrationpilotAssembled from the repository path, not quoted from the project. Check it against their README if it does not work.
One thing to look at
- 5 stars5 stars. Stars are a popularity signal and not a quality one, but at this level it is likely that nobody has read this closely except its author, and you would be relying on your own review.
In 1 stack
Whose pick this was
Change a schema without taking the site down
Then, before the migration runs anywhere, find out what it locks. It parses the DDL with Postgres's own parser and classifies the lock each statement takes, so "CREATE INDEX blocks writes on users, use CONCURRENTLY" arrives as a review comment rather than as an incident. It also catches the foreign key with no index behind it.
agentscliIn house flow