← All docs

Flyway

SQL

Flyway uses versioned SQL migration files (V1__description.sql). Perfect fit for MigrationPilot.

Auto-Detection

MigrationPilot auto-detects Flyway via flyway.conf or the sql/ directory with V*.sql files.

Migration Path

Default migration file pattern:

sql/**/*.sql

Setup

# Flyway migrations are raw SQL — ideal for MigrationPilot
npx migrationpilot check ./sql --pattern "V*.sql"

# Or analyze a single migration
npx migrationpilot analyze sql/V2__add_users.sql

GitHub Action

Add to your CI workflow:

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

Configuration

Add a config file to set the default migration path:

# .migrationpilotrc.yml
migrationPath: "sql/**/*.sql"
failOn: critical
← All docsConfiguration guide