PluginBench
Skill
Pass
Audit score 90

django-expert

jeffallan/claude-skills

Senior Django specialist for building optimized REST APIs, models, and production-grade web applications.

What is django-expert?

Expert guidance for Django 5.0 and Django REST Framework projects. Use when designing models, building DRF serializers and viewsets, optimizing ORM queries, or configuring authentication. Covers models with proper indexes, select_related/prefetch_related optimization, JWT authentication, and testing.

  • Creates Django models with proper relationships, fields, and database indexes
  • Optimizes ORM queries using select_related and prefetch_related to avoid N+1 problems
  • Builds DRF serializers with validation and viewsets with proper permissions
  • Configures JWT authentication and permission classes for API endpoints
  • Designs Django admin customization and query optimization strategies
  • Writes APITestCase tests for models and endpoints

How to install django-expert

npx skills add https://github.com/jeffallan/claude-skills --skill django-expert
Prerequisites
  • Django 5.0 or later installed
  • Django REST Framework package installed
  • Python 3.10 or later
  • Basic understanding of Django models and ORM
Claude Code
Cursor
Windsurf
Cline

How to use django-expert

  1. 1.Analyze your requirements and identify models, relationships, and API endpoints
  2. 2.Design models with proper fields, relationships, and database indexes using the models-orm reference
  3. 3.Run manage.py makemigrations and manage.py migrate to apply schema changes
  4. 4.Implement DRF serializers with validation using the drf-serializers reference
  5. 5.Create viewsets or async views with proper permissions using the viewsets-views reference
  6. 6.Configure JWT authentication and permission classes using the authentication reference
  7. 7.Write APITestCase tests for all endpoints using the testing-django reference
  8. 8.Validate endpoints return expected status codes before deploying

Use cases

Good for
  • Building a REST API with Django REST Framework and JWT authentication
  • Designing normalized database models with proper foreign keys and indexes
  • Optimizing slow queries by adding select_related and prefetch_related
  • Creating serializers with custom validation logic for API requests
  • Setting up role-based permissions on viewsets and endpoints
Who it's for
  • Backend developers building Django web applications
  • Full-stack engineers implementing REST APIs with DRF
  • DevOps/platform engineers optimizing Django application performance
  • Teams migrating to Django 5.0 or upgrading existing projects

django-expert FAQ

When should I use select_related vs prefetch_related?

Use select_related for single-object relationships (ForeignKey, OneToOneField) to fetch in one query. Use prefetch_related for reverse relationships and many-to-many to optimize with separate queries and Python-side joining.

How do I avoid N+1 query problems?

Always use select_related or prefetch_related in your get_queryset() method when accessing related objects. Check query counts in tests with assertNumQueries() to catch regressions.

What's the recommended way to handle authentication?

Use SimpleJWT for token-based authentication in REST APIs. Configure it in settings.py, add the authentication class to your viewsets, and use permission_classes like IsAuthenticated or IsAuthenticatedOrReadOnly.

Should I use raw SQL in Django?

Avoid raw SQL. Use Django ORM QuerySet methods instead. If raw SQL is necessary, always use parameterized queries with .raw() or .execute() to prevent SQL injection.

How do I test API endpoints?

Use rest_framework.test.APITestCase with setUp() for fixtures, force_authenticate() for auth, and assert on status codes and response data. Use assertNumQueries() to verify query optimization.

Full instructions (SKILL.md)

Source of truth, from jeffallan/claude-skills.


name: django-expert description: "Use when building Django web applications or REST APIs with Django REST Framework. Invoke when working with settings.py, models.py, manage.py, or any Django project file. Creates Django models with proper indexes, optimizes ORM queries using select_related/prefetch_related, builds DRF serializers and viewsets, and configures JWT authentication. Trigger terms: Django, DRF, Django REST Framework, Django ORM, Django model, serializer, viewset, Python web." license: MIT metadata: author: https://github.com/Jeffallan version: "1.1.0" domain: backend triggers: Django, DRF, Django REST Framework, Django ORM, Django model, serializer, viewset, Python web role: specialist scope: implementation output-format: code related-skills: fullstack-guardian, fastapi-expert, test-master

Django Expert

Senior Django specialist with deep expertise in Django 5.0, Django REST Framework, and production-grade web applications.

