Prisma

Migrate Commands

Manage database schema changes with Prisma Migrate. Create, apply, and resolve migrations for safe, version-controlled database evolution across environments.

11 commands

Pro Tips

Use 'prisma migrate dev --name add_users_table' to create and apply a migration in development with a descriptive name.

Use 'prisma migrate deploy' in production/CI — it only applies pending migrations without creating new ones.

Preview SQL without applying: 'prisma migrate diff --from-schema-datamodel prisma/schema.prisma --to-migrations ./prisma/migrations'.

Common Mistakes

Never run 'prisma migrate dev' on production. Use 'prisma migrate deploy' which only applies existing migrations.

Editing applied migration files causes drift. Use 'prisma migrate resolve' to handle failed or modified migrations.

Commands

Deploy migrations

$ npx prisma migrate deploy

Apply pending migrations to production/staging

Create and apply migration

$ npx prisma migrate dev

Create migration from schema changes and apply to dev database

Create migration without applying

$ npx prisma migrate dev --name <name> --create-only

Generate migration SQL file without applying it to the database

Migration with name

$ npx prisma migrate dev --name <name>

Create named migration from schema changes

Show schema diff

$ npx prisma migrate diff --from-schema-datamodel prisma/schema.prisma --to-schema-datasource prisma/schema.prisma

Show differences between schema and database

Diff between two schemas

$ npx prisma migrate diff --from-schema-datamodel prisma/old.prisma --to-schema-datamodel prisma/schema.prisma --script

Generate SQL script of differences between two schema files

Reset database

$ npx prisma migrate reset

Reset database and apply all migrations

Reset without seeding

$ npx prisma migrate reset --skip-seed

Reset database and apply migrations without running the seed script

Resolve migration

$ npx prisma migrate resolve --applied <migration>

Mark a migration as applied (fix failed migration)

Mark migration as rolled back

$ npx prisma migrate resolve --rolled-back <migration>

Mark a failed migration as rolled back to unblock the migration table

Migration status

$ npx prisma migrate status

Check the status of migrations