database-migration

What problem does it solve?

This Skill streamlines the complex process of database schema and data migrations, ensuring minimal disruption and providing robust rollback capabilities.

Core Features & Use Cases

• Multi-ORM Support: Handles migrations for Sequelize, TypeORM, and Prisma.
• Zero-Downtime Strategies: Implements techniques like blue-green deployments and phased column updates.
• Data Transformation: Safely transforms data during migration, including complex restructuring.
• Rollback Procedures: Ensures you can revert changes safely using transactions or backups.
• Use Case: Migrating your application's user data from a legacy SQL schema to a new structure with added fields, all without taking your service offline.

Quick Start

Use the database-migration skill to add a new 'status' column with a default value of 'active' to the 'users' table.