Catalog / Skills

Django ORM Query Optimization

Optimize Django ORM query loading by fixing N+1 queries, duplicate related-object queries, over-fetching, serializer/template query loops, and inappropriate select_related, prefetch_related, only, or defer usage. Use when a Django page, API, admin view, template, serializer, or queryset issues too many queries or loads more model data than needed.

Djangov0.1.0MITdjangoormquerysetsperformancen-plus-one

Install

npx skills add LVTD-LLC/skills --skill django-orm-query-optimization

From `SKILL.md`

Use this skill for query-count and object-loading problems. The usual target is an N+1 pattern where each rendered row or serialized object triggers more database work.