Catalog / Skills

Django Materialized Views

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.

Djangov0.1.0MITdjangodatabasematerialized-viewspostgresperformance

Install

npx skills add LVTD-LLC/skills --skill django-materialized-views

From `SKILL.md`

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.