fastapi-alembic-migrations

What problem does it solve?

This Skill provides a ready-to-use configuration for integrating Alembic migrations with SQLAlchemy 2.0 in asynchronous projects, addressing the challenge of running migrations in async environments and ensuring compatibility with FastAPI apps.

Core Features & Use Cases

• Async-ready Alembic setup for SQLAlchemy 2.0 with auto-detection of models.
• Custom env.py template that uses async engines and proper target_metadata.
• Use Case: Initialize migrations in a new FastAPI project using async SQLAlchemy and apply migrations without blocking.

Quick Start

Initialize Alembic for an async project and adapt env.py to use an async engine, then generate and apply migrations with the usual alembic commands.