0

Customer identifier migration

agent-skillsdoubt-driven-development

Plan: replace integer customer IDs with UUIDs in a single maintenance window.

Sign in to save downloads to your library and vote.

Preview

Customer identifier migration

Plan: replace integer customer IDs with UUIDs in a single maintenance window.

  1. Disable writes.
  2. Run ALTER TABLE customers DROP COLUMN id CASCADE.
  3. Add a UUID id column and populate it.
  4. Re-enable writes after fifteen minutes.

Claims made by the author:

  • All foreign keys will be recreated automatically.
  • The table contains fewer than one million rows.
  • The operation completes within the maintenance window.
  • The backup from last night is sufficient rollback protection.
  • No external systems persist the integer identifier.

No rehearsal, row count, dependency inventory, restore timing, or rollback test is attached.

Ingestion metadata

Source catalog
agent-skills
Repository
addyosmani/agent-skills · main
File path
evals/fixtures/doubt-driven-development/migration-plan.md
Last refreshed
10/24/2026, 3:00:12 AM (5h ago)
Refresh schedule
Daily · 03:00 UTC
Dedupe status
Unique · deduped by (source, url)