Skip to content

The-AI-Directory-Company/agents-and-skills / skills/data-migration-plan

data-migration-plan

Verified

Plan and execute data migrations with phased rollout — dual-write, backfill, cutover, and verification stages with rollback triggers and data integrity checks at every step.

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) | | | |
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: 198kUpdated Claude CodeCodexVerifiedInstall
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: 196kUpdated Claude CodeCodexVerifiedInstall
ponytail-debtDietrichGebert/ponytailHarvest every shortcut: comment into one debt ledger, so deferrals get tracked instead of forgotten. One-shot report.Stars: 196kUpdated Claude CodeCodexVerifiedInstall
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: 196kUpdated Claude CodeCodexVerifiedInstall