When to Use This Skill

  • Building Django web applications or REST APIs
  • Designing Django models with proper relationships
  • Implementing DRF serializers and viewsets
  • Optimizing Django ORM queries
  • Setting up authentication (JWT, session)
  • Django admin customization

Core Workflow

  1. Analyze requirements — Identify models, relationships, API endpoints
  2. Design models — Create models with proper fields, indexes, managers → run manage.py makemigrations and manage.py migrate; verify schema before proceeding
  3. Implement views — DRF viewsets or Django 5.0 async views
  4. Validate endpoints — Confirm each endpoint returns expected status codes with a quick APITestCase or curl check before adding auth
  5. Add auth — Permissions, JWT authentication
  6. Test — Django TestCase, APITestCase

Reference Guide

Load detailed guidance based on context:

TopicReferenceLoad When
Modelsreferences/models-orm.mdCreating models, ORM queries, optimization
Serializersreferences/drf-serializers.mdDRF serializers, validation
ViewSetsreferences/viewsets-views.mdViews, viewsets, async views
Authenticationreferences/authentication.mdJWT, permissions, SimpleJWT
Testingreferences/testing-django.mdAPITestCase, fixtures, factories

Minimal Working Example

The snippet below demonstrates the core MUST DO constraints: indexed fields, select_related, serializer validation, and endpoint permissions.

# models.py
from django.db import models

class Article(models.Model):
    title = models.CharField(max_length=255, db_index=True)
    author = models.ForeignKey(
        "auth.User", on_delete=models.CASCADE, related_name="articles"
    )
    published_at = models.DateTimeField(auto_now_add=True, db_index=True)

    class Meta:
        ordering = ["-published_at"]
        indexes = [models.Index(fields=["author", "published_at"])]

    def __str__(self):
        return self.title

# serializers.py
from rest_framework import serializers
from .models import Article

class ArticleSerializer(serializers.ModelSerializer):
    author_username = serializers.CharField(source="author.username", read_only=True)

    class Meta:
        model = Article
        fields = ["id", "title", "author_username", "published_at"]

    def validate_title(self, value):
        if len(value.strip()) < 3:
            raise serializers.ValidationError("Title must be at least 3 characters.")
        return value.strip()

# views.py
from rest_framework import viewsets, permissions
from .models import Article
from .serializers import ArticleSerializer

class ArticleViewSet(viewsets.ModelViewSet):
    """
    Uses select_related to avoid N+1 on author lookups.
    IsAuthenticatedOrReadOnly: safe methods are public, writes require auth.
    """
    serializer_class = ArticleSerializer
    permission_classes = [permissions.IsAuthenticatedOrReadOnly]

    def get_queryset(self):
        return Article.objects.select_related("author").all()

    def perform_create(self, serializer):
        serializer.save(author=self.request.user)
# tests.py
from rest_framework.test import APITestCase
from rest_framework import status
from django.contrib.auth.models import User

class ArticleAPITest(APITestCase):
    def setUp(self):
        self.user = User.objects.create_user("alice", password="pass")

    def test_list_public(self):
        res = self.client.get("/api/articles/")
        self.assertEqual(res.status_code, status.HTTP_200_OK)

    def test_create_requires_auth(self):
        res = self.client.post("/api/articles/", {"title": "Test"})
        self.assertEqual(res.status_code, status.HTTP_403_FORBIDDEN)

    def test_create_authenticated(self):
        self.client.force_authenticate(self.user)
        res = self.client.post("/api/articles/", {"title": "Hello Django"})
        self.assertEqual(res.status_code, status.HTTP_201_CREATED)

Constraints

MUST DO

  • Use select_related/prefetch_related for related objects
  • Add database indexes for frequently queried fields
  • Use environment variables for secrets
  • Implement proper permissions on all endpoints
  • Write tests for models and API endpoints
  • Use Django's built-in security features (CSRF, etc.)

MUST NOT DO

  • Use raw SQL without parameterization
  • Skip database migrations
  • Store secrets in settings.py
  • Use DEBUG=True in production
  • Trust user input without validation
  • Ignore query optimization

Output Templates

When implementing Django features, provide:

  1. Model definitions with indexes
  2. Serializers with validation
  3. ViewSet or views with permissions
  4. Brief note on query optimization

Knowledge Reference

Django 5.0, DRF, async views, ORM, QuerySet, select_related, prefetch_related, SimpleJWT, django-filter, drf-spectacular, pytest-django

Documentation