Database Migrations Sql Migrations

What it does

This skill automates the process of managing changes to your database schema using SQL migration files. It allows you to apply, rollback, and version control these changes in a structured way, ensuring consistency across different environments. The agent can generate migration scripts based on provided instructions or existing schemas.

When to use it

• You need to update the structure of an existing database (e.g., adding new tables or columns).
• You want to apply database schema changes consistently across development, testing, and production environments.
• You're collaborating with a team on a project involving database modifications and require version control for these changes.
• You need to revert a previous database change due to an error or unexpected behavior.

Key capabilities

• Generate SQL migration scripts.
• Apply generated migrations to a database.
• Rollback applied migrations.
• Version control of migration files.

Example prompts

• "Create a new migration script to add a 'user_roles' table with columns 'role_id' and 'role_name'."
• "Apply all pending SQL migrations to the development database."
• "Rollback the last applied migration."

Tips & gotchas

The agent requires access to your database credentials and connection details. Ensure that the provided instructions for generating or applying migrations are accurate and compatible with your specific database system (e.g., PostgreSQL, MySQL).