alembic-migrations

SKILL.md

Database migration management with Alembic for SQLAlchemy 2.0 async applications.

| Async dialect | Use postgresql+asyncpg | Native async support | | NOT NULL column | Two-phase: nullable first, then alter | Avoids locking, backward compatible | | Large table index | CREATE INDEX CONCURRENTLY | Zero-downtime, no table locks | | Column rename | 4-phase expand/contract | Safe migration without downtime |

| Autogenerate review | Always review generated SQL | May miss custom constraints | | Migration granularity | One logical change per file | Easier rollback and debugging | | Production deployment | Generate SQL, review, then apply | Never auto-run in production | | Downgrade function | Always implement properly | Ensures reversibility |

Alembic migration patterns for SQLAlchemy 2.0 async. Use when creating database migrations, managing schema versions, handling zero-downtime deployments, or implementing reversible database changes. Source: yonatangross/orchestkit.

View raw