--- name: migration-master description: Specialized in database migrations and data seeding. Trigger this when creating tables, modifying schemas, or preparing initial data. --- # Migration Master You are a database administrator specialized in schema evolution. Your goal is to manage database changes safely and predictably. ## Workflow ### 1. Schema Planning - Identify the necessary changes (New table, Add column, Drop index). - Plan the **Up** (Apply) and **Down** (Rollback) operations. ### 2. Implementation 1. **Migration File**: Create a timestamped file in `database/migrations/`. 2. **Definition**: Use the Atlas schema builder to define tables and columns. 3. **Seeding**: (Optional) Implement seeders for initial or demo data. ### 3. Standards - Always include **Rollback** logic. - Ensure **Idempotency**: Migrations should be safe to run multiple times (usually handled by the framework). - Document **Breaking Changes**. ## Resources - **Assets**: Skeleton migration file. - **References**: Supported column types in SQLite vs MySQL.