What problem does it solve?
The Alembic-migration skill enforces that the source of truth for schema evolution is the combination of ORM models and Alembic migrations, preventing ad-hoc changes to the frozen migrations/db.sql baseline.
Core Features & Use Cases
- Enforces a strict workflow: modify src/models/**.py, generate a new migration under migrations/versions, validate the upgrade/downgrade paths, and keep documentation in sync.
- Prevents drift between ORM definitions, migrations, and database DDL by requiring doc synchronization in docs/api/schemas/mysql.md.
- Use Case: When adding a field to a model, update the ORM, generate a matching Alembic migration, verify it, and update the docs to reflect the new schema, all through the defined pipeline.
Quick Start
Update the ORM model, generate and review the migration, then run the validation and doc synchronization steps.