AgentSkillsCN

prisma-cli-migrate-resolve

Prisma迁移解决

SKILL.md
--- frontmatter
name: prisma-cli-migrate-resolve
description: prisma migrate resolve
license: MIT
metadata:
  author: prisma
  version: "7.0.0"

prisma migrate resolve

Resolves issues with database migrations, such as failed migrations or baselining.

Command

bash
prisma migrate resolve [options]

What It Does

Updates the _prisma_migrations table to manually change the state of a migration. This is a recovery tool.

Options

You must provide exactly one of --applied or --rolled-back.

OptionDescription
--applied <name>Mark a migration as applied (success)
--rolled-back <name>Mark a migration as rolled back (ignored/failed)
--schemaPath to schema file
--configCustom path to your Prisma config file

Examples

Mark as Applied (Baselining)

If you have existing tables and want to initialize migrations without running the SQL:

bash
prisma migrate resolve --applied 20240101000000_initial_migration

This tells Prisma "Assume this migration has already run".

Mark as Rolled Back (Fixing Failures)

If a migration failed (e.g., syntax error) and you fixed the SQL or want to retry:

bash
prisma migrate resolve --rolled-back 20240115120000_failed_migration

This tells Prisma "Forget this migration run, let me try applying it again".

Use Cases

  1. •Baselining: Adopting Prisma Migrate on an existing production database.
  2. •Failed Migrations: Recovering from a failed migrate deploy in production.
  3. •Hotfixes: reconciling manual database changes (rare).

References