migration show
migration show displays the operations, statement preview, and metadata for one migration package.
Use this command during review before applying a migration package. The command is offline. It does not consult the database.
bunx prisma migration show <target>pnpm prisma migration show <target>yarn prisma migration show <target>npx prisma migration show <target>| Argument or option | What it does |
|---|---|
<target> |
The migration to inspect: a directory name, a hash or hash prefix, a ref, or a path. |
--config <path> |
Read this config file instead of ./prisma.config.ts. |
--json |
Prints a machine-readable result. |
bunx prisma migration show 20260101_100000_add_user
bunx prisma migration show a1b2c3
bunx prisma migration show migrations/app/20260101_100000_add_user
bunx prisma migration show 20260101_100000_add_user --jsonpnpm prisma migration show 20260101_100000_add_user
pnpm prisma migration show a1b2c3
pnpm prisma migration show migrations/app/20260101_100000_add_user
pnpm prisma migration show 20260101_100000_add_user --jsonyarn prisma migration show 20260101_100000_add_user
yarn prisma migration show a1b2c3
yarn prisma migration show migrations/app/20260101_100000_add_user
yarn prisma migration show 20260101_100000_add_user --jsonnpx prisma migration show 20260101_100000_add_user
npx prisma migration show a1b2c3
npx prisma migration show migrations/app/20260101_100000_add_user
npx prisma migration show 20260101_100000_add_user --jsonBefore applying, review:
- the source and destination contract hashes
- the planned operations
- generated SQL statements or operation payloads
- the migration's metadata