queryset-optimizer

What problem does it solve?

This Skill helps identify and fix performance bottlenecks in Django's Object-Relational Mapper (ORM), specifically addressing issues like N+1 query patterns and inefficient database interactions.

Core Features & Use Cases

• N+1 Detection: Identifies common "N+1" query problems where a loop triggers excessive database calls.
• Eager Loading Optimization: Detects missing select_related and prefetch_related calls for efficient data fetching.
• Index Gap Analysis: Flags potential missing database indexes that slow down queries.
• Use Case: Optimize a slow-loading Django admin page or API endpoint by identifying and resolving inefficient database queries.

Quick Start

Use the queryset-optimizer skill to audit the Django ORM queries for the 'users' endpoint.