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

•

Database Management

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.

Key Features

01SQLAlchemy 2.0 select() syntax validation

02Session lifecycle and context manager auditing

03N+1 query detection and relationship loading optimization

04Bulk operation pattern verification

0514 GitHub stars

06Alembic migration reversibility and safety checks

Use Cases

01Refactoring legacy ORM code to modern SQLAlchemy 2.0 standards

02Auditing database performance during code reviews to prevent inefficient loading

03Verifying that Alembic migrations follow best practices for data integrity

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add existential-birds/beagle sqlalchemy-code-review

For use in Claude.ai and ChatGPT

Download Skill