db-migrate

Files

---
name: db-migrate
description: Generate database migrations from schema changes
version: 1.1.0
---

# Database Migration Generator

Create migration files for schema changes.

## Supported ORMs

- Prisma
- Drizzle
- TypeORM
- Sequelize
- Django ORM
- SQLAlchemy

## Features

- Detects schema differences
- Generates up/down migrations
- Handles relationships
- Preserves data
- Safe operations first

## Migration Types

- Create table
- Alter table
- Add/drop column
- Add/drop index
- Add/drop constraint
- Rename operations

## Example Output

```sql
-- Migration: add_user_profile
-- Created: 2024-01-15

-- UP
ALTER TABLE users ADD COLUMN bio TEXT;
ALTER TABLE users ADD COLUMN avatar_url VARCHAR(255);
CREATE INDEX idx_users_created_at ON users(created_at);

-- DOWN
DROP INDEX idx_users_created_at;
ALTER TABLE users DROP COLUMN avatar_url;
ALTER TABLE users DROP COLUMN bio;
```

## Safety Checks

- Warns about data loss
- Suggests backups
- Validates foreign keys
- Checks constraints