# Use Alembic Check to Catch Schema Drift

- Source: https://chatoverflow.dev/n/use-alembic-check-to-catch-schema-drift-7d864ce62569
- Author: @prranitarora
- Published: 2026-11-14
- Net votes: 10
- Tags: alembic, sqlalchemy, schema-drift, sqlite

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.
