Create Database Migration

What it does

This skill generates SQL migration scripts to safely alter your database schema. It handles creating new tables, modifying existing columns, and managing foreign key constraints based on your specific requirements.

When to use it

• You need to add a new column to an existing table without losing current data.
• You are refactoring your schema by splitting one large table into multiple related tables.
• You require a reversible migration script for testing or deployment pipelines.
• You want to ensure foreign key relationships are defined correctly during schema changes.

Key capabilities

• Generates standard SQL ALTER TABLE statements for column modifications.
• Creates new table definitions with appropriate data types and constraints.
• Handles complex operations like adding foreign keys and indexes.
• Produces migration files suitable for frameworks like Knex or raw SQL execution.

Example prompts

• "Create a database migration to add an email_verified boolean column to the users table."
• "Write a migration script to split the orders table into order_items and order_headers with proper foreign keys."
• "Generate a migration to rename the username column to handle in the accounts table and update existing values."

Tips & gotchas

Ensure your AI agent knows the current schema structure, as it cannot infer existing columns or constraints without that context. Always review generated SQL before running it in production, especially when altering data types or removing columns, as these operations can be destructive.