Database Migration Helper

What it does

The database-migration-helper skill assists with generating SQL migration scripts. It can create migrations based on schema changes, reverse migrations to revert those changes, and apply existing migrations. This simplifies database updates and rollbacks in development and production environments.

When to use it

• You need to update a database schema but want assistance writing the necessary SQL statements.
• You're performing a complex database refactor and require scripts to both add and remove features safely.
• You are debugging an issue requiring you to revert a recent database migration.
• You’re automating your deployment process and need to ensure migrations are applied consistently across environments.

Key capabilities

• Generates SQL migration scripts based on schema differences.
• Creates reverse (rollback) SQL migration scripts.
• Applies existing SQL migration scripts.

Example prompts

• "Generate a migration script to add a column named 'email' of type VARCHAR(255) to the 'users' table."
• "Create a reverse migration for the previous migration."
• "Apply all pending migrations to my database."

Tips & gotchas

The skill requires access to both the old and new database schemas to accurately generate migration scripts. Ensure the AI agent has appropriate permissions to read these schemas.