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 Materialized Views

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

Model, migrate, refresh, and verify PostgreSQL materialized views in Django for expensive report or dashboard queries that can tolerate stale data.

MITAuto-check passedBackend & APIs

Install Django Materialized Views

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

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

GitHub CLI
$ gh skill install hashgraph-online/awesome-codex-plugins django-materialized-views --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-materialized-views .claude/skills/django-materialized-views && 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-materialized-views
GitHub stars
1.2k
Token cost
~611 tokens
SKILL.md length
244 words
Files
2 (incl. references)
Skills in repo
686
Repo updated
First seen
Licence
MIT

At a glance

Model, migrate, refresh, and verify PostgreSQL materialized views in Django for expensive report or dashboard queries that can tolerate stale data.

  • Works in 4 steps: Confirm fit. → Design the materialized view. → Integrate with Django. → …
  • ORM/index/query rewrites are not enough
  • SKILL.md covers Workflow, Safety Notes and Verification
  • Instructions only: no scripts, shell commands, URLs or credentials in SKILL.md

What it does

Django Materialized Views is an agent skill from hashgraph-online/awesome-codex-plugins. Model, migrate, refresh, and verify PostgreSQL materialized views in Django for expensive report or dashboard queries that can tolerate stale data. Use when ORM/index/query rewrites are not enough, the result is read often, freshness can be bounded, and a Django app needs unmanaged models, RunSQL migrations, refresh commands, or concurrent refresh.

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

It sits in Backend & APIs, covering Backend development and ORMs and data access. It works with Django, PostgreSQL and SQL. 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

  • ORM/index/query rewrites are not enough
  • The result is read often
  • Freshness can be bounded
  • A Django app needs unmanaged models

Example prompts

  • “/django-materialized-views”

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. Confirm fit.
  2. Design the materialized view.
  3. Integrate with Django.
  4. Implement refresh.

What it can do on your machine

Read from SKILL.md and the folder at commit 78497e5. 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 Materialized Views loads about 611 tokens when it runs, and up to ~1.3k if it reads all its reference files. Until then it costs about 94 tokens; SKILL.md has 244 words of instructions outside code blocks.

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

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 78497e5, republished under its MIT licence (© hashgraph-online). 244 words, ~611 tokens.

