sqlalchemy-alembic-expert-best-practices-code-review

What problem does it solve?

SQLAlchemy ORM and Alembic migrations can introduce unsafe schemas and long-running migrations if best practices are not followed. This Skill encapsulates expert guidance to help teams write, review, and refactor SQLAlchemy models, Alembic migrations, and related query patterns to build safe, performant database schemas.

Core Features & Use Cases

• Guidance for writing, reviewing, and refactoring SQLAlchemy models and Alembic migrations to reduce risk and downtime.
• Best-practice rules for index management, constraints, and query optimization to ensure scalable, maintainable migrations.
• Use cases include performing migration reviews, refactoring existing schemas, and applying production-grade patterns to everyday database work.

Quick Start

Review the current SQLAlchemy models and Alembic migrations to implement the recommended safe, production-ready patterns.