This connects Claude to MigrationPilot's PostgreSQL migration analyzer, letting you check schema changes for production safety issues through 83 rules that catch blocking locks, table rewrites, and dangerous patterns. You get analyze commands for single files, check operations for directories, and plan visualizations showing lock timelines. The tool parses with libpg-query and flags things like missing CONCURRENTLY on indexes, NOT VALID on constraints, and lock_timeout settings. Twelve rules support auto-fix. Useful when you're reviewing migrations in chat, debugging why a deploy blocked production traffic, or needing Claude to explain why ALTER COLUMN TYPE will rewrite your entire table. Works with any framework since it analyzes raw SQL.
claude mcp add --transport stdio mickelsamuel-migrationpilot uvx migrationpilot