Database Migrations

Safe schema evolution with Prisma Migrate including development and production workflows, data migrations, zero-downtime strategies, and CI/CD integration.

What's Included#

• Development migration commands (migrate dev, reset, generate)
• Production migration commands (migrate deploy, migrate status)
• Data migration scripts for backfilling and transforming existing records
• Batch data migration with progress tracking
• Reversible migration pattern with up/down functions
• Zero-downtime migration strategy (add column, dual-write, backfill, switch reads, drop old)
• Safe column rename workflow
• Migration verification scripts for data integrity checks
• CI/CD pipeline integration with GitHub Actions

Usage#

Via CLI#

Via AI Assistant#

Ask your AI assistant:

• "Use the database migrations pattern from Bootspring"
• "Apply the Bootspring migrations pattern to my project"

Key Considerations#

• Never use db push in production; always use migrate deploy for production databases
• Test migrations against a copy of production data before deploying
• Plan rollback strategies and make migrations reversible when possible
• Batch large data migrations to avoid locking tables for extended periods
• Verify data integrity after every migration completes

Related Patterns#

• Prisma - Prisma setup and basics
• Seeding - Database seeding
• Transactions - Transaction handling