drizzle-safe-migrations

What problem does it solve?

This Skill ensures that database schema changes in Drizzle ORM are applied safely in production, especially when those changes require data backfills or involve tightening constraints, preventing data corruption and downtime.

Core Features & Use Cases

• Production-Safe Migrations: Guides a workflow for applying Drizzle migrations that minimizes risk during deployment.
• Data Backfills: Manages the process of updating existing data to comply with new schema rules before constraints are enforced.
• Constraint Tightening: Safely modifies enums, check constraints, and defaults without data loss.
• Use Case: You need to change a status enum in your Drizzle schema from ['pending', 'processing', 'completed'] to ['pending', 'processing', 'completed', 'archived']. This skill helps you backfill existing records that might be in a state that would violate a future constraint, and then safely apply the schema change.

Quick Start

Use the drizzle-safe-migrations skill to plan and execute a safe Drizzle migration with backfills and constraint changes.