Can I use this for reversible data transformations?

Absolutely. It includes patterns for keeping original columns during transformation phases, ensuring you can roll back data changes without losing the source information.

Does it help with foreign key constraints?

Yes, it provides strategies for adding and removing foreign keys on existing data, including cleanup scripts for orphaned records and validation checks to prevent migration failures.

Does it support the MySQL 8.0 INSTANT algorithm?

Yes, the skill includes patterns optimized for MySQL 8.0.12+ features, allowing for metadata-only changes that complete in microseconds even on massive tables.

How does this skill help with large production tables?

It provides specific patterns and command templates for using Online DDL algorithms and external tools like Percona Toolkit (pt-osc) and gh-ost to prevent long-running table locks.

MySQL Migration Patterns

Name: MySQL Migration Patterns
Author: jsamuelsen11

byjsamuelsen11

0•

Database Management

Implements safe, reversible, and production-grade MySQL schema migrations using industry-standard patterns and zero-downtime tools.

The MySQL Migration Patterns skill equips Claude with specialized knowledge for planning and executing database schema changes while maintaining high availability and data integrity. It provides standardized patterns for Up/Down migration pairs, expert guidance on MySQL Online DDL algorithms (INSTANT, INPLACE, COPY), and advanced strategies for managing multi-million row tables using tools like Percona Toolkit and gh-ost. By following these patterns, developers can ensure their migrations are reversible, minimize locking on production databases, and maintain a clear audit trail for complex schema evolutions.

Key Features

01Provides configurations for large-scale migrations via pt-online-schema-change and gh-ost

020 GitHub stars

03Generates reversible Up/Down SQL migration scripts for all schema changes

04Selects optimal DDL algorithms to prevent table locking and downtime

05Implements safe data transformation patterns that preserve original data during updates

06Automates foreign key constraint management and validation logic

Use Cases

01Performing complex data normalization on large datasets using multi-step migration strategies

02Refactoring legacy database schemas with guaranteed rollback paths for deployment safety

03Adding columns or indexes to high-traffic production databases without service interruption

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add jsamuelsen11/claude-config migration-patterns

For use in Claude.ai and ChatGPT

Download Skill