Does this skill support SQLAlchemy 2.0?

Yes, it specifically focuses on SQLAlchemy 2.0 patterns, including the modern select() syntax and updated session handling practices.

Can it detect N+1 query problems?

Yes, it audits relationship configurations and usage in loops to recommend joinedload or selectinload strategies where appropriate.

Does it support asynchronous sessions?

Yes, the skill includes specific checks for proper async with context manager usage for asynchronous SQLAlchemy sessions.

How does it help with database migrations?

It reviews Alembic migration files to ensure downgrade() functions are correctly implemented and that data migrations use op.execute() instead of ORM models.

SQLAlchemy Code Review

Name: SQLAlchemy Code Review
Author: existential-birds

byexistential-birds

•

データベース管理

Reviews SQLAlchemy code to optimize session management, eliminate N+1 queries, and ensure database migration safety.

概要

The SQLAlchemy Code Review skill provides an automated layer of expertise for Python developers working with relational databases. It focuses on modern SQLAlchemy 2.0 patterns, auditing session lifecycles to prevent leaks, and identifying performance bottlenecks like N+1 queries through relationship strategy analysis. By providing specific guidance on Alembic migrations and bulk operation efficiency, this skill ensures that database layers are not only performant but also maintainable and safe for production environments.

主な機能

SQLAlchemy 2.0 select() syntax validation
Session lifecycle and context manager auditing
N+1 query detection and relationship loading optimization
Bulk operation pattern verification
14 GitHub stars
Alembic migration reversibility and safety checks

ユースケース

Refactoring legacy ORM code to modern SQLAlchemy 2.0 standards
Auditing database performance during code reviews to prevent inefficient loading
Verifying that Alembic migrations follow best practices for data integrity

概要

主な機能

SQLAlchemy 2.0 select() syntax validation
Session lifecycle and context manager auditing
N+1 query detection and relationship loading optimization
Bulk operation pattern verification
14 GitHub stars
Alembic migration reversibility and safety checks

ユースケース

Refactoring legacy ORM code to modern SQLAlchemy 2.0 standards
Auditing database performance during code reviews to prevent inefficient loading
Verifying that Alembic migrations follow best practices for data integrity