Catch dangerous PostgreSQL migrations before they reach production with 83 built-in rules and lock analysis. For developers and DBAs automating migration safety checks in CI/CD pipelines.
io.github.mickelsamuel/migrationpilot
Local install
STDIO
No auth required
How models use it and what it is built for.
Catch dangerous PostgreSQL migrations before they reach production with 83 built-in rules and lock analysis. For developers and DBAs automating migration safety checks in CI/CD pipelines.
Local install — runs as a subprocess.
Where to find authoritative docs and source for Mickelsamuel Migrationpilot.
Paste any of these into Agent Studio after connecting Mickelsamuel Migrationpilot.
Common questions about connecting and running Mickelsamuel Migrationpilot.
What kinds of PostgreSQL migrations does MigrationPilot catch?
It detects 83 categories of dangerous operations including blocking locks, missing indexes, and operations that could cause downtime. The server analyzes migrations before they run and can auto-fix common issues.
How do I install and run MigrationPilot?
Install via npm with `npx migrationpilot@1.5.0`. It runs as an MCP server over stdio, so you can connect it to Claude or other tools that support the Model Context Protocol.
Can MigrationPilot automatically fix unsafe migrations?
Yes, it includes auto-fix capabilities for many common issues. You can review the suggested fixes before applying them to your migration files.
Does MigrationPilot work in CI/CD pipelines?
Yes, the stdio transport makes it suitable for automation. You can integrate it into your deployment pipeline to gate migrations that fail safety checks.
What's the difference between lock analysis and rule checking?
Lock analysis predicts which database locks a migration will acquire and whether they'll block concurrent queries. Rule checking applies the 83 built-in patterns to catch known dangerous patterns and anti-patterns.
MCP Playground runs 10,000+ hosted MCP servers — GitHub, Linear, Notion, Stripe, Sentry and more — across Claude, GPT, Gemini, DeepSeek and 30+ AI models. Compare model answers side-by-side, save agent presets, share runs. Zero install.
Open Agent Studio