New: 98,000+ skills indexed from GitHub repos with 100+ stars · every skill safety-checkedBrowse top skillsTop skills
Esc to closeBrowse all skills
Submit a skillBrowse skills
Submit a skillBrowse skills

Agent skill

Django Index Design

by hashgraph-online in hashgraph-online/awesome-codex-plugins

Design safe Django and PostgreSQL indexes from measured query plans, including B-tree, composite, covering, partial, expression, GIN/JSONB, BRIN, and concurrent migration patterns.

MITAuto-check passedBackend & APIs

Install Django Index Design

skills CLI
$ npx skills add hashgraph-online/awesome-codex-plugins --skill django-index-design -a claude-code

Project install by default; add -g for ~/.claude/skills/.

GitHub CLI
$ gh skill install hashgraph-online/awesome-codex-plugins django-index-design --agent claude-code

Project scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).

Manual copy
$ git clone --depth 1 https://github.com/hashgraph-online/awesome-codex-plugins.git skills-src && mkdir -p .claude/skills && cp -r skills-src/plugins/LVTD-LLC/skills/skills/django-index-design .claude/skills/django-index-design && rm -rf skills-src

Use ~/.claude/skills/ instead of .claude/skills for a personal install. The folder must contain SKILL.md.

Claude Code skills documentation · loads skills from .claude/skills/

Facts

Skill name
django-index-design
GitHub stars
1.3k
Token cost
~643 tokens
SKILL.md length
266 words
Files
2 (incl. references)
Skills in repo
716
Repo updated
First seen
Licence
MIT

At a glance

Design safe Django and PostgreSQL indexes from measured query plans, including B-tree, composite, covering, partial, expression, GIN/JSONB, BRIN, and concurrent migration patterns.

  • Works in 4 steps: Start from a query plan. → Choose the index shape. → Express the index in Django models or… → …
  • A Django query plan suggests missing
  • SKILL.md covers Workflow, Production Rules and Verification
  • Instructions only: no scripts, shell commands, URLs or credentials in SKILL.md

What it does

Django Index Design is an agent skill from hashgraph-online/awesome-codex-plugins. 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.

Its SKILL.md is about 640 tokens, which your agent loads only when the skill is triggered. The skill folder holds 2 other files, including reference files (for example `references/index-patterns.md`). Compatibility notes: Codex, Claude Code, and other Agent Skills-compatible clients.

It sits in Backend & APIs, covering Backend development and Query optimization. It works with Django and PostgreSQL. The repository describes itself as: A curated list of awesome OpenAI Codex / ChatGPT plugins, skills, and resources. The 1 Codex Marketplace. See live plugins at: https://hol.org/plugins/best-codex-plugins. The licence is MIT.

When your agent uses it

  • A Django query plan suggests missing
  • Mismatched indexes
  • A production table needs an index without write downtime
  • Existing indexes need review

Example prompts

  • “/django-index-design”

Requirements

  • Compatibility (from SKILL.md): Codex, Claude Code, and other Agent Skills-compatible clients.

Workflow steps

4 steps, taken from the first numbered list in SKILL.md.

  1. Start from a query plan.
  2. Choose the index shape.
  3. Express the index in Django models or migrations.
  4. Validate on production-like data.

What it can do on your machine

Read from SKILL.md and the folder at commit 3e1456a. It shows what the files ask for, not the result of running them.

  • Tool permissions

    Pre-approves nothing: there is no allowed-tools line, so your agent's usual permission prompts apply.

    From allowed-tools in the SKILL.md frontmatter.

  • Runs code

    No scripts in the folder and no shell commands in SKILL.md.

    From the folder's file list and the shell code blocks in SKILL.md.

  • Network

    No URLs in SKILL.md.

    From URLs in SKILL.md, links to its own repository left out.

  • Credentials

    Names no API keys, tokens, secrets or passwords.

    From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.

  • Compatibility

    Codex, Claude Code, and other Agent Skills-compatible clients.

    From compatibility in the SKILL.md frontmatter.

Context cost

Django Index Design loads about 643 tokens when it runs, and up to ~1.5k if it reads all its reference files. Until then it costs about 90 tokens; SKILL.md has 266 words of instructions outside code blocks.

Always · name and description, kept in context so the agent knows when to use it
~90
When it runs · the whole SKILL.md, loaded when a task matches
~643
With references · SKILL.md plus every file in references/, read only if the agent opens them
~1.5k

Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.

Safety

Auto-check passed

The automated check found no risky patterns in SKILL.md.

Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); files beside SKILL.md are not scanned.

SKILL.md

The full file from hashgraph-online/awesome-codex-plugins at commit 3e1456a, republished under its MIT licence (© hashgraph-online). 266 words, ~643 tokens.

