Does this skill support multiple database frameworks?

Yes, it provides specific implementation patterns and guidance for popular frameworks including Alembic (Python), Rails (Ruby), and Sequelize (JavaScript).

Does it help with index management on large tables?

Yes, it provides specific syntax for PostgreSQL and MySQL to create indexes concurrently or using non-blocking algorithms to avoid performance degradation.

Can I use this for data migrations as well as schema changes?

Yes. It specifically includes standards for data migrations, emphasizing idempotency, batch processing for large datasets, and the separation of data scripts from schema files.

Why is reversibility mandatory in this skill?

Reversibility ensures that any failed deployment can be safely rolled back using a 'down' method, preventing data corruption and reducing recovery time in production.

How does it handle zero-downtime deployments?

The skill utilizes multi-step approaches for column changes and concurrent index creation to prevent table locking and ensure the database remains accessible during updates.

Backend Migration Standards

Name: Backend Migration Standards
Author: Microck

byMicrock

•

データベース管理

Manages database schema and data migrations using industry-standard patterns for reversibility and zero-downtime deployments.

This skill equips Claude with specialized knowledge to handle complex database migrations across various frameworks like Alembic, Rails, and Sequelize. It enforces strict standards for reversible changes, ensures zero-downtime strategies such as concurrent indexing and multi-step column removal, and maintains a clear distinction between schema modifications and data transformations. By adhering to these standards, the skill prevents common pitfalls like table locking, broken rollbacks, and non-idempotent data scripts in production environments, making it an essential tool for backend engineers and DevOps specialists.

主な機能

01Implementation of zero-downtime deployment strategies for high-traffic schema changes.

0281 GitHub stars

03Safe handling of production indexes using concurrent creation patterns.

04Enforcement of standardized naming conventions and file organization for versioning.

05Clear separation between structural schema changes and operational data transformations.

06Automated generation of reversible migration files with mandatory rollback logic.

ユースケース

01Creating complex, batch-processed data migration scripts for large-scale datasets.

02Modifying existing production database schemas without interrupting live application traffic.

03Standardizing migration workflows across polyglot environments using Python, Ruby, or JavaScript.

What are Skills?·How to Install

Install with 🐟 Skill.Fish

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

For use in Claude.ai and ChatGPT

Download Skill