Overview of Prisma Migrate (Prisma ORM v7) (/docs/orm/v7/prisma-migrate)

For the complete Prisma documentation index, see llms.txt. A markdown version of any docs page is available by appending .md to its URL.

Learn how Prisma Migrate keeps your database schema in sync with your Prisma schema

Location: ORM > v7 > Overview of Prisma Migrate

Prisma Migrate enables you to:

• Keep your database schema in sync with your Prisma schema as it evolves
• Maintain existing data in your database

Prisma Migrate generates a history of .sql migration files, and plays a role in both development and production.

Prisma Migrate can be considered a hybrid database schema migration tool, meaning it has both of declarative and imperative elements:

• Declarative: The data model is described in a declarative way in the Prisma schema. Prisma Migrate generates SQL migration files from that data model.
• Imperative: All generated SQL migration files are fully customizable. Prisma Migrate hence provides the flexibility of an imperative migration tool by enabling you to modify what and how migrations are executed (and allows you to run custom SQL to e.g. make use of native database feature, perform data migrations, ...).

If you are prototyping, consider using the db push command - see Schema prototyping with db push for examples.

See the Prisma Migrate reference for detailed information about the Prisma Migrate CLI commands.

[!NOTE] Does not apply for MongoDB

Instead of migrate dev and related commands, use db push for MongoDB.

• Prisma Client: Prisma Client is Prisma ORM's generated, type-safe query builder for Node.js, Bun, and Deno applications.