SkillHub

prisma-migrate-guard

v1.0.0

Preflight Prisma migration state before deploy; fails fast on drift, failed migrations, missing DB URLs, or unapplied migration files.

Sourced from ClawHub, Authored by Daniel Lummis

Installation

Please help me install the skill `prisma-migrate-guard` from SkillHub official store. npx skills add daniellummis/prisma-migrate-guard

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.