Labsco
prisma logo

prisma-cli-migrate-diff

✓ Official★ 8

by prisma · part of prisma/cursor-plugin

prisma migrate diff. Reference when using this Prisma feature.

🔥🔥🔥✓ VerifiedFreeQuick setup
#database#git
🧩 One of 7 skills in the prisma/cursor-plugin package — works on its own, and pairs well with its siblings.

prisma migrate diff. Reference when using this Prisma feature.

Inspect the full instructions your agent will receiveExpand

This is the exact playbook injected into your agent when the skill activates — shown here so you can audit it before installing. You don't need to read it to use the skill.

by prisma

prisma migrate diff. Reference when using this Prisma feature. npx skills add https://github.com/prisma/cursor-plugin --skill prisma-cli-migrate-diff Download ZIPGitHub8

prisma migrate diff

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

Command

Copy & paste — that's it
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

Option Description --script Render SQL script to stdout --exit-code Exit 2 if changes detected, 0 if empty, 1 if error --config Custom 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:

Copy & paste — that's it
prisma migrate diff \
 --from-url "$PROD_DB_URL" \
 --to-schema ./prisma/schema.prisma \
 --script

Review pending migrations

Compare database state to migrations directory:

Copy & paste — that's it
prisma migrate diff \
 --from-config-datasource \
 --to-migrations ./prisma/migrations

Create baseline migration

Compare empty state to current schema:

Copy & paste — that's it
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:

Copy & paste — that's it
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.