dbmate

Auto-Detection

MigrationPilot auto-detects dbmate via database.yml or the db/migrations/ directory.

Migration Path

Default migration file pattern:

db/migrations/**/*.sql

Setup

# dbmate migrations are raw SQL — ideal for MigrationPilot
npx migrationpilot check ./db/migrations

# Analyze a single migration
npx migrationpilot analyze db/migrations/001_add_users.sql

GitHub Action

Add to your CI workflow:

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

Configuration

Add a config file to set the default migration path:

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