data-migration
44. 安全地规划和执行数据库迁移、数据转换和系统迁移,包括回滚策略和数据完整性验证。用于迁移数据库、转换数据模式、在数据库系统之间移动、实现版本化迁移、处理数据转换、确保数据完整性或计划零停机迁移时使用。
📖 中文导读:44. 安全地规划和执行数据库迁移、数据转换和系统迁移,包括回滚策略和数据完整性验证。用于迁移数据库、转换数据模式、在数据库系统之间移动、实现版本化迁移、处理数据转换、确保数据完整性或计划零停机迁移时使用。 以下正文为该技能的原始 SKILL.md 内容(英文),上方安装命令可直接使用。
name: data-migration description: Plan and execute database migrations, data transformations, and system migrations safely with rollback strategies and data integrity validation. Use when migrating databases, transforming data schemas, moving between database systems, implementing versioned migrations, handling data transformations, ensuring data integrity, or planning zero-downtime migrations.
Data Migration - Safe Schema Changes
When to use this skill
- Migrating database schemas and structures
- Transforming data between formats
- Moving data between database systems
- Implementing versioned database migrations
- Handling data transformations during migrations
- Ensuring data integrity and validation
- Planning zero-downtime migrations
- Rolling back failed migrations safely
- Migrating from legacy systems
- Implementing data backfill strategies
- Testing migrations in staging environments
- Creating migration rollback procedures
When to use this skill
- Migrating data between schemas, zero-downtime deployments.
- When working on related tasks or features
- During development that requires this expertise
Use when: Migrating data between schemas, zero-downtime deployments.
Process
- Add new column
- Dual-write to old & new
- Backfill historical data
- Switch reads to new column
- Remove old column
Example
```sql -- Step 1: Add column ALTER TABLE users ADD COLUMN email_new VARCHAR(255);
-- Step 2: Backfill UPDATE users SET email_new = email WHERE email_new IS NULL;
-- Step 3: Swap ALTER TABLE users DROP COLUMN email; ALTER TABLE users RENAME COLUMN email_new TO email; ```