Sqlalchemy Code Review

The sqlalchemy-code-review skill enables AI agents to analyze SQLAlchemy ORM code for best practices, security vulnerabilities, and performance issues. It specifically inspects model definitions, session management patterns, and query construction within Python applications.

When to use it

• Before merging pull requests containing new database models or migration scripts.
• When refactoring legacy codebases that rely on raw SQL or inefficient ORM queries.
• To audit existing projects for common pitfalls like N+1 query problems or unhandled session commits.
• During code reviews to ensure consistent adherence to SQLAlchemy design patterns across a team.

Key capabilities

• Identifies unsafe raw SQL usage within ORM contexts.
• Flags potential performance bottlenecks in complex queries.
• Reviews model relationships and foreign key configurations for correctness.
• Checks session lifecycle management for proper commit/rollback handling.

Example prompts

"Review this SQLAlchemy model definition for security risks and suggest improvements." "Analyze the following query for N+1 issues and propose optimized alternatives." "Check this code snippet for improper session usage that could lead to data loss."

Tips & gotchas

This skill focuses specifically on SQLAlchemy syntax and patterns; it may not catch logic errors unrelated to database interactions. Ensure your AI agent has access to the full project context, including schema definitions, for accurate analysis of cross-file dependencies.