# status (Prisma CLI v7) (/docs/cli/v7/migrate/status)

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

Check the status of your database migrations

Location: CLI > v7 > migrate > status

The `prisma migrate status` command checks the migrations in `./prisma/migrations/*` and the entries in the `_prisma_migrations` table to report the state of your migrations.

> [!WARNING]
> This command is not supported on [MongoDB](https://www.prisma.io/docs/orm/v7/core-concepts/supported-databases/mongodb). Use [`db push`](https://www.prisma.io/docs/cli/v7/db/push) instead.

## Usage [#usage]

```bash
prisma migrate status [options]
```

The datasource URL configuration is read from the Prisma config file (e.g., `prisma.config.ts`).

## Options [#options]

| Option         | Description                            |
| -------------- | -------------------------------------- |
| `-h`, `--help` | Display help message                   |
| `--config`     | Custom path to your Prisma config file |
| `--schema`     | Custom path to your Prisma schema      |

## Exit codes [#exit-codes]

In versions 4.3.0 and later, `prisma migrate status` exits with code 1 when:

* A database connection error occurs
* Migration files haven't been applied to the database
* Migration history has diverged from the database state
* No migration table is found
* Failed migrations are found

## Example output [#example-output]

```text
Status
3 migrations found in prisma/migrations

Your local migration history and the migrations table from your database are different:

The last common migration is: 20201127134938_new_migration

The migration have not yet been applied:
20201208100950_test_migration

The migrations from the database are not found locally in prisma/migrations:
20201208100950_new_migration
```

## Examples [#examples]

### Check migration status [#check-migration-status]

  

#### bun

```bash
bunx prisma migrate status
```

#### pnpm

```bash
pnpm prisma migrate status
```

#### yarn

```bash
yarn prisma migrate status
```

#### npm

```bash
npx prisma migrate status
```

### Specify a schema path [#specify-a-schema-path]

  

#### bun

```bash
bunx prisma migrate status --schema=./alternative/schema.prisma
```

#### pnpm

```bash
pnpm prisma migrate status --schema=./alternative/schema.prisma
```

#### yarn

```bash
yarn prisma migrate status --schema=./alternative/schema.prisma
```

#### npm

```bash
npx prisma migrate status --schema=./alternative/schema.prisma
```

## Related pages

- [`deploy`](https://www.prisma.io/docs/cli/v7/migrate/deploy): Apply pending migrations to update the database schema in production/staging
- [`dev`](https://www.prisma.io/docs/cli/v7/migrate/dev): Create a migration from changes in Prisma schema, apply it to the database, and trigger generators
- [`diff`](https://www.prisma.io/docs/cli/v7/migrate/diff): Compare the database schema from two arbitrary sources
- [`reset`](https://www.prisma.io/docs/cli/v7/migrate/reset): Reset your database and apply all migrations. All data will be lost
- [`resolve`](https://www.prisma.io/docs/cli/v7/migrate/resolve): Resolve issues with database migrations in deployment databases