Writing Migrations

What problem does it solve?

This Skill automates the creation and management of database schema changes using Alembic, ensuring that all modifications are reversible and tracked.

Core Features & Use Cases

• Automated Migration Generation: Generates initial migration scripts based on schema differences.
• Safe Schema Evolution: Provides clear upgrade and downgrade functions for every change.
• Data Migration Separation: Guides users to keep schema and data modifications distinct.
• Use Case: When adding a new email column to the users table, this Skill helps generate the necessary Alembic script to add the column, populate it with existing data if needed, and ensure it can be safely removed.

Quick Start

Use the writing migrations skill to generate a new Alembic migration script for adding a 'completed_at' timestamp column to the 'tasks' table.