Files
Magnus HedemarkGitHubusername <username>factory-droid[bot] <138933559+factory-droid[bot]@users.noreply.github.com>
652521a09e feat(migration-engineering): add migration-engineering skill (#222)
* feat(migration-engineering): add migration-engineering skill

Add the migration-engineering skill for safe cross-system migrations:
schema, data, API, infrastructure, and service migrations.

- SKILL.md: expand/contract pattern, compatibility windows, dual-running,
  backfills, reconciliation, cutover, deprecation, and cleanup. Four distinct
  recovery paths (rollback, roll-forward, restore, irreversible). Structured
  planning fields for reconciliation, correctness evidence, observability,
  customer impact, and ownership. Four migration types with detailed
  compatibility/correctness/recovery characteristics. Specialist routing
  to api-design-and-evolution, data-engineering, platform-engineering,
  release-engineering, site-reliability-engineering, implementation-planning,
  secure-software-engineering, qa-methodology, and verification-methodology.
  Prose routing to production-readiness and production-excellence.
- README.md: human-facing overview with all five required sections.
- references/discovery-brief.md: bounded survey of migration-adjacent skills
  and clear ownership boundaries.
- references/compatibility-patterns.md: forward/backward compatibility by type.
- references/recovery-classification.md: four recovery paths with decision tree.
- templates/: migration plan, compatibility matrix, reconciliation plan,
  cutover and recovery record.
- evals/evals.json: 5 output-quality cases covering additive schema change,
  backfill with reconciliation, API version migration, irreversible cutover,
  and reconciliation failure.

Co-authored-by: factory-droid[bot] <138933559+factory-droid[bot]@users.noreply.github.com>

* chore(migration-engineering): update catalogs and routing

Regenerate catalog files and add migration-engineering entries to
root README.md catalog and references/skill-triggers.md.

Co-authored-by: factory-droid[bot] <138933559+factory-droid[bot]@users.noreply.github.com>

---------

Co-authored-by: username <username>
Co-authored-by: factory-droid[bot] <138933559+factory-droid[bot]@users.noreply.github.com>
2026-08-02 18:16:04 -04:00

1.5 KiB

Reconciliation Plan Template

Design a reconciliation strategy for a data migration. Fill one template per data source/target pair.

Data scope

Field Value
Source system
Target system
Data domain (tables, collections, keyspaces)
Estimated record count
Primary key or natural key

Reconciliation dimensions

Completeness

Field Value
Method Row count comparison / Key-space scan / Checksum comparison
Frequency
Pass threshold (e.g., "exact match", "within 0.01%")

Accuracy

Field Value
Method Field-level comparison / Hash comparison / Sample verification
Sample size (if sampled)
Fields compared
Tolerance per field (e.g., "amount: within 0.01", "timestamp: within 1s")
Frequency

Timeliness

Field Value
Lag tolerance (e.g., "target within 5 seconds of source")
Measurement method
Frequency

Consistency

Field Value
Related-record checks (e.g., "every order has matching line items")
Referential-integrity checks
Frequency

Reconciliation failure protocol

Condition Action
Completeness check fails
Accuracy check fails
Timeliness check fails
Consistency check fails

Reconciliation run log

Run timestamp Completeness result Accuracy result Timeliness result Consistency result Overall Action taken