Does this skill support specific ORMs?

Yes, it includes workflows and code examples for popular tools like Prisma, Drizzle, Django, TypeORM, and golang-migrate.

Can I use this for data backfilling?

Absolutely. It provides strategies for batched data migrations that prevent table locks and ensure system performance during large updates to existing rows.

What database engines are covered?

The skill focuses primarily on PostgreSQL and MySQL, offering specific optimizations like concurrent index creation and non-blocking column additions.

How does this skill help with zero-downtime deployments?

It provides patterns like the expand-contract strategy, allowing you to add columns, backfill data, and remove old fields in phases that keep the application running throughout the process.

Why should I avoid adding NOT NULL constraints directly?

Adding NOT NULL without a default on an existing large table can trigger a full table rewrite and long-term locks; this skill teaches safer alternatives like adding nullable columns first.

Safe Database Migrations

Name: Safe Database Migrations
Author: hieuck

byhieuck

0•

数据库管理

Implements safe, reversible database schema changes and zero-downtime deployment patterns across major SQL databases and ORMs.

This skill equips Claude with specialized knowledge for planning and executing database migrations without risking production stability. It provides specific implementation patterns for PostgreSQL and MySQL while supporting popular tools like Prisma, Drizzle, and Django. By following the expand-contract strategy and safety checklists, it helps developers manage schema alterations, data backfills, and index creation concurrently to ensure zero downtime and high availability for mission-critical applications.

主要功能

010 GitHub stars

02Zero-downtime deployment strategies using the expand-contract pattern

03Best practices for batching large data migrations to avoid table locks

04Domain-specific patterns for PostgreSQL, MySQL, and common ORMs

05Guides for implementing reversible migrations with UP and DOWN paths

06Safety checklists for schema changes, data migrations, and index creation

使用场景

01Designing backfill scripts for large-scale data transformations

02Planning complex schema refactors for high-traffic production databases

03Generating migration scripts for Prisma, Drizzle, or Django models

主要功能

010 GitHub stars

02Zero-downtime deployment strategies using the expand-contract pattern

03Best practices for batching large data migrations to avoid table locks

04Domain-specific patterns for PostgreSQL, MySQL, and common ORMs

05Guides for implementing reversible migrations with UP and DOWN paths

06Safety checklists for schema changes, data migrations, and index creation

使用场景

01Designing backfill scripts for large-scale data transformations

02Planning complex schema refactors for high-traffic production databases

03Generating migration scripts for Prisma, Drizzle, or Django models