Skills
.Work. You
Rest

materialized-view-checker

Community

Audit database views and refresh schedules.

Software Engineering#performance#database#audit#sql#materialized view#refresh schedule
AuthorBruceTyndall
Version1.0.0
Installs0

System Documentation

What problem does it solve?

This Skill identifies and analyzes materialized views and database views within a project, ensuring their refresh schedules are correctly configured and assessing potential performance implications.

Core Features & Use Cases

  • View Inventory: Lists all CREATE VIEW and CREATE MATERIALIZED VIEW statements found in migration files.
  • Refresh Schedule Audit: Checks for configurations related to refreshing materialized views, including pg_cron or cron.schedule patterns.
  • RPC Function Analysis: Identifies stored procedures (RPC functions) that might be used as alternatives to views and checks for frontend calls to these functions.
  • Use Case: Before deploying database changes, run this Skill to verify that all materialized views are accounted for and have appropriate refresh mechanisms in place, preventing stale data or performance bottlenecks.

Quick Start

Run the materialized-view-checker skill to audit all database views and their refresh schedules.

Dependency Matrix

Required Modules

None required

Components

scripts

💻 Claude Code Installation

Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.

Please help me install this Skill:
Name: materialized-view-checker
Download link: https://github.com/BruceTyndall/socelle-global/archive/main.zip#materialized-view-checker

Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
View Source Repository

Agent Skills Search Helper

Install a tiny helper to your Agent, search and equip skill from 223,000+ vetted skills library on demand.