SQLAlchemy & Alembic Expert Best Practices

Simple, pragmatic, opinionated. Only what matters for writing production-grade SQLAlchemy and Alembic code.

When to Apply

Reference these guidelines when:

• Writing Alembic migrations for schema changes
• Creating or modifying SQLAlchemy models
• Adding indexes, constraints, or foreign keys via Alembic
• Reviewing database migration code for safety
• Refactoring existing database schemas
• Optimizing query patterns or database performance

Rule Categories by Priority