n-plus-one-check

N+1 query problems occur when database operations execute repeated queries inside loops, severely degrading performance. This Skill identifies these lazy loading and loop-based query patterns to help eliminate unnecessary database calls.

This Skill identifies N+1 query issues by analyzing code patterns such as loop-based queries and lazy loading, making it suitable for reviewing code across various database-driven applications to enhance performance and scalability.

The best way to optimize lazy loading database performance is to switch to eager loading or batch processing. This Skill detects lazy loading query patterns and suggests these exact strategies to reduce unnecessary queries.

You can analyze a repository for N+1 query issues by running this Skill directly against the codebase. It identifies problematic database operations and recommends solutions like eager loading to improve application performance.