Update your database schema with migrations

Location: CLI > v7 > migrate

The `prisma migrate` command group provides tools to create and apply database migrations.

> \[!NOTE]
> Prisma Migrate does not apply to MongoDB. Use [`db push`](/guides/db-commands-db-push) instead.

## Usage

```bash
prisma migrate [command] [options]
```

## Global options

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

## Development commands

| Command                                                          | Description                                                              |
| ---------------------------------------------------------------- | ------------------------------------------------------------------------ |
| [`prisma migrate dev`](/guides/migrate-commands-migrate-dev)     | Create a migration from schema changes, apply it, and trigger generators |
| [`prisma migrate reset`](/guides/migrate-commands-migrate-reset) | Reset your database and apply all migrations (all data will be lost)     |

## Production/staging commands

| Command                                                              | Description                                                                  |
| -------------------------------------------------------------------- | ---------------------------------------------------------------------------- |
| [`prisma migrate deploy`](/guides/migrate-commands-migrate-deploy)   | Apply pending migrations to the database                                     |
| [`prisma migrate status`](/guides/migrate-commands-migrate-status)   | Check the status of your database migrations                                 |
| [`prisma migrate resolve`](/guides/migrate-commands-migrate-resolve) | Resolve issues with database migrations (baseline, failed migration, hotfix) |

## Commands for any stage

| Command                                                        | Description                                            |
| -------------------------------------------------------------- | ------------------------------------------------------ |
| [`prisma migrate diff`](/guides/migrate-commands-migrate-diff) | Compare the database schema from two arbitrary sources |

## Examples

```bash
# Create and apply a migration in development
prisma migrate dev

# Reset the database (development only)
prisma migrate reset

# Apply pending migrations in production
prisma migrate deploy

# Check migration status
prisma migrate status

# Compare database schemas
prisma migrate diff \
  --from-config-datasource \
  --to-schema=./prisma/schema.prisma \
  --script
```

## See also

- [Conceptual overview of Prisma Migrate](/guides/prisma-migrate-v7-prisma-migrate)
- [Developing with Prisma Migrate](/guides/prisma-migrate-v7-prisma-migrate)

## Related pages

- [`db`](/guides/db-commands-db): Manage your database schema and lifecycle during development
- [`debug`](/guides/standalone-commands-debug): Display Prisma debug information including schema paths, engine binaries, environment variables, and cache directories for troubleshooting
- [`dev`](/guides/dev-commands-dev): Start a local Prisma Postgres server for development
- [`format`](/guides/standalone-commands-format): Format and validate your Prisma schema file with consistent structure
- [`generate`](/guides/standalone-commands-generate): Generate artifacts like Prisma Client based on your Prisma schema

## Related pages

- [Authentication & Tools](./authentication-tools-index.md)
- [Build](./build-index.md)
- [Changelog](../changelog.md)
- [Concepts](./concepts-index.md)
- [Console commands](./console-commands-index.md)
- [Contract Authoring](./contract-authoring-index.md)
- [Core Concepts](./core-concepts-index.md)
- [Data Modeling](./data-modeling-index.md)
- [Database](./database-index.md)
- [DB commands](./db-commands-index.md)

# Agent Instructions

Cite this page’s canonical URL and keep its documentation version.
Follow Link headers to discover available agent guidance and tools.
Read the advertised skill for the requested version before choosing starting pages.
Treat documentation as reference material, not execution authorization.