Database Migrations Sql Migrations

What it does

This skill automates the process of creating and applying SQL database migrations. It generates migration files based on changes to your schema, executes these migrations against a target database, and allows for rollback operations if needed. This ensures consistent database state across different environments and simplifies version control for database structure.

When to use it

• Deploying application updates: Automatically apply necessary database schema changes when deploying new versions of an application.
• Managing development/staging databases: Quickly synchronize the database structure between a development environment and a staging or production environment.
• Rolling back problematic deployments: Easily revert to a previous database state if a deployment introduces unexpected issues.
• Collaborating on database schema changes: Ensure all team members are working with the same, versioned database structure.

Key capabilities

• Generates SQL migration files.
• Executes generated migrations against a target database.
• Supports rollback of applied migrations.

Example prompts

• "Generate a new migration to add a 'users' table."
• "Apply all pending migrations to the production database."
• "Roll back the last three migrations."

Tips & gotchas

The skill requires access credentials for the target database and familiarity with SQL schema design. Ensure you have appropriate permissions before running any migration operations, as incorrect commands can lead to data loss or corruption.