MigrationPilot MCP server

MigrationPilot is a safety checker for PostgreSQL migrations. It looks at the SQL your AI wrote and tells you if it could lock a table, block your app, or cause an outage. It is handy for anyone who lets an AI assistant write database changes.

What this MCP server does

You ask your AI to write or run a database migration. Before doing anything, the AI calls this helper with the SQL. The helper parses the SQL with PostgreSQL's own parser, checks it against 112 lock-safety rules, and returns a pass or fail verdict with a list of problems. Your AI then shows you the verdict, or refuses to apply the migration if it failed.

Click to zoom

What you can do with it

• Check a migration for unsafe locks before it runs
• Get a pass or fail verdict with a risk score
• See which rule was broken and why it matters
• Get a suggested safe rewrite of the SQL
• Explain what lock a single SQL statement takes
• Analyze a whole folder of migration files at once
• Look up what any of the 112 rules means

Try asking your AI

• “Check this migration before you run it: ALTER TABLE users ADD CONSTRAINT users_email_unique UNIQUE (email);”
• “Is it safe to add a NOT NULL column to the orders table?”
• “What lock does CREATE INDEX take on a big table?”
• “Analyze all the SQL files in my migrations folder and tell me which ones are risky”

What it gives back to you

You get a short verdict in the chat: pass or fail, a risk score out of 100, and a list of violations. Each violation names the rule, explains why it is dangerous, and often shows a safer version of the SQL. For a folder, you get a per-file summary plus an overall picture.

Before you start

Who it's for

Developers and database-minded teammates who let an AI assistant write PostgreSQL migrations and want a safety net before those changes hit production.