mgoodman60 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
# 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) |