sqlalchemy/alembic

View on GitHub

A database migrations tool for SQLAlchemy.

Stars: 4.4k
Forks: 375
Open beginner issues: 0
Indexed issues: 105

Dominant language: Python
License: MIT
Last GitHub push: Sep 18, 2026
Latest indexed: Sep 19, 2026
Contributing guide: Contributing guide
Code of conduct: Code of conduct
Beginner labels: No beginner labels indexed
PR merge metrics: No merged PRs in 30d

Beginner friendly Everything

Open All

105 open issues indexed

Autogenerate produces no migration when a Computed column expression changes (PostgreSQL) Open

autogenerate - defaults missing behavior postgresql

Difficulty 4/5 3-5 days Newbie friendliness 48/100

sqlalchemy/alembic#1837 · 10 comments · Opened Jul 24, 2026
add option to re-apply naming conventions for table renamed in batch mode Open

batch migrations feature great mcve naming convention issues sqlite

Difficulty 5/5 Over a week Newbie friendliness 45/100

sqlalchemy/alembic#1834 · 1 comment · Opened Jul 16, 2026
Adding a pseudo MigrationOp to add autocommit context wrapper to generated revision Open

autogenerate - rendering execution model use case

Difficulty 4/5 3-5 days Newbie friendliness 48/100

sqlalchemy/alembic#1825 · 1 comment · Opened Jul 2, 2026
Proposal: First‑class Alembic support for Views (incl. Materialized) + Routines for ETL/PostGIS Open

use case

Difficulty 5/5 Over a week Newbie friendliness 30/100

sqlalchemy/alembic#1797 · 2 comments · Opened Feb 26, 2026
add rev_id generator function feature to environment.configure(), will apply to revision, merge Open

awaiting info use case

Difficulty 2/5 1-3 hours Newbie friendliness 55/100

sqlalchemy/alembic#1732 · 4 comments · Opened Oct 3, 2025
Create primary key / unique constraint does not support `postgresql_include` added in sqlalchemy 2.0.41 Open

op directives postgresql use case

Difficulty 3/5 1-2 days Newbie friendliness 38/100

sqlalchemy/alembic#1723 · Opened Sep 4, 2025
should change of type + change of server default be heuristically orchestrated for incompatible server default types? Open

op directives postgresql use case

Difficulty 4/5 3-5 days Newbie friendliness 35/100

sqlalchemy/alembic#1652 · 2 comments · Opened Apr 25, 2025
Unexpected warning for computed column when migrating with MariaDB Open

autogenerate - detection mysql

Difficulty 3/5 1-2 days Newbie friendliness 45/100

sqlalchemy/alembic#1607 · 5 comments · Opened Feb 11, 2025
postgresql serial column detection might fail Open

bug postgresql

Difficulty 3/5 1-2 days Newbie friendliness 48/100

sqlalchemy/alembic#1565 · 3 comments · Opened Nov 1, 2024
Add support for preserving field order? Open

mysql op directives use case

Difficulty 5/5 Over a week Newbie friendliness 35/100

sqlalchemy/alembic#1539 · 5 comments · Opened Sep 20, 2024
Migration autogeneration should respect schemas defined using quoted_name Open

autogenerate - rendering bug code review in progress

Difficulty 3/5 1-2 days Newbie friendliness 48/100

sqlalchemy/alembic#1526 · Opened Aug 30, 2024
conditional ddl support; add autogeneration support for `ddf_if()` Open

autogenerate - detection autogenerate - rendering

Difficulty 4/5 3-5 days Newbie friendliness 42/100

sqlalchemy/alembic#1491 · 12 comments · 5 reactions · Opened Jun 19, 2024
Improve server_default / existing_server_default typing Open

bug pep 484

Difficulty 2/5 1-3 hours Newbie friendliness 42/100

sqlalchemy/alembic#1468 · 2 comments · 4 reactions · Opened Apr 30, 2024
Consider Removing psql type specifiers when Comparing Computed Constructs Open

bug postgresql

Difficulty 1/5 Under an hour Newbie friendliness 45/100

sqlalchemy/alembic#1462 · 1 comment · Opened Apr 23, 2024
autogenerate with compare_server_default=True and reflecting table randomly fails to set conn_col_default Open

autogenerate - detection postgresql

Difficulty 4/5 3-5 days Newbie friendliness 35/100

sqlalchemy/alembic#1454 · 2 comments · Opened Apr 6, 2024
'BatchOperations' object has no attribute 'rename_table' Open

