Alembic Migration Management

This skill provides a comprehensive guide to managing database schema and data migrations using Alembic.

Core Workflow

1. Initialization & Configuration: Set up Alembic for a new project.

   • See

     references/01_initialization_and_configuration.md

     for detailed setup instructions and configuration templates.

2. Generating Migrations: Create new migration files.

   • See

     references/02_generating_migrations.md

     for guidance on

     autogenerate

     vs. manual creation.

3. Writing Migration Scripts: Implement the upgrade and downgrade logic.

   • See

     references/03_migration_script_patterns.md

     for common patterns and examples (creating tables, adding columns).

4. Handling Data Migrations: Perform data backfilling or transformations.

   • See

     references/04_data_migrations.md

     for patterns and safety checks.

5. Testing & CI/CD: Ensure migrations are safe and automated.

   • See

     references/05_testing_and_ci_cd.md

     for testing strategies and CI/CD integration examples.

6. Deployment & Rollbacks: Manage migrations in production.

   • See

     references/06_rollbacks_and_production.md

     for a production checklist and a rollback playbook.

Bundled Resources

• Configuration Templates:

  • assets/alembic.ini.template

    : A ready-to-use template for

    alembic.ini

    .

  • assets/env.py.template

    : A template for

    env.py

    to connect to your database and models.