How does it handle dangerous database operations?

It identifies high-risk actions like direct column renaming or type changes and provides safer alternatives, such as using concurrent index creation or non-validating constraints to prevent blocking production traffic.

Can this skill help with large-scale data backfilling?

Absolutely. It includes optimized strategies for batched backfills and shadow tables to handle large-scale data updates without exhausting system memory or causing long-duration table locks.

Does it support specific ORMs like Prisma or Knex?

Yes, the skill includes a comparison of popular migration tools and provides general SQL and JavaScript patterns that are applicable to most modern ORMs and migration frameworks.

How does this skill help with zero-downtime migrations?

It provides the 'expand-and-contract' pattern, guiding you through a multi-step process of adding new columns, dual-writing, backfilling data, and eventually dropping old elements to ensure the application remains functional throughout the change.

Database Migration Best Practices

Name: Database Migration Best Practices
Author: Claude-Code-Community-Ireland

byClaude-Code-Community-Ireland

•

Database Management

Implements industry-standard database migration strategies including zero-downtime patterns, rollback procedures, and schema safety protocols.

The database-migration skill provides Claude with expert-level guidance for managing schema changes throughout the software development lifecycle. It enforces strict naming conventions, mandates reversible migration pairs, and provides detailed execution plans for complex operations like the expand-and-contract pattern. By utilizing this skill, developers can avoid common pitfalls such as exclusive table locks, data loss, and application downtime while ensuring that every database evolution is versioned, idempotent, and thoroughly tested against production-like data volumes.

Key Features

01Comprehensive migration testing and rollback checklists

02Safety guidelines for dangerous operations and lock mitigation

03Automated batch backfill and dual-write data patterns

04Standardized timestamped naming and ordering conventions

053 GitHub stars

06Zero-downtime 'expand-and-contract' implementation patterns

Use Cases

01Designing idempotent schema migrations with reliable rollback scripts

02Renaming or modifying production columns without interrupting service

03Developing batch-processing scripts for safe large-scale data backfills

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add claude-code-community-ireland/claude-code-resources database-migration

For use in Claude.ai and ChatGPT

Download Skill

Key Features

01Comprehensive migration testing and rollback checklists

02Safety guidelines for dangerous operations and lock mitigation

03Automated batch backfill and dual-write data patterns

04Standardized timestamped naming and ordering conventions

053 GitHub stars

06Zero-downtime 'expand-and-contract' implementation patterns

Use Cases

01Designing idempotent schema migrations with reliable rollback scripts

02Renaming or modifying production columns without interrupting service

03Developing batch-processing scripts for safe large-scale data backfills

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add claude-code-community-ireland/claude-code-resources database-migration

For use in Claude.ai and ChatGPT

Download Skill