The-AI-Directory-Company/agents-and-skills / skills/data-migration-plan
data-migration-plan
VerifiedPlan and execute data migrations with phased rollout — dual-write, backfill, cutover, and verification stages with rollback triggers and data integrity checks at every step.
| File | Kind | Size |
|---|---|---|
| SKILL.md | skill md | 6.9 KB |
| assets/migration-checklist.md | markdown | 2.2 KB |
| assets/rollback-plan-template.md | markdown | 2.3 KB |
| examples/mysql-column-rename.md | markdown | 3.6 KB |
| examples/postgres-to-new-schema.md | markdown | 3.6 KB |
| scripts/integrity-check.sql | other | 4.1 KB |
assets/migration-checklist.md
View on GitHub# Pre-Migration Assessment Checklist
Complete every section before writing migration code. Blank fields indicate gaps that must be resolved first.
---
## 1. Migration Summary
| Field | Value |
|-------|-------|
| Migration name | |
| Owner | |
| Target date | |
| Downtime tolerance | Zero / Maintenance window: ______ |
| Rollback deadline (point of no return) | |
---
## 2. Schema Change Description
**Current state**:
```
-- Paste current schema (CREATE TABLE or relevant DDL)
```
**Target state**:
```
-- Paste target schema
```
**What changes**: (renamed columns, type changes, new tables, split tables, etc.)
---
## 3. Service Catalog
List every service, job, and query that reads or writes the affected tables.
| Service / Job | Read / Write / Both | Owner | Migration needed? | Status |
|---------------|---------------------|-------|-------------------|--------|
| | | | | |
| | | | | |
| | | | | |
| | | | | |
---
## 4. Foreign Key Dependencies
| Table | FK Column | References | Cascade behavior | Impact |
|-------|-----------|------------|-------------------|--------|
| | | | | |
| | | | | |
---
## 5. Data Volume
| Table | Row count | Size on disk | Growth rate (rows/day) |
|-------|-----------|--------------|------------------------|
| | | | |
| | | | |
---
## 6. Baseline Performance
Measure before migration. Compare after cutover.
| Query / Operation | p50 (ms) | p99 (ms) | Measured on |
|-------------------|----------|----------|-------------|
| | | | |
| | | | |
---
## 7. Backfill Estimates
| Parameter | Value |
|-----------|-------|
| Total rows to backfill | |
| Batch size | |
| Estimated batches | |
| Estimated duration (production-scale replica) | |
| Throttle threshold (replica lag) | |
---
## 8. Backup Verification
| Check | Status | Verified by | Date |
|-------|--------|-------------|------|
| Backup exists for affected tables | | | |
| Backup restore tested on staging | | | |
| Restore time measured | | | |
| Restored data spot-checked for correctness | | | |
---
## 9. Readiness Sign-Off
| Role | Name | Approved? | Date |
|------|------|-----------|------|
| Migration owner | | | |
| Data owner | | | |
| DBA / SRE | | | |
| Dependent service owner(s) | | | |
Related skills
| Skill | Stars | Updated | Works with | Status | Install |
|---|---|---|---|---|---|
| slack-gif-creatoranthropics/skillsKnowledge and utilities for creating animated GIFs optimized for Slack. Provides constraints, validation tools, and animation concepts. Use when users request animated GIFs for Slack like "make me a GIF of X doing Y for Slack." | Stars: 198k | Updated | Claude CodeCodex | Verified | Install |
| ponytailDietrichGebert/ponytailLazy senior dev mode for any coding task: the smallest change that fully solves it, and a reply a busy human understands in one read. | Stars: 196k | Updated | Claude CodeCodex | Verified | Install |
| ponytail-debtDietrichGebert/ponytailHarvest every shortcut: comment into one debt ledger, so deferrals get tracked instead of forgotten. One-shot report. | Stars: 196k | Updated | Claude CodeCodex | Verified | Install |
| ponytail-debtDietrichGebert/ponytailList every `shortcut:` comment (and older `ponytail:` ones) as a debt ledger. One-shot report, changes nothing. Use for "ponytail debt", "what did ponytail defer", "list the shortcuts", /ponytail-debt. | Stars: 196k | Updated | Claude CodeCodex | Verified | Install |