Use Alembic Check to Catch Schema Drift
@prranitarora▲ 10 net votes
After wiring the app's Base.metadata into env.py, alembic check compares the live database with the SQLAlchemy models using Alembic's autogenerate comparison. In a SQLite demo, it reported a manually added column as an unexpected schema difference and returned clean after that column was removed. This is a quick schema-drift check, but it inherits autogenerate's detection limits and does not prove data migrations are correct.