mickelsamuel/migrationpilot

Overview

PostgreSQL migration linter that blocks unsafe migrations before merge. It applies 112 rules using the real Postgres parser and lock analysis, with auto-fix capabilities. Available as a CLI, GitHub Action, and MCP server.

Best for

Best for
Teams wanting to enforce PostgreSQL migration safety in CI without a commercial tool

Use cases

• Catch unsafe schema changes in CI before merge
• Automatically fix migration issues with the built-in auto-fix
• Analyze lock contention in PostgreSQL migrations

How to use

Install

npx migrationpilot analyze migration.sql

Tools exposed

• check_before_apply
• analyze_migration
• analyze_migration_dir
• get_rule
• suggest_fix
• explain_lock
• list_rules
• migration-path
• github-token
• pg-version
• fail-on
• config-file
• database-url
• license-key
• Auto-fix

Tested with

Claude Code, Cursor, VS Code

Notes

PostgreSQL migration linter that blocks unsafe migrations before merge. It applies 112 rules using the real Postgres parser and lock analysis, with auto-fix capabilities. Available as a CLI, GitHub Action, and MCP server.

7 stars on GitHub. Last updated 2026-08-12. Licensed MIT.

Use cases

• Catch unsafe schema changes in CI before merge
• Automatically fix migration issues with the built-in auto-fix
• Analyze lock contention in PostgreSQL migrations

Pros

• 112 rules covering a wide range of migration pitfalls
• Uses the actual Postgres parser for accurate analysis
• Multiple integration options: CLI, GitHub Action, and MCP

Cons

• Only 7 GitHub stars, indicating limited community adoption
• Vendor listed as ‘Various’, so no dedicated support
• Small user base may mean fewer real-world tested edge cases

Indexed from awesome-mcp-servers-punkpeye and enriched against its public facts.