managing-database-migrations

What problem does it solve?

This skill empowers Claude to handle database migrations, including creating new migrations, applying changes, and rolling back previous modifications. It ensures that database schema changes are managed safely and efficiently across various database systems like PostgreSQL, MySQL, SQLite, and MongoDB.

Core Features & Use Cases

• Migration File Generation: Create timestamped migration files with "up" and "down" methods.
• Apply & Rollback: Safely apply schema changes or revert to previous states.
• Schema Evolution Tracking: Maintain a clear history of database schema changes.
• Use Case: Generate a migration to add an email column to the users table, complete with both forward and rollback SQL.

Quick Start

User request: "Create a migration to add an 'email' column to the 'users' table."

The skill will:

1. Generate a new migration file with timestamped name.
2. Populate the 'up' migration with SQL to add the 'email' column to the 'users' table.
3. Populate the 'down' migration with SQL to remove the 'email' column from the 'users' table.