Sqitch

SQL

Sqitch uses change-based SQL migration scripts organized in deploy/revert/verify directories.

Auto-Detection

MigrationPilot auto-detects Sqitch via sqitch.conf or the deploy/ directory.

Migration Path

Default migration file pattern:

deploy/**/*.sql

Setup

# Analyze deploy scripts (the forward migrations)
npx migrationpilot check ./deploy

# Analyze a single change
npx migrationpilot analyze deploy/add_users.sql

GitHub Action

Add to your CI workflow:

- uses: mickelsamuel/migrationpilot@v1
  with:
    path: deploy/
    pattern: "*.sql"

Configuration

Add a config file to set the default migration path:

# .migrationpilotrc.yml
migrationPath: "deploy/**/*.sql"
failOn: critical

← All docs Configuration guide