Catalog / Skills

Django Index Design

Design safe Django and PostgreSQL indexes from measured query plans, including B-tree, composite, covering, partial, expression, GIN/JSONB, BRIN, and concurrent migration patterns. Use when a Django query plan suggests missing or mismatched indexes, a production table needs an index without write downtime, or existing indexes need review.

Djangov0.1.0MITdjangodatabaseindexespostgresperformance

Install

npx skills add LVTD-LLC/skills --skill django-index-design

From `SKILL.md`

Use this skill to add or change indexes only after profiling shows a specific query can benefit. Indexes speed selected reads and constraints, but they add write cost, migration risk, and maintenance overhead.