CtrlK
BlogDocsLog inGet started
Tessl Logo

auditing-warehouse-view-health

Audit the health of a PostHog project's materialized views (saved queries) — find every failed materialization and flag unused or stale materialized views that cost storage and compute. Use when the user asks "which of my views are broken?", "why is this materialized view failing?", "are any of my views wasting compute?", or wants a one-shot triage of view health. For source/sync health use `auditing-warehouse-source-health`.

75

Quality

92%

Does it follow best practices?

Run evals on this skill

Adds up to 20 points to the overall score

View guide

SecuritybySnyk

Passed

No findings from the security scan

SKILL.md
Quality
Evals
Security

Quality

Content

85%

Reviews the quality of instructions and guidance provided to agents. Good implementation is clear, handles edge cases, and produces reliable results.

The skill body is highly actionable with a clear, checkpointed workflow and clean organization. The only weakness is mild repetition of the out-of-scope routing notes, which slightly dilutes conciseness.

Suggestions

Consolidate the out-of-scope routing (source/sync/destination/transformation) into a single section; it currently appears in the intro, the issue table, and Important notes.

Trim the duplicated 'route, don't diagnose' guidance to one location to tighten token usage.

DimensionReasoningScore

Conciseness

The body is largely lean and assumes Claude knows the domain (no explaining what materialized views or PostHog are), but the out-of-scope routing for source/sync/destination/transformation is repeated across the intro, the issue table, and the Important notes, which is mild padding.

2 / 3

Actionability

Provides concrete tool names, a specific type filter ('materialized_view'), exact response fields, and a copy-ready human-readable report template — fully actionable rather than abstract.

3 / 3

Workflow Clarity

A clear five-step sequence with explicit checkpoints — a stop condition when there are no issues ('tell the user their materialized views are healthy and stop') and explicit confirm-before-destructive-action guidance — covering the read-only audit's validation needs.

3 / 3

Progressive Disclosure

A single, well-organized SKILL.md with clean sections (When to use, Available tools, What counts as an issue, Workflow, Important notes) and no nested references; with no bundle files present the structure is appropriately flat and navigable.

3 / 3

Total

11

/

12

Passed

Description

100%

Based on the skill's description, can an agent find and select it at the right time? Clear, specific descriptions lead to better discovery.

A strong, third-person description that concretely states capabilities, provides natural trigger phrases, covers both what and when, and clearly distinguishes itself from the sibling source-health skill. No first/second-person voice issues.

DimensionReasoningScore

Specificity

Lists multiple concrete actions ('find every failed materialization and flag unused or stale materialized views that cost storage and compute') tied to a specific domain, matching the comprehensive-actions anchor rather than merely naming a domain.

3 / 3

Completeness

Clearly answers what (audit/flag materialized views) and when via an explicit 'Use when the user asks...' clause with concrete triggers, satisfying both halves of the completeness anchor.

3 / 3

Trigger Term Quality

Includes natural user phrasings ('which of my views are broken?', 'why is this materialized view failing?', 'are any of my views wasting compute?') plus 'one-shot triage of view health', giving good coverage of terms users would actually say.

3 / 3

Distinctiveness Conflict Risk

Occupies a clear niche (materialized view health) with distinct triggers and explicit routing to a sibling skill ('For source/sync health use auditing-warehouse-source-health'), making it unlikely to trigger for the wrong skill.

3 / 3

Total

12

/

12

Passed

Validation

100%

Checks the skill against the spec for correct structure and formatting. All validation checks must pass before discovery and implementation can be scored.

Validation16 / 16 Passed

Validation for skill structure

No warnings or errors.

Repository
PostHog/posthog
Reviewed

Table of Contents

Is this your skill?

If you maintain this skill, you can claim it as your own. Once claimed, you can manage eval scenarios, bundle related skills, attach documentation or rules, and ensure cross-agent compatibility.