How does this handle migration rollbacks?

It includes patterns for implementing proper downgrade functions in every migration to ensure all schema changes are safely reversible.

Can I perform migrations without application downtime?

Yes, the skill provides specific patterns for creating indexes concurrently and performing two-phase column additions to avoid blocking table locks.

Does it work with FastAPI startup tasks?

Yes, the skill includes guidance on running migrations during the FastAPI lifespan or via entrypoint scripts to handle event loop conflicts.

Does this skill support SQLAlchemy 2.0 async?

Yes, it is specifically architected for SQLAlchemy 2.0 using the asyncpg driver, providing the necessary async-ready env.py configurations.

Can I autogenerate migrations from my models?

Absolutely. It supports the alembic revision --autogenerate workflow while providing best practices for reviewing and refining the generated SQL.

Alembic Database Migrations

Name: Alembic Database Migrations
Author: yonatangross

byyonatangross

•

Database Management

Manages SQLAlchemy 2.0 async database migrations and zero-downtime schema changes with production-ready patterns.

The Alembic Migrations skill equips Claude with the expertise to handle complex database schema versioning in modern Python environments. Specifically optimized for SQLAlchemy 2.0 and asynchronous drivers like asyncpg, this skill provides standardized patterns for initializing async migration environments, autogenerating revisions from models, and implementing high-stakes changes like concurrent index creation and two-phase migrations. It is an essential tool for developers building scalable backends where database integrity and zero-downtime deployments are critical requirements.

Key Features

01Concurrent Index Creation (Non-blocking)

02Zero-Downtime Migration Patterns

0369 GitHub stars

04SQLAlchemy 2.0 Async/Asyncpg Integration

05Two-Phase NOT NULL Implementations

06Autogenerate Revision Management

Use Cases

01Automating the synchronization between SQLAlchemy models and database schema versions.

02Modifying large production tables using safe, non-locking migration strategies.

03Setting up an async-ready Alembic environment for a new FastAPI or Starlette project.

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add yonatangross/orchestkit alembic-migrations

For use in Claude.ai and ChatGPT

Download Skill