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 |

Patrones de migración de alambique para SQLAlchemy 2.0 asíncrono. Úselo al crear migraciones de bases de datos, administrar versiones de esquemas, manejar implementaciones sin tiempo de inactividad o implementar cambios reversibles en la base de datos. Fuente: yonatangross/orchestkit.

Ver original