Prisma

TypeScript / JavaScript

Prisma uses declarative schema files and generates SQL migrations via prisma migrate.

Auto-Detection

MigrationPilot auto-detects Prisma via the prisma/ directory.

Migration Path

Default migration file pattern:

prisma/migrations/**/*.sql

Setup

# Generate a migration (creates SQL file)
npx prisma migrate dev --name add_users

# Analyze the generated migration
npx migrationpilot analyze prisma/migrations/*/migration.sql

# Check all migrations
npx migrationpilot check prisma/migrations --pattern "*/migration.sql"

GitHub Action

Add to your CI workflow:

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

Configuration

Add a config file to set the default migration path:

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

← All docs Configuration guide