sqlalchemy-code-review

What problem does it solve?

This Skill helps reviewers identify common SQLAlchemy pitfalls around session lifecycle, relationships, and migrations, reducing bugs and lowering review time.

Core Features & Use Cases

• Session lifecycle, context managers, async sessions: Ensures correct usage patterns across codebases.
• relationship() usage, lazy loading, N+1 queries: Guides efficient data loading and relationships.
• select() vs query(), ORM overhead, bulk operations: Encourages modern SQLAlchemy 2.0 patterns.
• Alembic migration patterns, reversibility: Checks upgrade/downgrade correctness and ordering.

Quick Start

Use the sqlalchemy-code-review skill to review a codebase's SQLAlchemy usage for sessions, relationships, and migrations; refer to the references for anti-patterns and best practices.