AgentSkillsCN

prisma-cli-migrate-diff

Prisma迁移差异。在使用此Prisma功能时请参考。

SKILL.md
--- frontmatter
name: prisma-cli-migrate-diff
description: prisma migrate diff. Reference when using this Prisma feature.
license: MIT
metadata:
  author: prisma
  version: "7.0.0"

prisma migrate diff

Compares database schemas and generates diffs (SQL or summary).

Command

bash
prisma migrate diff [options]

What It Does

  • •Compares two sources (--from-... and --to-...)
  • •Sources can be:
    • •Empty (empty)
    • •Schema file (schema)
    • •Migrations directory (migrations)
    • •Database URL (url) or Configured Datasource (config-datasource)
  • •Outputs the difference:
    • •Human-readable summary (default)
    • •SQL script (--script)

Options

OptionDescription
--scriptRender SQL script to stdout
--exit-codeExit 2 if changes detected, 0 if empty, 1 if error
--configCustom path to your Prisma config file

Sources (Must provide one from and one to)

  • •--from-empty, --to-empty
  • •--from-schema <path>, --to-schema <path>
  • •--from-migrations <path>, --to-migrations <path>
  • •--from-url <url>, --to-url <url>
  • •--from-config-datasource, --to-config-datasource (uses prisma.config.ts)

Examples

Generate SQL for a schema change

Compare current production DB to your local schema:

bash
prisma migrate diff \
  --from-url "$PROD_DB_URL" \
  --to-schema ./prisma/schema.prisma \
  --script

Review pending migrations

Compare database state to migrations directory:

bash
prisma migrate diff \
  --from-config-datasource \
  --to-migrations ./prisma/migrations

Create baseline migration

Compare empty state to current schema:

bash
prisma migrate diff \
  --from-empty \
  --to-schema ./prisma/schema.prisma \
  --script > prisma/migrations/0_init/migration.sql

Check for drift (CI)

Check if database matches schema:

bash
prisma migrate diff \
  --from-config-datasource \
  --to-schema ./prisma/schema.prisma \
  --exit-code

Use Cases

  • •Forward-generating migrations: Creating SQL without migrate dev.
  • •Drift detection: Checking if DB is in sync.
  • •Baselining: Creating initial migration from existing DB.
  • •Debugging: Understanding what migrate dev would do.