batch migrations bug documentation

Difficulty 3/5 1-2 days Newbie friendliness 35/100

sqlalchemy/alembic#1453 · 2 comments · Opened Apr 5, 2024
Change the default `include_schemas` to be `"from_metadata"` Open

Difficulty 4/5 3-5 days Newbie friendliness 38/100

sqlalchemy/alembic#1428 · 1 reaction · Opened Feb 17, 2024
Naming conventions in metadata sequences are ignored Open

autogenerate - rendering bug op directives

Difficulty 3/5 1-2 days Newbie friendliness 45/100

sqlalchemy/alembic#1396 · 4 comments · Opened Jan 11, 2024
Alembic always detects changes on indexes that use to_tsvector() Open

autogenerate - detection bug index expressions postgresql

Difficulty 4/5 3-5 days Newbie friendliness 35/100

sqlalchemy/alembic#1390 · 6 comments · 1 reaction · Opened Jan 9, 2024
Autogenerate renders TypeDecorator instance instead of underlying impl type Open

autogenerate - rendering cookbook requested documentation typedecorator use case

Difficulty 3/5 1-2 days Newbie friendliness 66/100

sqlalchemy/alembic#1386 · 10 comments · 11 reactions · Opened Jan 5, 2024
Rendering postgresql dialect DOMAIN field Open

autogenerate - rendering bug open for pull requests postgresql

Difficulty 4/5 3-5 days Newbie friendliness 35/100

sqlalchemy/alembic#1360 · 1 comment · Opened Nov 16, 2023
autogenerate postgresql DOMAIN type column Open

autogenerate - detection bug open for pull requests postgresql

Difficulty 4/5 3-5 days Newbie friendliness 35/100

sqlalchemy/alembic#1357 · 2 comments · Opened Nov 16, 2023
Autogenerate migration still has minor typing issues with mypy Open

bug open for pull requests pep 484

Difficulty 2/5 1-3 hours Newbie friendliness 74/100

sqlalchemy/alembic#1341 · 2 comments · Opened Nov 1, 2023
git does not commit "versions" by default, so we should possibly ensure some file is present there Open

migration environment use case

Difficulty 3/5 1-2 days Newbie friendliness 38/100

sqlalchemy/alembic#1320 · 6 comments · Opened Oct 11, 2023
enum already exists Open

autogenerate for enums awaiting info expected behavior postgresql

Difficulty 4/5 3-5 days Newbie friendliness 35/100

sqlalchemy/alembic#1254 · 25 comments · 13 reactions · Opened May 29, 2023
Support sorting and expression index reflection on oracle Open

autogenerate - detection index expressions oracle use case

Difficulty 4/5 3-5 days Newbie friendliness 35/100

sqlalchemy/alembic#1238 · Opened May 9, 2023
Handle AUTOINCREMENT modification detection in revision auto-generation Open

autogenerate - detection autogenerate - rendering mysql use case

Difficulty 4/5 3-5 days Newbie friendliness 35/100

sqlalchemy/alembic#1224 · 1 comment · Opened Apr 20, 2023
better way to look at the more recent revision from `alembic history` output Open

command interface open for pull requests use case

Difficulty 4/5 3-5 days Newbie friendliness 35/100

sqlalchemy/alembic#1222 · 9 comments · 6 reactions · Opened Apr 19, 2023
Running `alter table` revisions w/batch operations on SQLite raises an error if table referenced in a view Open

batch migrations code review in progress documentation sqlite

Difficulty 4/5 3-5 days Newbie friendliness 42/100

sqlalchemy/alembic#1207 · 7 comments · Opened Mar 20, 2023
private constructor elements on CreateTableOp make it impossible to copy w/ public API Open

bug op directives

Difficulty 4/5 3-5 days Newbie friendliness 35/100

sqlalchemy/alembic#1193 · Opened Mar 6, 2023
Consider Removing New Line Characters when Comparing Computed Constructs Open

autogenerate - detection bug open for pull requests

Difficulty 2/5 1-3 hours Newbie friendliness 74/100

sqlalchemy/alembic#1121 · 3 comments · Opened Nov 18, 2022
Augmented (TypeDecorator) JSON type results in data loss during SQLite migration Open

batch migrations bug typedecorator

Difficulty 4/5 3-5 days Newbie friendliness 45/100

sqlalchemy/alembic#1120 · 1 comment · Opened Nov 15, 2022
alembic autogeneration "false-positively" detects change to comments from the empty string to None Open

