Back to Skills

data-migration

majiayu000
Updated Today
3 views
58
9
58
View on GitHub
Testingdata

About

This skill helps developers safely plan and execute database and system migrations, including schema changes, data transformations, and moving between database systems. It provides capabilities for versioned migrations, rollback strategies, and data integrity validation. Use it when you need to perform zero-downtime migrations, backfill data, or ensure reliable system transitions.

Quick Install

Claude Code

Recommended
Plugin CommandRecommended
/plugin add https://github.com/majiayu000/claude-skill-registry
Git CloneAlternative
git clone https://github.com/majiayu000/claude-skill-registry.git ~/.claude/skills/data-migration

Copy and paste this command in Claude Code to install this skill

Documentation

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

  1. Add new column
  2. Dual-write to old & new
  3. Backfill historical data
  4. Switch reads to new column
  5. 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

GitHub Repository

majiayu000/claude-skill-registry
Path: skills/data-migration

Related Skills

content-collections

Meta

This skill provides a production-tested setup for Content Collections, a TypeScript-first tool that transforms Markdown/MDX files into type-safe data collections with Zod validation. Use it when building blogs, documentation sites, or content-heavy Vite + React applications to ensure type safety and automatic content validation. It covers everything from Vite plugin configuration and MDX compilation to deployment optimization and schema validation.

View skill

llamaindex

Meta

LlamaIndex is a data framework for building RAG-powered LLM applications, specializing in document ingestion, indexing, and querying. It provides key features like vector indices, query engines, and agents, and supports over 300 data connectors. Use it for document Q&A, chatbots, and knowledge retrieval when building data-centric applications.

View skill

hybrid-cloud-networking

Meta

This skill configures secure hybrid cloud networking between on-premises infrastructure and cloud platforms like AWS, Azure, and GCP. Use it when connecting data centers to the cloud, building hybrid architectures, or implementing secure cross-premises connectivity. It supports key capabilities such as VPNs and dedicated connections like AWS Direct Connect for high-performance, reliable setups.

View skill

polymarket

Meta

This skill enables developers to build applications with the Polymarket prediction markets platform, including API integration for trading and market data. It also provides real-time data streaming via WebSocket to monitor live trades and market activity. Use it for implementing trading strategies or creating tools that process live market updates.

View skill