Help with Prisma database migrations.
Usage
- •
/migrate- Check migration status - •
/migrate create- Create new migration - •
/migrate apply- Apply pending migrations - •
/migrate reset- Reset database (dev only)
Commands
bash
# Check status npx prisma migrate status # Create migration (dev) npx prisma migrate dev --name $ARGUMENTS # Apply migrations (prod) npx prisma migrate deploy # Reset database npx prisma migrate reset # Regenerate client npx prisma generate
Migration Process
- •Modify
prisma/schema.prisma - •Run
npx prisma migrate dev --name description - •Review generated SQL
- •Test locally
- •Commit migration files
- •Apply with
npx prisma migrate deployin prod
Common Issues
| Issue | Solution |
|---|---|
| Client outdated | npx prisma generate |
| Migration conflict | npx prisma migrate resolve |
| Schema drift | npx prisma db push (dev) |