bug low priority

Difficulty 3/5 1-2 days Newbie friendliness 68/100

sqlalchemy/alembic#1085 · 2 comments · Opened Sep 7, 2022
implement detection of collation changes on a column Open

autogenerate - detection use case

Difficulty 4/5 3-5 days Newbie friendliness 45/100

sqlalchemy/alembic#1041 · 4 comments · Opened May 26, 2022
support sqlite date casts in batch mode under sqlite.cast_for_batch_migrate, or at least a hook Open

batch migrations sqlite use case

Difficulty 4/5 3-5 days Newbie friendliness 35/100

sqlalchemy/alembic#1033 · 3 comments · 1 reaction · Opened May 8, 2022
implement autogen for PK constraints Open

autogenerate - detection use case

sqlalchemy/alembic#993 · 5 comments · 1 reaction · 1 assignee · Opened Feb 25, 2022
Autogenerate does not use of postgresql_using when changing a type to UUID Open

autogenerate - rendering cookbook requested postgresql use case

Difficulty 4/5 3-5 days Newbie friendliness 38/100

sqlalchemy/alembic#963 · 12 comments · Opened Nov 10, 2021
postgres ExcludeConstraint not generating correctly Open

autogenerate - rendering bug postgresql

Difficulty 3/5 1-2 days Newbie friendliness 45/100

sqlalchemy/alembic#958 · 2 comments · Opened Oct 26, 2021
Add support for temporal table migrations (`WITH SYSTEM VERSIONING`) Open

op directives use case

Difficulty 5/5 Over a week Newbie friendliness 30/100

sqlalchemy/alembic#956 · 3 comments · Opened Oct 21, 2021
create alembic recipe for FKs that conditionally generate Open

cookbook requested documentation use case

Difficulty 2/5 1-3 hours Newbie friendliness 35/100

sqlalchemy/alembic#937 · Opened Sep 28, 2021
`alembic.config.Config('nonexisting.ini')` doesn't fail Open

expected behavior

Difficulty 3/5 1-2 days Newbie friendliness 35/100

sqlalchemy/alembic#931 · 5 comments · Opened Sep 24, 2021
Alembic Batch Operations and Partial Ordering Bug Open

awaiting info batch migrations question

Difficulty 4/5 3-5 days Newbie friendliness 42/100

sqlalchemy/alembic#923 · 1 comment · Opened Sep 17, 2021
Example change for branched connection still doesn't work Open

bug documentation

Difficulty 2/5 1-3 hours Newbie friendliness 35/100

sqlalchemy/alembic#922 · 3 comments · Opened Sep 17, 2021
Wrong order when renaming foreign keys Open

autogenerate - rendering bug mysql

Difficulty 3/5 1-2 days Newbie friendliness 30/100

sqlalchemy/alembic#902 · 6 comments · Opened Sep 6, 2021
Autogenerate does not consider schema for enum type Open

autogenerate for enums bug missing behavior

Difficulty 4/5 3-5 days Newbie friendliness 42/100

sqlalchemy/alembic#899 · 24 comments · 5 reactions · Opened Sep 6, 2021
Migration downgrade doesn't drop type created by Enum Open

autogenerate for enums bug

Difficulty 3/5 1-2 days Newbie friendliness 48/100

sqlalchemy/alembic#886 · 15 comments · 33 reactions · Opened Aug 19, 2021
ENUM with metadata is not translated to sql CREATE TYPE in autogenerate Open

autogenerate for enums duplicate question

Difficulty 4/5 3-5 days Newbie friendliness 48/100

sqlalchemy/alembic#868 · 1 comment · 3 reactions · Opened Jun 24, 2021
Add links to github to every page of docs Open

documentation

Difficulty 2/5 1-3 hours Newbie friendliness 35/100

sqlalchemy/alembic#833 · 2 comments · Opened Apr 27, 2021
new hook: compare_identity_default Open

autogenerate - detection use case

Difficulty 4/5 3-5 days Newbie friendliness 35/100

sqlalchemy/alembic#821 · 4 comments · Opened Mar 29, 2021
Autogenerate cannot detect partial indexes (with postgresql_where) on postgres Open

autogenerate - detection postgresql use case

Difficulty 4/5 3-5 days Newbie friendliness 38/100

sqlalchemy/alembic#750 · 5 comments · 1 reaction · Opened Oct 27, 2020

sqlalchemy/alembic

Get new issues in your inbox