alembic-postgresql-enum

What it is and what it does

This package hooks into Alembic's autogenerate process to detect when enums are created, modified, or removed from your SQLAlchemy models, then generates migration code to keep your PostgreSQL schema in sync. When you import the package in your migrations/env.py file, it registers custom comparators that watch for enum changes. If you add a new enum column to a model, Alembic will generate migration code that creates the enum type in PostgreSQL before creating the column. If you remove an enum column, the migration will drop the unused enum. If enum values change, the migration generates sync operations to update the type definition.

The package automates enum creation, removal, addition and deletion of enum values, reordering of enum values, and deletion of unused enums from schema. Enum value renaming requires manual migration editing.

Use it for

• Automatically generate migrations when adding a new PostgreSQL enum column to an existing table
• Track and apply enum value additions or deletions across your codebase without manual SQL
• Clean up unused enum types from PostgreSQL when they are removed from your models
• Maintain consistency between SQLAlchemy enum definitions and the PostgreSQL schema during team development
• Avoid manual enum creation and deletion SQL in migration files by letting autogenerate handle it

Worth the install?

AI-flagged interpretation of the facts on this page. Verify before relying on it.

Install

alembic-postgresql-enum on PyPI

Before you install

Low friction install with only 2 runtime dependencies (alembic and sqlalchemy). Repository is active with recent commits and no known vulnerabilities. Supports Python 3.7 through 3.14.

Requires an existing Alembic project with SQLAlchemy models using postgresql.ENUM columns; PostgreSQL database backend.

License in practice

MIT license is permissive and places no restrictions on use, modification, or distribution in commercial or private projects.

Quickstart

pip install alembic-postgresql-enum

# In migrations/env.py, add at the top:
import alembic_postgresql_enum

# Then run:
alembic revision --autogenerate

Package facts

Evidence: alembic_postgresql_enum-1.10.0-py3-none-any.whl

Tags

More Database packages

See also alembic-autogenerate-enums · pytest-alembic · alembic_utils · alembic · migra · django-pg-zero-downtime-migrations · Flask-Alembic · Flask-Migrate · django-postgres-extra · omnibase-compat