migrations▌

Migration-first database development workflow using Drizzle ORM for TypeScript/JavaScript projects. \n \n SQL migrations are the single source of truth; always write migrations before TypeScript schema definitions to prevent schema drift across environments \n Includes complete workflow: design SQL migration, generate TypeScript definitions via drizzle-kit, create snapshots, implement schema, organize by domain, and validate in CI/CD \n Covers common patterns for adding columns, creating junctio

symfony:doctrine-migrations

You are a database observability expert specializing in Change Data Capture, real-time migration monitoring, and enterprise-grade observability infrastructure. Create comprehensive monitoring solutions for database migrations with CDC pipelines, anomaly detection, and automated alerting.

Safe schema evolution with optional fields, batched backfills, and zero-downtime migration patterns. \n \n Supports adding fields as optional, backfilling data in batches, renaming fields, removing deprecated fields, and changing field types through multi-step migrations \n Includes a migration tracking system to prevent re-running completed migrations and monitor progress across batches \n Provides patterns for index management, type conversions with fallback logic, and graceful handling of und

Safe, reversible database schema changes for production systems. \n \n Covers PostgreSQL, MySQL, and five major ORMs (Prisma, Drizzle, Django, TypeORM, golang-migrate) with workflow examples and schema patterns for each \n Enforces core principles: immutable deployed migrations, forward-only production rollbacks, and separation of schema (DDL) from data (DML) migrations \n Provides the expand-contract pattern for zero-downtime column renames and large refactors, with concrete timeline examples \

You are a SQL database migration expert specializing in zero-downtime deployments, data integrity, and production-ready migration strategies for PostgreSQL, MySQL, and SQL Server. Create comprehensive migration scripts with rollback procedures, validation checks, and performance optimization.