db

# db ## Purpose Database workflow specialist. Handles the parts of database work that cause production incidents — breaking schema changes, migrations without rollback, raw SQL injection vectors, and missing indexes on growing tables. Acts as a pre-deploy gate for any schema change, and generates correct migration files (up + down) for common ORMs. ## Triggers - `/rune db` — manual invocation when schema changes are planned - Called by `cook` (L1): schema change detected in diff - Called by `deploy` (L2): pre-deploy migration safety check - Called by `audit` (L2): database health dimension ## Calls (outbound) - `scout` (L2): find schema files, migration files, ORM config - `verification` (L3): run migration in test environment if configured - `hallucination-guard` (L3): verify SQL syntax and ORM method names ## Called By (inbound) - `cook` (L1): schema change detected in diff - `deploy` (L2): pre-deploy migration safety check - `audit` (L2): database health dimension ## References - `references/scaling-reference.md` — Index strategies, query optimization, N+1 prevention, connection pooling, read replicas, partitioning, sharding, denormalization. Load when scaling, performance, or indexing context detected. ## Executable Steps ### Step 1 — Discovery Invoke `scout` to locate: - Schema definition files: `*.sql`, `schema.prisma`, `models.py`, `*.migration.ts`, `db/migrate/*.rb` - Migration directory and existing migration files (to determine next migration number) - ...