Enterprise DNAEnterprise DNA
MMCP ServersDeveloperlow

mickelsamuel/migrationpilot

by Various

PostgreSQL migration linter. Blocks unsafe migrations before merge: 112 rules, the real Postgres parser, lock analysis, auto-fix. CLI, GitHub Action, MCP.

MCP

mickelsamuel/migrationpilot

Added 3 Sept 2026

#ai#cli#database#ddl#developer-tools#devops#github-action#linter
Catalogue record, not a reviewed recommendation. This record can include automatically collected descriptions and setup details. Confirm important claims with the original source. Explore source-reviewed tools.

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

Clients listed in this record (not verified here)

Claude Code, Cursor, VS Code

Notes

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

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

Pairs with

Other entries in the index that connect to this one. Click through to see the chain.

Free 27-page guide

Get the free Developer’s Field Guide

A 27-page field guide to the AI coding workflow with Claude. Claude Code, MCP servers, the prompt patterns that work, and what to delegate. Free.

Enter your work email. We send it straight over, plus a few short notes worth knowing. Unsubscribe any time.

No spam. Unsubscribe any time.