--- title: "Improving Prisma Migrate DX for resolving failed migrations with 2 new commands" url: https://daily.dev/posts/improving-prisma-migrate-dx-for-resolving-failed-migrations-with-2-new-commands-f2auyzp2o source_url: https://www.prisma.io/blog/prisma-migrate-dx-primitives type: article source: "Prisma Blog" published: 2026-05-31T07:45:00.885Z updated: 2026-05-31T08:54:42.895Z tags: ["sql", "postgresql", "prisma"] reading_time: 7 upvotes: 0 comments: 0 language: en --- > ## Documentation Index > Fetch the complete documentation index at: https://daily.dev/llms.txt > Use this file to discover all available pages before exploring further. # Improving Prisma Migrate DX for resolving failed migrations with 2 new commands **[Prisma Blog](https://daily.dev/sources/prisma-blog)** · 7 min read · 0 upvotes · 0 comments ## Summary Prisma 3.9.0 introduces two new low-level Preview commands — `migrate diff` and `db execute` — to improve the developer experience when troubleshooting failed schema migrations. `migrate diff` compares any two schema sources (live database, Prisma data model, migration history, or empty) and outputs a human-readable summary or executable SQL. `db execute` runs SQL against a database, and the two commands can be piped together to detect and resolve schema drift. The post also explains why Prisma intentionally avoids down migrations (rollbacks give a false sense of security) and transactional DDL (not universally supported, costly at scale), recommending instead small, non-breaking, additive migrations using the expand-and-contract pattern. ## Full article daily.dev links to this article rather than hosting it. Read it at the original source: --- Tags: [#sql](https://daily.dev/tags/sql), [#postgresql](https://daily.dev/tags/postgresql), [#prisma](https://daily.dev/tags/prisma) [View this post on daily.dev](https://daily.dev/posts/improving-prisma-migrate-dx-for-resolving-failed-migrations-with-2-new-commands-f2auyzp2o)