Prisma Migrate Guard

Use this skill before deploys or CI release steps to verify Prisma migrations are healthy and ready to apply.

What this skill does

• Verifies required Prisma CLI/runtime tools are available
• Validates migration DB URL inputs (DATABASE_URL by default)
• Runs prisma migrate status against a target schema
• Fails on common dangerous states:
  • failed migrations
  • migration drift warnings
  • unapplied migration files
  • missing migration history table hints
• Exits non-zero for CI/deploy gating

Inputs

• Optional env vars:
  • PRISMA_SCHEMA_PATH (default: prisma/schema.prisma)
  • PRISMA_MIGRATE_DB_URL_ENV (default: DATABASE_URL)
  • PRISMA_MIGRATE_GUARD_ALLOW_UNAPPLIED (1 to warn instead of fail)
  • PRISMA_MIGRATE_GUARD_ALLOW_DRIFT (1 to warn instead of fail)

Run

bash scripts/check-prisma-migrate.sh

With explicit schema and env key:

PRISMA_SCHEMA_PATH=apps/api/prisma/schema.prisma \
PRISMA_MIGRATE_DB_URL_ENV=POSTGRES_PRISMA_URL \
bash scripts/check-prisma-migrate.sh

Output contract

• Prints a concise PASS/FAIL report
• Exit code 0 on healthy status
• Exit code 1 on blocking migration issues

Notes

• This guard is read-only (migrate status), it does not apply migrations.
• Keep it in CI before deploy or startup migration steps.