Implements safe, reversible, and zero-downtime database schema changes across multiple ORMs and SQL dialects.
This skill provides a comprehensive framework for managing production database migrations with a focus on safety and system uptime. It offers expert guidance on executing schema changes without locking tables, handling large-scale data backfills, and implementing the expand-contract pattern for zero-downtime deployments. Supporting popular tools like Prisma, Drizzle, Django, and golang-migrate, it ensures that every database change is versioned, tested, and reversible, preventing common pitfalls that lead to production outages or data loss.
Características Principales
01Safe SQL practices for PostgreSQL and MySQL, including concurrent indexing
02Zero-downtime deployment patterns using the Expand-Contract strategy
03Pre-deployment safety checklists to prevent table locks and failures
04Optimized data migration patterns for batching large-scale updates
050 GitHub stars
06Multi-ORM support for Prisma, Drizzle, Django, and golang-migrate
Casos de Uso
01Standardizing version-controlled migration workflows across different development teams
02Planning and executing major database schema refactors without service interruption
03Adding indexes or constraints to multi-million row production tables safely
