$pwd:

data-migration

Name: Data Migration
Author: korallis

// 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.

$ git log --oneline --stat

stars:49

forks:6

updated:November 26, 2025 at 23:09

SKILL.md

readonly

package.json

"author": "korallis"

"repository": "korallis/Droidz"

$ git clone

$ download --local

[HINT] Download the complete skill directory including SKILL.md and all related files

related-imports.ts

// Related Skills

import sql-optimization-patterns

from "wshobson"

23,105

import database-migration

import data-model-creation

from "TencentCloudBase"

308

import backend-migration-standards

from "maxritter"

216

import wheels-migration-generator

from "wheels-dev"

200

import wheels-migration-generator

from "wheels-dev"

200

import database-implementation

from "jpicklyk"

111

import backend-migrations

from "maxritter"

import backend-queries

from "maxritter"

import database-design

from "skillcreatorai"

import discover-database

from "rand"

data-migration

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; ```

Resources

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; ```

Resources

Database Migrations