Download SKILL.mdSave it as .claude/skills/django-index-design/SKILL.md (or your agent's skills folder). This skill also uses 1 other file; get the full folder from GitHub.
name
django-index-design
description
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.
compatibility
Codex, Claude Code, and other Agent Skills-compatible clients.
license
MIT
metadata.version
0.1.0
metadata.displayName
Django Index Design
metadata.category
Django
metadata.tags
django,database,indexes,postgres,performance

Django Index Design

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.

Workflow

  1. Start from a query plan.

    • Capture the SQL, filters, joins, ordering, selected columns, table sizes, and current indexes.
    • Confirm that the query is important enough to optimize.

  2. Choose the index shape.

    • Equality filters first, then range/order fields when useful.
    • Match ORDER BY for LIMIT queries when possible.
    • Use partial indexes for highly queried subsets.
    • Use covering indexes only when selected columns are stable and index-only scans are plausible.
    • Use GIN for JSONB containment, arrays, and full-text patterns; do not expect a B-tree to solve those.

  3. Express the index in Django models or migrations.

    • Prefer Meta.indexes for normal model-owned indexes.
    • Prefer AddIndexConcurrently and RemoveIndexConcurrently for live PostgreSQL tables.
    • Use raw SQL only when Django cannot express the index.

  4. Validate on production-like data.

    • Re-run QuerySet.explain() or EXPLAIN ANALYZE.
    • Verify the planner uses the index for the target query.
    • Check write-path impact when the indexed table is hot.

See index-patterns.md for index examples and migration templates.

Production Rules

  • For PostgreSQL live tables, use concurrent index operations and set the migration atomic = False.
  • Keep names short, stable, and explicit.
  • Do not add duplicate indexes that are already covered by a unique constraint or a left-prefix composite index.
  • Remove unused indexes only after checking production usage and deployment rollback needs.

Verification

Finish with before/after plan evidence, the exact migration operation, and the operational risk assessment for locks, writes, and rollback.

© hashgraph-online, MIT. Rendered from Markdown: HTML in the file is shown as text, images as links, and headings moved down two levels. Raw file

Files

SKILL.md and 1 other file (references) in plugins/LVTD-LLC/skills/skills/django-index-design of hashgraph-online/awesome-codex-plugins.

  • SKILL.md
  • references/index-patterns.md

Open the folder on GitHubat commit 3e1456a

Compare with similar skills

Django Index Design next to the 5 skills that share the most tags, products or categories with it. Stars are the repository's; “used in” counts other GitHub owners with a copy.

Django Index Design compared with similar skills
SkillStarsUsed inTokensAuto-checkLicenceRepo updated
Django Index Design this skillhashgraph-online/awesome-codex-plugins1.3k—~643Automated safety check: PassMIT
Dsqlawslabs/agent-plugins916—~7.1kAutomated safety check: PassApache-2.0
Profiling Slow API EndpointsPostHog/posthog40k—~1kAutomated safety check: PassCustom licence
Silk Debugletsrevel/revel-backend110—~1.2kAutomated safety check: PassMIT
Silk Profilerbaserow/baserow6.1k—~2.9kAutomated safety check: PassCustom licence
Django Safe Migrationvintasoftware/django-ai-plugins153—~4.4kAutomated safety check: PassNone

Similar skills

  • Dsql

    awslabs/agent-plugins

    Official

    Build with Aurora DSQL — manage schemas, execute queries, handle migrations, diagnose query plans, diagnose cluster performance, load data, and develop applications with a serverless, distributed…

    916 GitHub stars~7.1k tokensUpdated today
    DatabasesAuto-check passed

  • Profiling Slow API Endpoints

    PostHog/posthog

    Official

    Profiles slow PostHog API endpoints when the main cost is in Postgres or Python.

    40k GitHub stars~1k tokensUpdated today
    DatabasesAuto-check passed

  • Silk Debug

    letsrevel/revel-backend

    Analyze Django Silk profiling data to debug slow requests, detect N+1 queries, and optimize database performance.

    110 GitHub stars~1.2k tokensUpdated 3 days ago
    Backend & APIsAuto-check passed

  • Silk Profiler

    baserow/baserow

    Investigate backend performance using Django Silk profiling data.

    6.1k GitHub stars~2.9k tokensUpdated yesterday
    Backend & APIsAuto-check passed

  • Django Safe Migration

    vintasoftware/django-ai-plugins

    Write, review, and rewrite Django migrations for PostgreSQL with zero-downtime guarantees.

    153 GitHub stars~4.4k tokensUpdated 2 mo ago
    Backend & APIsAuto-check passed

  • Django Migrations

    PostHog/posthog

    Official

    Django migration patterns and safety workflow for PostHog. An agent skill from PostHog/posthog.

    40k GitHub stars~5k tokensUpdated today
    Backend & APIsAuto-check passed

More from hashgraph-online/awesome-codex-plugins

All 716 skills in this repo

  • Anime Reaction Gif

    hashgraph-online/awesome-codex-plugins

    Create original anime-style reaction stickers as looping GIFs and MP4 previews, using generated character pose sheets and timed key poses.

    1.3k GitHub stars~922 tokensUpdated today
    Auto-check passed

  • Calibredb

    hashgraph-online/awesome-codex-plugins

    Manage and query Calibre libraries with the calibredb CLI (local paths or Calibre Content server URLs).

    1.3k GitHub stars~1k tokensUpdated today
    Auto-check passed

  • Rust API Test Harness

    hashgraph-online/awesome-codex-plugins

    A skill your agent uses when adding, changing, testing, or debugging Rust HTTP APIs and services, especially when Codex needs black-box integration tests, random-port app startup, real database test…

    1.3k GitHub stars~1.7k tokensUpdated today
    Auto-check passed

  • Art

    hashgraph-online/awesome-codex-plugins

    Make a studio's game look like something at build time — a cover from a real frame of the game (free), painted covers, backdrops, textures and character plates from image models through the…

    1.3k GitHub stars~2.4k tokensUpdated today
    Auto-check passed

  • Calle

    hashgraph-online/awesome-codex-plugins

    Use CALL-E from Codex through the calle CLI. An agent skill from hashgraph-online/awesome-codex-plugins.

    1.3k GitHub stars~2.9k tokensUpdated today
    Auto-check passed

  • Game Balance Economy

    hashgraph-online/awesome-codex-plugins

    Balance game difficulty, resources, rewards, probability, progression, economies, and dominant strategies.

    1.3k GitHub stars~618 tokensUpdated today
    Auto-check passed

Works with

Categories

Questions about Django Index Design

What does Django Index Design do?

Design safe Django and PostgreSQL indexes from measured query plans, including B-tree, composite, covering, partial, expression, GIN/JSONB, BRIN, and concurrent migration patterns. Django Index Design is an agent skill from hashgraph-online/awesome-codex-plugins. Design safe Django and PostgreSQL indexes from measured query plans, including B-tree, composite, covering, partial, expression, GIN/JSONB, BRIN, and concurrent migration patterns.

When should I use Django Index Design?

Django Index Design fits situations like: A Django query plan suggests missing; mismatched indexes; A production table needs an index without write downtime; existing indexes need review.

How do I install Django Index Design in Claude Code?

Run `npx skills add hashgraph-online/awesome-codex-plugins --skill django-index-design -a claude-code`. Or copy the skill folder (plugins/LVTD-LLC/skills/skills/django-index-design in hashgraph-online/awesome-codex-plugins) into .claude/skills/django-index-design in your project. Claude Code loads it when a task matches its description.

How do I install Django Index Design in Codex?

Run `npx skills add hashgraph-online/awesome-codex-plugins --skill django-index-design -a codex`. Or copy the skill folder (plugins/LVTD-LLC/skills/skills/django-index-design in hashgraph-online/awesome-codex-plugins) into .agents/skills/django-index-design in your project. Codex loads it when a task matches its description.

Can I use Django Index Design in Cursor, Gemini CLI or GitHub Copilot?

Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add hashgraph-online/awesome-codex-plugins --skill django-index-design -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/django-index-design, .gemini/skills/django-index-design, .github/skills/django-index-design and .opencode/skills/django-index-design in your project.

What does Django Index Design need to run?

SKILL.md names no scripts, command-line tools or credentials: Django Index Design is instructions for the agent only. Compatibility (from SKILL.md): Codex, Claude Code, and other Agent Skills-compatible clients..

Does Django Index Design access the network?

SKILL.md contains no URLs. Any network use would come from the scripts or tools the agent runs. This is read from the text; nothing was executed.

Is Django Index Design safe to install?

Our automated static check of SKILL.md found no risky patterns, such as piping downloads into a shell, reading credential files or hidden Unicode. It is not a guarantee. Review the folder before installing.

What licence does Django Index Design use?

Django Index Design is published under the MIT licence (declared in SKILL.md). It allows redistribution, so the full SKILL.md is shown on this page.

How many tokens does Django Index Design use?

About 643 tokens (SKILL.md is roughly 2.6k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full. Its references folder adds about 875 tokens, read only when the agent opens those files.

What are the alternatives to Django Index Design?

Skills that share tags, products or a category with Django Index Design: Dsql (awslabs/agent-plugins, 916 stars), Profiling Slow API Endpoints (PostHog/posthog, 40k stars), Silk Debug (letsrevel/revel-backend, 110 stars) and Silk Profiler (baserow/baserow, 6.1k stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.

Who maintains Django Index Design?

hashgraph-online (a GitHub organization) maintains it in hashgraph-online/awesome-codex-plugins, which has 1,267 GitHub stars. The repository holds 716 skills in this directory. The repository was last updated on October 10, 2026.

Source: hashgraph-online/awesome-codex-plugins on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.