Migration Generate

What it does

The migration-generate skill assists in generating migration scripts for database changes. It can produce SQL statements to update a schema from one version to another, facilitating smoother transitions during application deployments or data model evolution. This helps automate tedious manual scripting and reduces the risk of errors during migrations.

When to use it

• You need to upgrade a database schema from an older version to a newer version.
• You're refactoring your database structure and require scripts to apply changes incrementally.
• You want to automate the generation of SQL migration files, reducing manual effort and potential errors.
• You are working with different database systems and need consistent migration logic across them.

Key capabilities

• Generates SQL statements for schema migrations.
• Supports incremental updates between database versions.
• Automates script creation to reduce manual labor.

Example prompts

• "Generate a migration script from version 1.0 to 1.1 of my database schema."
• "Create the SQL needed to add a new column 'email' to the 'users' table."
• “Show me how to drop the old ‘products’ table and create a new one with updated columns.”

Tips & gotchas

The skill requires detailed information about the source and target database schemas. Providing clear specifications of existing tables, columns, data types, and constraints is crucial for accurate migration script generation.