How does it handle zero-downtime deployments?

It enforces multi-step strategies for breaking changes, such as adding new columns before removing old ones, and utilizes concurrent index creation to prevent table locking.

Does this skill support specific database frameworks?

Yes, it provides standardized patterns and code examples for major frameworks including SQLAlchemy (Alembic), Ruby on Rails (ActiveRecord), and Sequelize (JavaScript).

What is the recommended standard for naming migration files?

The skill recommends using timestamp-based prefixes followed by descriptive actions (e.g., 20241118_add_email_to_users) to ensure execution order and clarity.

Why should I separate schema and data migrations?

Separation ensures that fast structural changes aren't blocked by slow operational data scripts, which makes rollbacks significantly safer and easier to debug.

Does it help with database performance during updates?

Yes, by advocating for concurrent indexing and batch-processing for large data updates to prevent resource exhaustion and long-running locks.

Backend Migration Standards

Name: Backend Migration Standards
Author: Activer007

byActiver007

0•

데이터베이스 관리

Establishes best practices for creating reversible, zero-downtime database migrations with consistent naming and structure.

The Backend Migration Standards skill provides Claude Code with a rigorous framework for managing database schema evolution safely and efficiently. It emphasizes mandatory reversibility, the strict separation of schema and data changes, and proven strategies for achieving zero-downtime deployments. By applying this skill, developers ensure that all database modifications—from adding columns and creating indexes to complex data transformations—adhere to industry-standard patterns that minimize production risks and prevent table locking across frameworks like SQLAlchemy, Rails, and Sequelize.

주요 기능

010 GitHub stars

02Concurrent index creation patterns for high-volume production tables

03Zero-downtime deployment strategies for non-blocking database updates

04Strict reversibility requirements for every schema change with mandatory rollback methods

05Clear separation between structural schema changes and operational data migrations

06Standardized naming conventions and idempotency checks for repeatable deployments

사용 사례

01Safely adding a NOT NULL column to a large production table without causing downtime

02Executing batch-processed data transformations to avoid memory exhaustion and long transactions

03Implementing multi-step column renames to maintain application uptime during transition

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add activer007/ordinary-claude-skills backend-migration-standards

For use in Claude.ai and ChatGPT

Download Skill