Skill UI

This skill generates a comprehensive, safe, and zero-downtime database migration plan for schema changes. It utilizes the industry-standard expand/contract pattern to ensure backward compatibility, detailing multiple phased steps (Expand, Backfill, Contract), necessary SQL scripts, robust rollback procedures, and detailed deployment runbooks. Essential for maintaining application availability during large-scale database updates.

A comprehensive guide to safe and reversible database migration patterns. Covers zero-downtime schema changes, data backfilling, and rollbacks for major databases like PostgreSQL and MySQL, and popular ORMs (Prisma, Drizzle, Django). Learn techniques like concurrent indexing and the expand-contract pattern to ensure production stability.

A comprehensive guide covering modern application deployment strategies, including Blue-Green, Canary, and Rolling deployments, ensuring zero downtime. It also provides deep dives into Docker multi-stage builds, container best practices, and setting up robust CI/CD pipelines using tools like GitHub Actions.