Database Migration Generator

What it does

The database-migration-generator skill automatically generates SQL migration scripts based on provided schema definitions or changes. It can handle creating new tables, modifying existing ones (adding/removing columns), and generating rollback scripts for safe deployments. This reduces manual effort and potential errors in database evolution processes.

When to use it

• Database Schema Updates: When you need to update your database structure due to application requirements or feature additions.
• Automated Deployments: Integrate into CI/CD pipelines to automate the process of applying schema changes across environments.
• Refactoring Existing Databases: Generate migration scripts for transitioning a legacy database to a newer version or design.
• Team Collaboration: Standardize database change management and ensure consistency among developers working on different parts of an application.

Key capabilities

• Generates SQL migration scripts (up and down/rollback)
• Handles table creation, modification, and deletion
• Supports adding and removing columns with various data types
• Creates rollback scripts to revert changes safely

Example prompts

• "Generate a migration script to add a 'users' table with columns: id (integer primary key), name (varchar(255)), email (varchar(255) unique)."
• "Create a migration to remove the 'old_column' from the 'products' table."
• “Generate migrations for adding an index on the email column of the users table.”

Tips & gotchas

The skill requires clear and precise schema definitions as input. Ambiguous or incomplete information will result in inaccurate migration scripts, so be sure to provide all relevant details about your desired database changes.