N+1 Query Detection

What problem does it solve?

This Skill identifies and helps resolve performance bottlenecks caused by N+1 query patterns in GORM database interactions, preventing slow application performance.

Core Features & Use Cases

• N+1 Pattern Detection: Automatically scans repository and service code for common N+1 query anti-patterns.
• Preload & Unbounded Query Analysis: Verifies the correct use of Preload or Joins and flags queries without Limit.
• Severity Assessment & Fix Recommendations: Provides severity ratings and suggests specific GORM patterns for optimization.
• Use Case: Ensure your application's data retrieval is efficient by automatically flagging and suggesting fixes for inefficient database queries before they impact users.

Quick Start

Run the N+1 Query Detection skill on the repository and service files to identify performance issues.