Migrating — Safe Destructive Data Operations
Execute data migrations with full safety harness: snapshot, dry-run, gate, apply, verify, confirm idempotency. Never destructive-first.
Announce at start: "I'm using the migrating skill for a safe data migration with snapshot/dry-run/gate/apply/verify/idempotency checks."
When to Use
post_content rewrites (injecting blocks, replacing shortcodes, updating markup)wp_postmeta cleanup (orphan keys, schema changes, re-computing derived values)- Term taxonomy fixes (renaming, merging, re-assigning terms)
- Attachment regeneration (thumbnails, metadata, rewriting paths)
- User role migrations
- Bulk option updates with serialized data
- Any operation that could lose data if applied incorrectly
When NOT to Use
- Developer-only refactors that don't touch DB data — use
/building or direct edits
- Simple one-shot admin tasks — use
lando wp directly
- Schema changes at the table level — use Laravel migrations or
acorn-eloquent
- Long-running pipelines with failure-retry needs — use
acorn-queues with jobs
Input
$ARGUMENTS
Resolve to a migration name (used for snapshot filenames and logs) and target scope.
Hard Gates
- Never apply without snapshot-before. If the snapshot step fails, STOP.
- Never apply without human approval of the dry-run diff. Autonomous apply is forbidden.
- Never declare done without snapshot-after verification proving row counts, field shapes, and spot-check samples match expectations.
- Never leave the migration without idempotency proof. Re-running must be a no-op (0 rows changed).
The 7-Phase Contract
┌─────────────────────────────────────────────────────────┐
│ 1. SNAPSHOT BEFORE → /tmp/<migration>-before.xml │
├─────────────────────────────────────────────────────────┤
│ 2. DRY-RUN COMPUTE → list affected rows + new shape │
├─────────────────────────────────────────────────────────┤
│ 3. HUMAN APPROVAL → show diff, pause, await 'y' │
├─────────────────────────────────────────────────────────┤
│ 4. PREFLIGHT CHECKS → orphan meta, template validity │
├─────────────────────────────────────────────────────────┤
│ 5. APPLY → loop, log progress, wp_slash() │
├─────────────────────────────────────────────────────────┤
│ 6. SNAPSHOT AFTER → /tmp/<migration>-after.xml │
│ + VERIFY → count + shape + spot-check │
├─────────────────────────────────────────────────────────┤
│ 7. IDEMPOTENCY CHECK → re-run, assert 0 rows changed │
└─────────────────────────────────────────────────────────┘
Full phase procedures (commands, scripts, validation criteria):
skills/migrating/references/phase-detail.md
Rollback procedures for all 3 tiers:
skills/migrating/references/rollback-playbook.md
Rollback (Summary)
If post-verification anything is wrong, use the lowest-impact tier:
- Tier 1 —
lando wp post list --post_type=revision --post_parent=<ID> then lando wp post update <ID> --post_content="$(lando wp post get <REVISION-ID> --field=post_content)" (single post, revisions enabled)
- Tier 2 —
lando wp db import /tmp/<migration>-postmeta-before.sql (table-level)
- Tier 3 —
lando wp db import /tmp/<migration>-full-before.sql (nuclear, last resort)
Always have the Tier 3 snapshot before applying.
Anti-Drift — Don't Do This
| Wrong |
Correct |
| Apply first, snapshot after |
Snapshot BEFORE apply, always |
| Skip dry-run ("trust me") |
Dry-run + diff always — no autonomous apply |
| Approve on silence |
Explicit 'y' required; silence is not consent |
Bulk $wpdb->update() without wp_slash() |
wp_slash() for user content |
| One-shot script with no idempotency check |
Re-run after apply, assert 0 updates |
| Delete target rows before apply |
Never; update in place, rollback via snapshot |
Skip _wp_page_template preflight |
Check orphan meta before wp_update_post |
| Apply without Tier-3 snapshot |
lando wp db export full DB before any destructive op |
1---2name: superpowers-sage-migrating3description: WordPress migration to Sage/Acorn — migrate classic theme to Sage, incremental migration, 7-phase migration contract, rollback playbook, migration hard gates, functions.php to Service Providers, shortcodes to Blade, CPT registration to Poet, field groups to ACF Composer, safe migration reversible steps, migration output artifacts, legacy plugin to Acorn, wp-content to Bedrock structure, database migration, content migration4---56# Migrating — Safe Destructive Data Operations78Execute data migrations with full safety harness: snapshot, dry-run, gate, apply, verify, confirm idempotency. Never destructive-first.910**Announce at start:** "I'm using the migrating skill for a safe data migration with snapshot/dry-run/gate/apply/verify/idempotency checks."1112## When to Use1314- `post_content` rewrites (injecting blocks, replacing shortcodes, updating markup)15- `wp_postmeta` cleanup (orphan keys, schema changes, re-computing derived values)16- Term taxonomy fixes (renaming, merging, re-assigning terms)17- Attachment regeneration (thumbnails, metadata, rewriting paths)18- User role migrations19- Bulk option updates with serialized data20- Any operation that could lose data if applied incorrectly2122## When NOT to Use2324- Developer-only refactors that don't touch DB data — use `/building` or direct edits25- Simple one-shot admin tasks — use `lando wp` directly26- Schema changes at the table level — use Laravel migrations or `acorn-eloquent`27- Long-running pipelines with failure-retry needs — use `acorn-queues` with jobs2829## Input3031$ARGUMENTS3233Resolve to a migration name (used for snapshot filenames and logs) and target scope.3435## Hard Gates3637- **Never apply without snapshot-before.** If the snapshot step fails, STOP.38- **Never apply without human approval of the dry-run diff.** Autonomous apply is forbidden.39- **Never declare done without snapshot-after verification** proving row counts, field shapes, and spot-check samples match expectations.40- **Never leave the migration without idempotency proof.** Re-running must be a no-op (0 rows changed).4142## The 7-Phase Contract4344```45┌─────────────────────────────────────────────────────────┐46│ 1. SNAPSHOT BEFORE → /tmp/<migration>-before.xml │47├─────────────────────────────────────────────────────────┤48│ 2. DRY-RUN COMPUTE → list affected rows + new shape │49├─────────────────────────────────────────────────────────┤50│ 3. HUMAN APPROVAL → show diff, pause, await 'y' │51├─────────────────────────────────────────────────────────┤52│ 4. PREFLIGHT CHECKS → orphan meta, template validity │53├─────────────────────────────────────────────────────────┤54│ 5. APPLY → loop, log progress, wp_slash() │55├─────────────────────────────────────────────────────────┤56│ 6. SNAPSHOT AFTER → /tmp/<migration>-after.xml │57│ + VERIFY → count + shape + spot-check │58├─────────────────────────────────────────────────────────┤59│ 7. IDEMPOTENCY CHECK → re-run, assert 0 rows changed │60└─────────────────────────────────────────────────────────┘61```6263> Full phase procedures (commands, scripts, validation criteria):64> `skills/migrating/references/phase-detail.md`6566> Rollback procedures for all 3 tiers:67> `skills/migrating/references/rollback-playbook.md`6869## Rollback (Summary)7071If post-verification anything is wrong, use the lowest-impact tier:7273- **Tier 1** — `lando wp post list --post_type=revision --post_parent=<ID>` then `lando wp post update <ID> --post_content="$(lando wp post get <REVISION-ID> --field=post_content)"` (single post, revisions enabled)74- **Tier 2** — `lando wp db import /tmp/<migration>-postmeta-before.sql` (table-level)75- **Tier 3** — `lando wp db import /tmp/<migration>-full-before.sql` (nuclear, last resort)7677Always have the Tier 3 snapshot before applying.7879## Anti-Drift — Don't Do This8081| Wrong | Correct |82|---|---|83| Apply first, snapshot after | Snapshot BEFORE apply, always |84| Skip dry-run ("trust me") | Dry-run + diff always — no autonomous apply |85| Approve on silence | Explicit 'y' required; silence is not consent |86| Bulk `$wpdb->update()` without `wp_slash()` | `wp_slash()` for user content |87| One-shot script with no idempotency check | Re-run after apply, assert 0 updates |88| Delete target rows before apply | Never; update in place, rollback via snapshot |89| Skip `_wp_page_template` preflight | Check orphan meta before `wp_update_post` |90| Apply without Tier-3 snapshot | `lando wp db export` full DB before any destructive op |
hekivo