Create Database Migrations

Create and manage database migrations: $ARGUMENTS

Current Database State

• ORM detection: @package.json or @requirements.txt (detect Sequelize, Prisma, Alembic, etc.)
• Migration files: !find . -name "migration" -type f | head -5
• Database config: @config/database.* or @prisma/schema.prisma
• Current schema: !ls migrations/ 2>/dev/null | wc -l migrations found

Task

Create comprehensive database migrations with proper versioning and rollback capabilities:

Migration Types: Use $ARGUMENTS to specify table creation, column addition, table alteration, or data migration Migration Framework:

• Migration Planning - Analyze schema changes, dependencies, and data impact
• Migration Generation - Create timestamped migration files with up/down methods
• Schema Updates - Table creation, column modifications, index management
• Data Migrations - Safe data transformations and backfills
• Rollback Strategy - Implement reliable rollback procedures for each change
• Testing - Validate migrations in development and staging environments

Best Practices: Follow database-specific conventions, maintain referential integrity, handle large datasets efficiently, and ensure zero-downtime deployments. Output: Production-ready migration files with comprehensive rollback support, proper indexing, and data safety measures.