Prisma Migrate Guard

---

name: prisma-migrate-guard

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

version: 1.0.0

metadata: {"openclaw":{"requires":{"bins":["bash","node","npx"]}}}

---

# 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

- failed migrations

- migration drift warnings

- unapplied migration files

- missing migration history table hints

Inputs

- `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

Notes