data-migration

SKILL.md

Example \\\`sql -- Step 1: Add column ALTER TABLE users ADD COLUMN emailnew VARCHAR(255);

-- Step 2: Backfill UPDATE users SET emailnew = email WHERE emailnew IS NULL;

-- Step 3: Swap ALTER TABLE users DROP COLUMN email; ALTER TABLE users RENAME COLUMN emailnew TO email; \\\`

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. Source: microck/ordinary-claude-skills.

View raw