Download SKILL.mdSave it as .claude/skills/django-materialized-views/SKILL.md (or your agent's skills folder). This skill also uses 1 other file; get the full folder from GitHub.
name
django-materialized-views
description
Model, migrate, refresh, and verify PostgreSQL materialized views in Django for expensive report or dashboard queries that can tolerate stale data. Use when ORM/index/query rewrites are not enough, the result is read often, freshness can be bounded, and a Django app needs unmanaged models, RunSQL migrations, refresh commands, or concurrent refresh.
compatibility
Codex, Claude Code, and other Agent Skills-compatible clients.
license
MIT
metadata.version
0.1.0
metadata.displayName
Django Materialized Views
metadata.category
Django
metadata.tags
django,database,materialized-views,postgres,performance

Django Materialized Views

Use this skill when an expensive read query is reused often and can tolerate controlled staleness. Try query-plan, index, and ORM expression improvements first; materialized views add operational state.

Workflow

  1. Confirm fit.

    • The source query is expensive and stable.
    • Consumers can accept stale data.
    • Refresh cadence, ownership, and failure behavior are clear.
    • PostgreSQL is the target database.

  2. Design the materialized view.

    • Define the SQL query and output columns.
    • Add a unique column or unique column set if concurrent refresh is required.
    • Add indexes for consumer queries against the view.

  3. Integrate with Django.

    • Create the view with RunSQL.
    • Represent it as an unmanaged model with managed = False.
    • Keep the unmanaged model fields aligned with the SQL output.
    • Make writes impossible at the application boundary.

  4. Implement refresh.

    • Use REFRESH MATERIALIZED VIEW for simple refreshes.
    • Use REFRESH MATERIALIZED VIEW CONCURRENTLY only when the view is already populated and has a qualifying unique index.
    • Schedule refresh through a management command, task queue, or database job.

See materialized-view-patterns.md for migration, model, and refresh templates.

Safety Notes

  • A materialized view returns stored data; it is not automatically current.
  • Concurrent refresh avoids locking out reads but has prerequisites and still allows only one refresh at a time per view.
  • Refreshing a large view can be a major database workload. Measure it separately from reads.

Verification

Validate the SQL against source tables, test the unmanaged model reads, prove refresh behavior, and measure read latency before/after.

© 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-materialized-views of hashgraph-online/awesome-codex-plugins.

  • SKILL.md
  • references/materialized-view-patterns.md

Open the folder on GitHubat commit 78497e5

Compare with similar skills

Django Materialized Views 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 Materialized Views compared with similar skills
SkillStarsUsed inTokensAuto-checkLicenceRepo updated
Django Materialized Views this skillhashgraph-online/awesome-codex-plugins1.2k—~611Automated safety check: PassMIT
Dsqlawslabs/agent-plugins915—~6.9kAutomated safety check: PassApache-2.0
Fastapiericrisco/rsc-harness167—~5kAutomated safety check: NotesMIT
Database Migrationsaffaan-m/ECC275k4 repos~3kAutomated safety check: PassMIT
Database Migrationsaffaan-m/ECC275k3 repos~1.9kAutomated safety check: PassMIT
Database Migrationsaffaan-m/ECC275k1 repos~2.4kAutomated safety check: PassMIT

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…

    915 GitHub stars~6.9k tokensUpdated 2 days ago
    DatabasesAuto-check passed

  • Fastapi

    ericrisco/rsc-harness

    A skill your agent uses when building, reviewing, testing, securing or shipping a FastAPI / async Python service — routers, Pydantic v2 schemas, dependency injection, async SQLAlchemy 2.0…

    167 GitHub stars~5k tokensUpdated today
    Backend & APIsAuto-check: notes

  • Database Migrations

    affaan-m/ECC

    Safe, reversible database migration patterns: forward-only production changes, expand-contract zero-downtime renames, concurrent indexes, batched backfills, and per-tool workflows for PostgreSQL…

    275k GitHub starsUsed in 4 repos~3k tokens
    DatabasesAuto-check passed

  • Database Migrations

    affaan-m/ECC

    数据库迁移最佳实践，涵盖模式变更、数据迁移、回滚以及零停机部署，适用于PostgreSQL、MySQL及常用ORM（Prisma、Drizzle、Django、TypeORM、golang-migrate）。

    275k GitHub starsUsed in 3 repos~1.9k tokens
    DatabasesAuto-check passed

  • Database Migrations

    affaan-m/ECC

    Şema değişiklikleri, veri migration'ları, rollback'ler ve PostgreSQL, MySQL ve yaygın ORM'ler (Prisma, Drizzle, Django, TypeORM, golang-migrate) arasında sıfır kesinti deployment'ları için…

    275k GitHub starsUsed in 1 repo~2.4k tokens
    DatabasesAuto-check passed

  • Planetscale Codebase Sqlcommenter Instrumentation

    planetscale/skills

    Official

    Inspect an application repository connected to PlanetScale and recommend SQLCommenter-compatible query tagging packages and conventions.

    133 GitHub stars~1.2k tokensUpdated yesterday
    DatabasesAuto-check passed

More from hashgraph-online/awesome-codex-plugins

All 686 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.2k 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.2k 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.2k 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.2k GitHub stars~2.4k 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.2k GitHub stars~618 tokensUpdated today
    Auto-check passed

  • Manuscript Engagement Analytics

    hashgraph-online/awesome-codex-plugins

    Analyze nonfiction manuscripts for reader engagement signals, including heading-level word counts, slow starts, long slogs, weak takeaway titles, value pacing, beta-reader comment dropoff, and…

    1.2k GitHub stars~875 tokensUpdated today
    Auto-check passed

Works with

Categories

Questions about Django Materialized Views

What does Django Materialized Views do?

Model, migrate, refresh, and verify PostgreSQL materialized views in Django for expensive report or dashboard queries that can tolerate stale data. Django Materialized Views is an agent skill from hashgraph-online/awesome-codex-plugins. Model, migrate, refresh, and verify PostgreSQL materialized views in Django for expensive report or dashboard queries that can tolerate stale data.

When should I use Django Materialized Views?

Django Materialized Views fits situations like: ORM/index/query rewrites are not enough; the result is read often; freshness can be bounded; A Django app needs unmanaged models.

How do I install Django Materialized Views in Claude Code?

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

How do I install Django Materialized Views in Codex?

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

Can I use Django Materialized Views 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-materialized-views -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-materialized-views, .gemini/skills/django-materialized-views, .github/skills/django-materialized-views and .opencode/skills/django-materialized-views in your project.

What does Django Materialized Views need to run?

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

Does Django Materialized Views 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 Materialized Views 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 Materialized Views use?

Django Materialized Views 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 Materialized Views use?

About 611 tokens (SKILL.md is roughly 2.4k 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 728 tokens, read only when the agent opens those files.

What are the alternatives to Django Materialized Views?

Skills that share tags, products or a category with Django Materialized Views: Dsql (awslabs/agent-plugins, 915 stars), Fastapi (ericrisco/rsc-harness, 167 stars), Database Migrations (affaan-m/ECC, 275k stars) and Database Migrations (affaan-m/ECC, 275k stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.

Who maintains Django Materialized Views?

hashgraph-online (a GitHub organization) maintains it in hashgraph-online/awesome-codex-plugins, which has 1,242 GitHub stars. The repository holds 686 skills in this directory. The repository was last updated on October 8, 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.