Content
85%Reviews the quality of instructions and guidance provided to agents. Good implementation is clear, handles edge cases, and produces reliable results.
The body is a high-quality, highly actionable methodology with a clear sequenced workflow and excellent one-level-deep progressive disclosure into real reference files. Its only real weakness is conciseness: a handful of key caveats and the save-location instruction are repeated across sections and could be consolidated.
Suggestions
Consolidate the 'all queries, not just the slow set' rationale into a single canonical statement (e.g. once in step 2 and once in Report structure §5) and reference it elsewhere rather than re-deriving it in steps 5 and Interpreting the results.
State the report save-location rule once (e.g. in Report structure) and link back to it from step 9 and the grounding section instead of repeating the temp-fallback guidance three times.
The 'Covers the modern query_log_archive source...' detail in the description and the Data source section overlap; consider trimming the description's source detail to keep it a trigger-focused summary.
| Dimension | Reasoning | Score |
|---|---|---|
Conciseness | Most content is dense, non-obvious expert knowledge (lc_* columns, exception codes, archive retention) that earns its place, but several points are restated multiple times — the 'all queries, not just the slow set' caveat recurs across steps 2, 5, Interpreting the results, and Report structure §5, and the sibling-repo save location is repeated three times — so it could be tightened. It is above the score-1 'explains concepts Claude knows' floor but below the fully lean anchor. | 2 / 3 |
Actionability | Provides executable SQL predicates ('query_duration_ms > 30000 OR exception_code IN (159, 160, 241)', 'FROM posthog.query_log_archive'), concrete commands ('hogli metabase:databases'), a full typed-column table, and precise file-naming and report-structure conventions — copy-paste ready guidance rather than abstract direction. | 3 / 3 |
Workflow Clarity | A clearly sequenced 9-step process with explicit ordering guidance ('Do not read previous reports until step 9'), a validation checkpoint (step 1 'Confirm the window' via per-day count), and explicit feedback logic in the delta step (comparable windows, incident-excluded baseline) — matching the 'clear sequence with explicit validation steps' anchor. | 3 / 3 |
Progressive Disclosure | The SKILL.md is an overview with three well-signaled, one-level-deep references (query-patterns.md, materialization-analysis.md, hogql-deep-dive.md — all real files in references/), each annotated with what it contains; bulk SQL and deep dives are appropriately split out with easy navigation. | 3 / 3 |
Total | 11 / 12 Passed |