Database Migration

The database-migration skill enables AI agents to execute schema changes and data transformations across various database systems. It automates the process of updating table structures, adding columns, or modifying relationships without manual SQL intervention.

When to use it

• Updating legacy database schemas to support new application features.
• Adding new columns or altering existing field types during a release cycle.
• Refactoring data models to improve query performance or normalization.
• Applying consistent structural changes across multiple development environments.

Key capabilities

• Generates and executes SQL migration scripts automatically.
• Supports schema evolution for relational databases.
• Handles column additions, removals, and type modifications.
• Manages foreign key constraints and index updates.

Example prompts

• "Create a migration to add a user_preferences JSON column to the users table."
• "Refactor the orders table by splitting it into order_items and updating existing data accordingly."
• "Generate a reversible migration script to drop the deprecated legacy_id column from the products table."

Tips & gotchas

Ensure your AI agent has appropriate read/write permissions on the target database before running migrations. Always test generated scripts in a staging environment first, as schema changes can impact dependent applications or data integrity if not rolled back correctly.