What problem does it solve? Birdhouse maintains two separate SQLite databases (data.db and agents.db), each with its own Kysely migration system, and writing migrations incorrectly can corrupt real user databases. This Skill gives agents a safe, test-driven workflow for creating and verifying migrations without ever touching production data. ## Core Features & Use Cases - Migration Generation: Scaffold timestamped migration files with automatic runner registration using agent-migration:new and data-migration:new scripts. - Test-Based Verification: Validate every migration against fresh databases and real fixture snapshots via the bun test suite, including fixture count updates. - Controlled Application & Rollback: Apply or roll back migrations on specific databases only when a human explicitly requests it, using the db:migrate-* scripts. - Use Case: When adding a notes column to the agents table, generate the migration, implement up/down with raw SQL (including safe SQLite table-recreation patterns), run the test suite, and update TypeScript types — all without touching a real database. ## Quick Start Ask the agent to add a new database migration for the agents table and verify it with the test suite.
