Can I use this for large-scale data migrations?

Yes, it includes specialized patterns for batched data migrations to process records in chunks, avoiding long-held locks and performance degradation on large tables.

What ORMs are supported by this skill?

The skill provides specific implementation patterns and CLI workflows for Prisma and Drizzle ORM, as well as general SQL strategies compatible with any migration tool.

How does this skill help prevent production downtime?

It implements multi-step migration patterns—such as adding nullable columns before constraints—to ensure that old and new code versions can coexist during a deployment.

Does it include rollback strategies?

Yes, the skill covers both automated ORM rollback procedures and manual reversal strategies to safely recover from failed schema updates.

Database Migration Strategies

Name: Database Migration Strategies
Author: IvanTorresEdge

byIvanTorresEdge

Database Management

Implements safe, zero-downtime database schema changes and data migrations using industry-standard patterns and ORM best practices.

About

This skill provides a comprehensive framework for managing database evolutions within modern application stacks. It guides developers through the complexities of schema modifications, data backfills, and non-blocking index creation while adhering to a 'forward-only, reversible' philosophy. By offering specific implementation patterns for Prisma, Drizzle, and raw SQL, it helps engineering teams prevent production outages, avoid long-running table locks, and maintain backward compatibility during phased deployments.

Key Features

0 GitHub stars
Standardized workflows for Prisma and Drizzle ORMs
Batched data migration patterns for large-scale backfills
Non-blocking index creation strategies for PostgreSQL
Zero-downtime column renaming and removal patterns
Logical rollback strategies and CI/CD integration guides

Use Cases

Standardizing database deployment pipelines within automated CI/CD workflows
Backfilling data for millions of records using batched transactions
Refactoring production database schemas without service interruption

About

Key Features

0 GitHub stars
Standardized workflows for Prisma and Drizzle ORMs
Batched data migration patterns for large-scale backfills
Non-blocking index creation strategies for PostgreSQL
Zero-downtime column renaming and removal patterns
Logical rollback strategies and CI/CD integration guides

Use Cases

Standardizing database deployment pipelines within automated CI/CD workflows
Backfilling data for millions of records using batched transactions
Refactoring production database schemas without service interruption