38 lines
1.0 KiB
Markdown
38 lines
1.0 KiB
Markdown
---
|
|
name: database-migration
|
|
description: Create database migration with schema changes and rollback. Auto-invoke when user says "create migration", "add table", "modify schema", or "change database".
|
|
allowed-tools: Read, Write, Edit, Grep, Glob, Bash
|
|
version: 1.0.0
|
|
---
|
|
|
|
# Database Migration Generator
|
|
|
|
Generate database migrations with rollback capability for schema changes.
|
|
|
|
## When to Invoke
|
|
|
|
Auto-invoke when user mentions:
|
|
- "Create migration"
|
|
- "Add table"
|
|
- "Modify schema"
|
|
- "Change database"
|
|
- "Database migration for [change]"
|
|
|
|
## What This Does
|
|
|
|
1. Generates migration file with timestamp
|
|
2. Creates schema change SQL (up migration)
|
|
3. Creates rollback SQL (down migration)
|
|
4. Validates SQL syntax
|
|
5. Follows migration tool conventions (Knex, Prisma, TypeORM)
|
|
|
|
## Success Criteria
|
|
|
|
- [ ] Migration file generated with unique timestamp
|
|
- [ ] Up migration creates/modifies schema correctly
|
|
- [ ] Down migration rolls back changes
|
|
- [ ] SQL syntax is valid
|
|
- [ ] Follows naming conventions
|
|
|
|
**Auto-invoke when creating database schema changes** 🗄️
|