alembic-autogenerate-enums
Alembic hook that allows enums values to be upgraded and downgraded in migrations automatically
Decision gist · record as of 2026-08-14
No, not recommended. The package is abandoned with no updates in over a year and has no documented compatibility with current Alembic or PostgreSQL versions. For active projects, the maintenance risk outweighs the convenience of enum autogeneration. Consider manual enum migrations or evaluating whether a maintained alternative exists before adopting this.AI-flagged interpretation of the facts on this page — verify before relying
Before you install
- Requires PostgreSQL database and an existing Alembic project; the package assumes you are already using Alembic for schema management.
- Low install friction with no runtime dependencies.
- However, the package is abandoned—last release was 1122 days ago with no recent maintenance signal, which raises questions about compatibility with current Alembic and PostgreSQL versions.
License · maintenance · safety
MIT (permissive) — MIT license permits commercial and private use with minimal restrictions, requiring only attribution and inclusion of the license text.
last release 2023-07-19 (1122 days)
0 known vulnerabilities (OSV.dev, 2026-08-14) · 155,677 downloads/mo, #10,804 on PyPI
Alternatives
Verify before relying
# In your alembic/env.py, add at the top:
import alembic_autogenerate_enums
# Then run migrations normally:
# alembic revision --autogenerate -m "Add enum values"
# alembic upgrade head- Compatibility with current Alembic versions and PostgreSQL enum handling behavior
- Whether the non-transactional connection workaround still aligns with modern Alembic patterns
- Test coverage and real-world usage reliability given the abandoned maintenance status
What it is and what it does
This package hooks into Alembic's autogenerate mechanism to automatically detect when PostgreSQL enum types have new values added to your models, then generates the corresponding ALTER TYPE .. ADD VALUE SQL statements in your migration files. Without this hook, Alembic's default autogenerate ignores enum value changes, requiring manual migration writing.
The package works by registering itself when imported into your env.py file. It handles a PostgreSQL constraint: ALTER TYPE statements cannot run inside transactions, so each enum sync operation opens its own temporary database connection. This is a thin, specialized tool for teams using Alembic with PostgreSQL enums who want migrations to stay in sync with model changes automatically.
Use it for
- Automatically generate migrations when adding new values to existing PostgreSQL enum types in your SQLAlchemy models.
- Avoid manual ALTER TYPE SQL writing by letting Alembic detect enum changes during autogenerate.
- Ensure enum migrations are tracked in version control alongside other schema changes in a PostgreSQL project.
Worth the install?
AI-flagged interpretation of the facts on this page. Verify before relying on it.
No, not recommended.
The package is abandoned with no updates in over a year and has no documented compatibility with current Alembic or PostgreSQL versions. For active projects, the maintenance risk outweighs the convenience of enum autogeneration. Consider manual enum migrations or evaluating whether a maintained alternative exists before adopting this.
Install
alembic-autogenerate-enums on PyPI
Before you install
Low install friction with no runtime dependencies. However, the package is abandoned—last release was 1122 days ago with no recent maintenance signal, which raises questions about compatibility with current Alembic and PostgreSQL versions.
Requires PostgreSQL database and an existing Alembic project; the package assumes you are already using Alembic for schema management.
License in practice
MIT license permits commercial and private use with minimal restrictions, requiring only attribution and inclusion of the license text.
Quickstart
# In your alembic/env.py, add at the top:
import alembic_autogenerate_enums
# Then run migrations normally:
# alembic revision --autogenerate -m "Add enum values"
# alembic upgrade headVerify before relying
- Compatibility with current Alembic versions and PostgreSQL enum handling behavior
- Whether the non-transactional connection workaround still aligns with modern Alembic patterns
- Test coverage and real-world usage reliability given the abandoned maintenance status
Package facts
| License | MIT permissive |
| Python support | Supports the current Python release >=3.7,<4.0 |
| Install friction | Low. Pure-Python wheel |
| Runtime dependencies | None |
| Maintenance | Abandoned 1,122 days since the last release |
| First released | |
| Downloads | 155,677 / month, #10,804 on PyPI 30-day window, as of 2026-08-14 |
| Known vulnerabilities | None known OSV.dev, checked 2026-08-14 |
| Classifiers | License :: OSI Approved :: MIT LicenseProgramming Language :: Python :: 3Programming Language :: Python :: 3.10Programming Language :: Python :: 3.7Programming Language :: Python :: 3.8Programming Language :: Python :: 3.9 |
Evidence: alembic_autogenerate_enums-0.1.2-py3-none-any.whl
Tags
Let your AI agent find packages like this
Example. Real query, live index.
You found this page by searching. An agent finds it by wishing: SkillFed indexes 14,416 PyPI packages by what they can do, searchable in plain language.
wish › “alembic enum migration”
- alembic-autogenerate-enumsExtends Alembic's autogenerate to detect and emit PostgreSQL enum…
- alembic-postgresql-enumExtends Alembic to automatically detect and manage PostgreSQL enum…
- alembic_utilsExtends Alembic to autogenerate database migrations for PostgreSQL…
Give your agent the search over MCP, or paste the wish link into any chat.
More Database packages
psycopg2-binary is a PostgreSQL database adapter for Python that implements the DB API 2.0 specification, enabling Python applications to connect to and query PostgreSQL databases with thread-safe concurrent operations.
Python client library for connecting to and executing commands against Redis key-value stores, supporting both synchronous and asynchronous operations.
Install it if your application needs to interact with Redis; the only prerequisite is a running Redis server instance.
YDB Python SDK is the official client library for connecting to and querying YDB databases from Python applications.
Install it if you need to connect Python applications to YDB databases.
Connects Python applications to Snowflake data warehouses using the DB API 2.0 specification, enabling SQL queries, data transfers, and warehouse operations.
sqlparse tokenizes SQL text into a tree of statements, clauses, and expressions, and provides functions to split scripts, format queries, and inspect parsed tokens without validating dialect or syntax.
Install it if you need to manipulate, format, or analyze SQL text programmatically.
Provides base adapter protocols and shared functionality that database adapters use to integrate with dbt-core, handling connections, dialect translation, relation caching, and core interface management.
See also alembic-postgresql-enum · alembic_utils · alembic · Flask-Alembic · pytest-alembic · migra · Flask-Migrate · django-pg-zero-downtime-migrations · django-postgres-extra · pglast