Database Migrations

What it does

This skill automates and manages database migrations. It allows you to apply changes to your database schema in a controlled, versioned manner, ensuring consistency across different environments. The tool handles generating migration files, executing them, and reverting if necessary, simplifying the process of evolving your database structure.

When to use it

• You need to update your application's database schema (e.g., adding new tables or columns).
• You are deploying changes across multiple environments (development, staging, production).
• You want a way to track and manage changes to your database over time.
• Rolling back database changes is required due to errors during deployment.

Key capabilities

• Generates migration files based on schema changes.
• Executes generated migrations against the target database.
• Provides rollback functionality for applied migrations.
• Version control of database schema changes.

Example prompts

• "Generate a migration file to add a new column 'email' to the 'users' table."
• "Apply all pending migrations to the production database."
• "Revert the last three migrations from the staging environment."

Tips & gotchas

This skill requires an existing database and appropriate credentials for access. Ensure you have configured the necessary connection details before attempting to generate or apply migrations.