Down migrations & point-in-history migrations

Problem

With the current version of Prisma migrate it is possible to apply migrations in only one direction (forwards). However, it is not possible to restore the database schema to a previous migration. It would be great if Prisma had a way to:

• Rollback one migration
• Rollback to the state before any migration

The lack of down and point-in-history migrations is already mentioned in the docs but no official feature request has been submitted yet.

Suggested solution

I suggest adding two new cli commands:

1. Rollback one migration
   prisma migrate --down

2. Rollback to point-in-history
   prisma migrate [existing migration hash]

Additional context

This feature request resulted from a Twitter conversation with @nikolasburk.

Start with the Prisma Migrate CLI entry points and the documented migration limitations linked in the issue. Define how the proposed down and point-in-history commands should select and restore migration states, then verify that both rollback cases are supported across the migration workflow.