# migration show (/docs/cli/migration-show)

> For the complete Prisma documentation index, see [llms.txt](https://www.prisma.io/docs/llms.txt). A markdown version of any docs page is available by appending `.md` to its URL.

Inspect a Prisma ORM migration package.

Location: CLI > 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.

## Usage [#usage]

  

#### bun

```bash
bunx prisma migration show <target>
```

#### pnpm

```bash
pnpm prisma migration show <target>
```

#### yarn

```bash
yarn prisma migration show <target>
```

#### npm

```bash
npx prisma migration show <target>
```

## Options [#options]

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

## Examples [#examples]

  

#### bun

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

#### pnpm

```bash
pnpm 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 --json
```

#### yarn

```bash
yarn 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 --json
```

#### npm

```bash
npx 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 --json
```

## Data lines [#data-lines]

Without `--json`, standard output gets one `key<TAB>value` line for each of `name`, `space`, `from`, `to`, `hash` and `created`, in that order. A key whose value is absent has no line. Then it gets one line per operation, with four fields separated by tabs: the word `operation`, the operation's id, its class, and its label. The class says what kind of change the operation makes: `additive`, `widening`, `destructive` or `data`. The label is the one-line description the CLI prints for the operation. [Global flags](https://www.prisma.io/docs/cli/global-flags#data-lines-of-prisma-orm-commands) lists the rules data lines follow.

```bash
npx prisma migration show 20260101_100000_add_user | awk -F'\t' '$1 == "to" { print $2 }'
```

## What to check [#what-to-check]

Before applying, review:

* the source and destination contract hashes
* the planned operations
* generated SQL statements or operation payloads
* the migration's metadata

## Related pages

- [`auth`](https://www.prisma.io/docs/cli/auth): Sign in to your Prisma account from the CLI, sign out, and manage workspace sessions.
- [`branch`](https://www.prisma.io/docs/cli/branch): List platform branches for a project.
- [`bucket`](https://www.prisma.io/docs/cli/bucket): Create and manage object-store buckets.
- [`Configuration`](https://www.prisma.io/docs/cli/configuration): Configure Prisma ORM CLI commands with prisma.config.ts and global flags.
- [`contract emit`](https://www.prisma.io/docs/cli/contract-emit): Emit Prisma ORM contract artifacts.