Ask Db Migration Assistant

What it does

The ask-db-migration-assistant skill assists with database migration tasks. It can generate SQL scripts for schema changes and data migrations, helping to automate the process of moving data between different database systems or versions. This includes generating upgrade/downgrade scripts and handling complex transformations.

When to use it

• You need to migrate a database from one version (e.g., PostgreSQL 12) to another (e.g., PostgreSQL 15).
• You're refactoring your application’s data model and require SQL scripts to update the schema.
• You want to automate the generation of upgrade/downgrade migration scripts for a software project.
• You need assistance in transforming data during a database migration process.

Key capabilities

• Generates SQL scripts for schema changes.
• Creates SQL scripts for data migrations.
• Handles complex transformations during migrations.
• Produces upgrade and downgrade migration scripts.

Example prompts

• "Generate an upgrade script to change the 'users' table from PostgreSQL 12 to 15."
• "Create a data migration script to move customer data from MySQL to PostgreSQL."
• "I need a SQL script to add a new column called 'email_verified' to my users table, with a default value of false."

Tips & gotchas

The skill requires a good understanding of SQL and database schemas. Providing clear instructions about the source and destination databases is crucial for accurate script generation.