Does it report every potential performance issue?

No, it follows a strict validation protocol to only report high-impact issues it can prove. Low-impact patterns or micro-optimizations are ignored to focus on critical and high-priority fixes.

How does this skill identify N+1 queries?

The skill traces the data flow from views and serializers into templates or loops, checking if related fields are accessed without the necessary select_related or prefetch_related optimizations.

Does it suggest adding indexes automatically?

It identifies fields used in WHERE or ORDER BY clauses on large tables that lack a db_index or Meta index, providing a validated recommendation for high-impact tables.

Is it compatible with Django Rest Framework (DRF)?

Yes, it specifically checks for DRF-specific performance traps, such as SerializerMethodField queries and unoptimized querysets in ViewSets.

What does the skill consider a 'Critical' issue?

Issues like N+1 queries and unbounded querysets are categorized as CRITICAL because they scale poorly with data volume and frequently lead to timeouts or OOM (Out Of Memory) crashes.

Django Performance Review

Name: Django Performance Review
Author: getsentry

bygetsentry

•

261

•

データベース管理

Analyzes and validates Django code to identify high-impact performance bottlenecks like N+1 queries, unbounded querysets, and missing database indexes.

The django-perf-review skill serves as an expert performance auditor for Django applications, focusing on identifying issues that cause real-world production failures. It systematically investigates codebases to find and validate critical problems such as N+1 query patterns in views and serializers, memory-heavy unbounded querysets, and inefficient write loops. Unlike standard linting, this skill emphasizes a research-first approach, requiring evidence and data-flow tracing to ensure that every reported finding is actionable and impactful for scaling applications.

主な機能

01261 GitHub stars

02Provides evidence-based reporting with specific file locations and validated fix suggestions

03Identifies and validates N+1 query patterns in Django views and DRF serializers

04Pinpoints missing database indexes for high-traffic filtering and sorting operations

05Optimizes inefficient write loops by suggesting bulk_create and bulk_update patterns

06Detects unbounded querysets that risk memory exhaustion and OOM errors

ユースケース

01Optimizing slow API endpoints or debugging database timeouts in DRF projects

02Auditing a Django application for scalability before a major production release

03Refactoring legacy Django codebases to improve resource efficiency and request speed

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add getsentry/skills django-perf-review

For use in Claude.ai and ChatGPT

Download Skill