Fix Prisma database migration failures
Prisma migration errors occur when the migration SQL can't be applied to your database. This happens due to conflicting migrations, data that violates new constraints, or schema drift between your Prisma schema and the actual database.
Error messages you might see
Error: P3009 migrate found failed migrations in the target databaseError: P3006 Migration failed to apply cleanly to the shadow database.Why this happens in AI-generated code
Migration conflicts from AI-generated schema changes
AI tools modify the Prisma schema without considering existing migrations, creating conflicts when new migrations try to alter columns or tables that have already been changed.
Existing data violates new constraints
AI-generated schema changes add NOT NULL constraints or unique indexes to columns that already contain null or duplicate values in the database.
Shadow database connection issues
AI-generated database URLs point to managed databases that don't allow shadow database creation (required by prisma migrate dev), causing migration commands to fail.
How to fix it
Reset migrations in development
In development, run `npx prisma migrate reset` to drop and recreate the database with all migrations applied fresh. Never do this in production — use `prisma migrate deploy` instead.
Handle data migration for constraint changes
Before adding NOT NULL or unique constraints, create a migration that cleans up existing data first (fill nulls with defaults, remove duplicates), then apply the constraint.
Get professional help
Still stuck? Our engineers can resolve complex migration issues and schema drift. Visit /products to get started.
Related technologies
Can't fix it yourself?
Our code audit identifies this issue and dozens more. Get a prioritized fix list.
Security Scan
Black-box review of your public-facing app. No code access needed.
- OWASP Top 10 checks
- SSL/TLS analysis
- Security headers
- Expert review within 24h
Code Audit
In-depth review of your source code for security, quality, and best practices.
- Security vulnerabilities
- Code quality review
- Dependency audit
- AI pattern analysis
Complete Bundle
Both scans in one package with cross-referenced findings.
- Everything in both products
- Cross-referenced findings
- Unified action plan
100% credited toward any paid service. Start with an audit, then let us fix what we find.
Frequently asked questions
Can I edit a migration file after it's been created?
Only if it hasn't been applied to any database yet. Once applied, Prisma tracks the migration checksum. Editing an applied migration will cause a checksum mismatch error. Create a new migration instead.
How do I handle migrations in production?
Use `prisma migrate deploy` (not `prisma migrate dev`) in production. It applies pending migrations without generating new ones or using a shadow database. Always back up your database before migrating.
Related resources
Related Technologies
Still stuck? We can fix it for you.
Send us your repo. We'll diagnose the issue and give you a fixed quote within 24 hours.