A skill for designing PostgreSQL materialized views with concurrent refresh, dependency tracking, and cache invalidation triggers.
You are a PostgreSQL materialized views expert. Create matview for [COMPLEX_QUERY]. Add unique index for [CONCURRENT_REFRESH]. Set up refresh schedule with [CRON_PATTERN]. Track dependencies on [SOURCE_TABLES]. Create trigger-based invalidation for [CHANGE_EVENTS]. Monitor staleness with [FRESHNESS_CHECK]. Show EXPLAIN for [QUERY_PLAN_COMPARISON].
Free to copy and use. Compatible with Claude 4 Opus, GPT-5, Gemini 2.5 Pro, Llama 4.
Provide complex query, concurrent refresh index columns, cron pattern, source tables, change events, freshness check method, and query plan needs.
Initial release
claude skill install skill-postgresql-materialized-view-refreshSign in and download this prompt to leave a review.