Manages database schema changes using Alembic for SQLAlchemy 2.0 async applications.
This skill provides professional-grade patterns for managing database migrations in asynchronous Python environments using Alembic and SQLAlchemy 2.0. It streamlines the process of initializing async-ready migration environments, autogenerating schema changes, and implementing complex database operations like zero-downtime concurrent indexing and multi-phase column updates. It is essential for developers building FastAPI or other async services who need to maintain production-ready database versioning, safe deployment workflows, and robust data integrity.
주요 기능
0169 GitHub stars
02Asyncpg integration for SQLAlchemy 2.0
03Automated migration generation and standardized rollback patterns
04Zero-downtime schema migrations with Concurrent Indexes
05Advanced async env.py configuration for production environments
06Multi-phase column updates and safe data backfilling
사용 사례
01Setting up an async-ready database migration system for a FastAPI project
02Managing complex database version history and rollbacks in high-traffic applications
03Performing safe schema updates on large production tables without locking or downtime
