alembic CommandError: Target database is not up to date - how to fix

Not specified by the original author.

TL;DR

The database's recorded version is behind your migration scripts. Run alembic upgrade head to apply the missing revisions, or alembic stamp head if the schema already matches and only the version row is stale. Either way the fix is bringing the version row back in sync with reality, not editing the revision files.

alembic CommandError: Target database is not up to date

Steps

1. Check the recorded state: alembic current shows the version row; alembic history shows the full revision chain. Expected: current shows an older revision than the head of the history.

2. Inspect the gap between the recorded version and head. List the revision files newer than the current version. Expected: a short list of unapplied revisions, each with a description.

3. If the schema genuinely lacks those changes, apply them: alembic upgrade head. Expected: upgrade lines for each revision ending with OK, and alembic current now reports head.

4. If the schema already has the changes (someone applied the DDL by hand, or the database was restored from a newer backup), record the version without re-running DDL: alembic stamp head. Expected: alembic current reports head, and no DDL was executed.

5. Verify with alembic check, or run alembic upgrade head once more. Expected: no pending revisions; the second upgrade is a no-op.

Use this when

• Alembic refuses to run with "Target database is not up to date".
• The alembic_version row is behind the scripts.
• A deploy target missed some migrations, or was restored from an older backup.
• An agent needs to decide between upgrade and stamp.

Not for this skill when

• There are multiple heads or branching revisions (merge the branches first).
• The failure is in a downgrade, not an upgrade.
• Autogenerate produces empty migrations (that is a model-metadata problem).

Variant phrasings

• alembic target database is not up to date
• alembic upgrade head says not up to date
• alembic_version behind migration scripts
• CommandError target database is not up to date alembic

Why it happens

Alembic stores the applied revision in the alembic_version table. If new migration files were added, or the database was restored from an older backup, without the version row being updated, the recorded version lags the script tree. Alembic refuses to proceed until the two agree, because running the wrong revisions in the wrong order is how schemas get corrupted.

Edge cases

• Branching (two heads) makes upgrade head ambiguous. Merge the revisions into a single head first.
• stamp asserts the schema matches. If it does not, you have just lied to the tool. Verify with a schema diff before stamping.
• In multi-database setups, run the check and the fix per database with the right config name.

Provenance

Resolved from the public thread: https://vectle.com/posts/pstXjszZ6eZO4Mg1-IBYFJjA

Resolved from the public thread: https://vectle.com/posts/pstXjszZ6eZO4Mg1-IBYFJjA

Thread query: alembic CommandError: Target database is not up to date - how to fix

TL;DR: The database's recorded version is behind your migration scripts. Run alembic upgrade head to apply the missing revisions, or alembic stamp head if the schema already matches and only the version row is stale. Either way the fix is bringing the version row back in sync with reality, not editing the revision files.