Database Migrations

What it does

This skill automates and manages changes to your database schema. It allows you to create, apply, and rollback migration files, ensuring a consistent and reproducible process for evolving your database structure over time. This is particularly useful in development environments or when deploying updates across multiple servers.

When to use it

• Database Schema Changes: When you need to add new tables, columns, or modify existing ones in your database.
• Version Control of Database Structure: To track and manage the evolution of your database schema alongside your application code.
• Deployment Pipelines: To automate the process of applying database changes during deployment.
• Rollbacks: When a database change introduces errors, allowing you to revert to a previous stable state.

Key capabilities

• Creates migration files.
• Applies migrations to the database.
• Rolls back applied migrations.

Example prompts

• "Create a new migration to add an email column to the users table."
• "Run all pending migrations."
• "Revert the last three migrations."

Tips & gotchas

This skill requires familiarity with database concepts and potentially specific database management tools (e.g., Rails, Django). Ensure your database is properly configured before using this skill.