database-migrations

What problem does it solve?

This Skill provides comprehensive guidance and patterns for managing database schema changes safely and efficiently, preventing data loss and minimizing downtime in production environments.

Core Features & Use Cases

• Best Practices: Learn core principles for safe, reversible migrations.
• Tooling Support: Detailed examples for PostgreSQL, MySQL, and ORMs like Prisma, Drizzle, Django, TypeORM, and golang-migrate.
• Zero-Downtime Strategies: Implement expand-contract patterns for critical deployments.
• Use Case: Safely add a new column to a high-traffic users table without locking the database or causing application errors.

Quick Start

Use the database-migrations skill to learn how to add a new column to a PostgreSQL table without downtime.