goose

Auto-Detection

MigrationPilot auto-detects goose via the migrations/ directory with SQL files containing -- +goose markers.

Migration Path

Default migration file pattern:

migrations/**/*.sql

Setup

# goose SQL migrations work directly with MigrationPilot
npx migrationpilot check ./migrations

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

GitHub Action

Add to your CI workflow:

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

Configuration

Add a config file to set the default migration path:

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