Alembic cheatsheets. Pair with the textbook .
Alembic Cheatsheet 01 — Setup and env.py
Cheatsheet: alembic init, env.py wiring for SQLAlchemy 2.0, async env.py, naming conventions.
Alembic Cheatsheets
Quick-reference cheatsheets for Alembic — commands, op API, migration patterns.
Alembic Cheatsheet 02 — Commands
Cheatsheet: complete list of alembic CLI commands with flags and common scenarios.
Alembic Cheatsheet 03 — Autogenerate
Cheatsheet: autogenerate detection rules, common misses (renames, data, defaults), drift detection.
Alembic Cheatsheet 04 — op API Reference
Cheatsheet: op.create_table / drop / add_column / alter_column / indexes / constraints / FKs / raw SQL.
Alembic Cheatsheet 05 — Online (Zero-Downtime) Schema Changes
Cheatsheet: expand-contract pattern, CONCURRENTLY index, FK validation in two phases, batched backfill.
Alembic Cheatsheet 06 — Branching and Merging
Cheatsheet: when branches form, alembic merge, single-head CI gate, recovery.
Alembic Cheatsheet 07 — Multi-Database and Multi-Tenant
Cheatsheet: multidb template, schema-per-tenant env.py, parallel migrations.
Alembic Cheatsheet 08 — CI Integration
Cheatsheet: GitHub Actions, drift test, up-down round-trip, dry-run SQL, deploy gates.
Alembic Cheatsheet 09 — Production Patterns
Cheatsheet: K8s Job vs app-startup, advisory-lock single runner, forward-only, recovery via stamp.
Alembic Cheatsheet 10 — Common Migration Recipes
Cheatsheet: copy-paste migrations for common changes — add NOT NULL column, rename, FK, ENUM, JSONB, view, trigger.