Detect N+1 query patterns and missing eager loading in Django ORM.
npx skills add https://github.com/ragnarok22/agent-skills --skill queryset-optimizer
Please help me install this Agent Skill. Skill: queryset-optimizer Source: https://github.com/ragnarok22/agent-skills/tree/main/skills/queryset-optimizer Command: npx skills add https://github.com/ragnarok22/agent-skills --skill queryset-optimizer
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.
select_related and prefetch_related calls for efficient data fetching.Use the queryset-optimizer skill to audit the Django ORM queries for the 'users' endpoint.
High-intent search queries and answers about installing and using this skill.
Resolve N+1 query patterns in Django ORM by detecting loop-triggered database calls and applying missing eager loading functions like select_related and prefetch_related for efficient data fetching.
Find missing select_related and prefetch_related calls by auditing your Django backend endpoints to receive a detailed report with a scoring system and prioritized remediation actions for inefficient queries.
Optimize a slow Django admin page or API endpoint by identifying inefficient database interactions, resolving N+1 query patterns, and flagging potential missing database indexes that slow down queries.
Detect missing database indexes slowing down Django queries through an index gap analysis that flags potential missing indexes and provides prioritized remediation actions for those inefficiencies.
Queryset optimization works for any Django backend development context by auditing ORM queries for specific endpoints, such as the users endpoint, to improve database interaction efficiency.
dpieterszSecure and optimize backend queries against SQL injection and N+1 problems.
wesleyegbertoAutomate Django project setup with DRF, JWT authentication, and indexed models.
Axel-DaMageAutomate Django models, serializers, viewsets, and JWT authentication configurations.
gemini-cli-extensionsFetch PromQL metrics, EXPLAIN plans, and active queries for Cloud SQL PostgreSQL.