validate-migration

Phase 0: Vault RAG (MANDATORY, BEFORE any Read/Grep)

You MUST call query_vault(query, service_filter) BEFORE reading codebase files or external sources. This is enforced by hook. No exceptions.

---

Validate Migration

Working Directories

1. Obsidian workspace: __VAULT_ROOT__
2. Codebase: __CODEBASE_ROOT__

---

Common Agent Mistakes

1. No rollback plan: Approving a migration without verifying down() exists and is correct. Every migration MUST have a working rollback or explicit acknowledgment of irreversibility.
2. Missing CONCURRENTLY: Not flagging CREATE INDEX without CONCURRENTLY on any table. This locks the table for writes during index creation.
3. Ignoring dual-database (svc-experiences): Validating the migration SQL but not reminding about the dual-database requirement. Both dev and spec databases need migration.
4. Underestimating table size: Not checking the large table risk list before approving an ALTER TABLE. Always cross-reference Phase 2 table.
5. Single-step risky operations: Not suggesting zero-downtime recipes for column renames, type changes, or constraint additions on large tables. Always recommend the multi-step approach.
6. Transaction + CONCURRENTLY conflict: Not catching CREATE INDEX CONCURRENTLY inside a transaction. TypeORM wraps migrations in transactions by default.

---

Phase 0: Discover and Classify

Find migration files

1. If $ARGUMENTS provided, use that path directly
2. Otherwise, find migration files in the current branch diff:

GIT_EDITOR=true git diff --name-only main...HEAD | grep -iE "(migrat|\.sql)"

Detect ORM framework

Service	ORM	Migration format	Location
svc-experiences	TypeORM	TypeScript classes with up()/down()	src/migration/
svc-order	Sequelize	JS files with up()/down()	db/migrations/
svc-ee-offer	Sequelize	JS files	db/migrations/
svc-search	Sequelize	JS files	db/migrations/
svc-auth	Prisma	.prisma schema + SQL	prisma/migrations/