plan-and-verify

Decompose multi-step ClickHouse operational tasks into explicit verification checklists.

255|42|Updated Nov 16, 2023
One-click install
npx skills add https://github.com/chmonitor/chmonitor --skill plan-and-verify
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: plan-and-verify
Source: https://github.com/chmonitor/chmonitor/tree/main/.agents/skills/plan-and-verify
Command: npx skills add https://github.com/chmonitor/chmonitor --skill plan-and-verify

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill eliminates the two most common agent mistakes on multi-step ClickHouse operational tasks: stating unconfirmed findings and losing track of completed work, which can lead to costly incorrect recommendations for schema changes, query rewrites, or anomaly responses.

Core Features & Use Cases

  • Structured Task Planning: Breaks 3+ step investigations, recommendations, and diagnoses into explicit update_plan checklists with clear progress tracking to maintain transparency on complex work.
  • Rigorous Verification Discipline: Requires confirmation of all data findings via re-run queries, EXPLAIN comparisons for query rewrites, and measurable effect validation for recommendations before reporting.
  • Confidence-Separated Reporting: Clearly distinguishes confirmed findings, likely inferences, and unverified hypotheses to avoid presenting guesses as fact.
  • Use Case: For example, when investigating slow queries on a ClickHouse table, use this Skill to plan the investigation, verify part count trends, and only report confirmed root causes with actionable measurement guidance.

Quick Start

Use the plan-and-verify skill to investigate why queries on your ClickHouse events table have been slow since yesterday afternoon, following the structured planning and verification workflow to confirm the root cause before reporting findings.

Frequently Asked Questions about plan-and-verify

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I verify ClickHouse query tuning results before applying schema changes?

Verify ClickHouse query tuning results by using EXPLAIN comparisons for query rewrites and re-running queries to confirm data findings before reporting schema changes.

What is the best way to track progress on multi-step ClickHouse anomaly diagnosis?

Track multi-step ClickHouse anomaly diagnosis progress by decomposing investigations into explicit, trackable checklists to prevent losing completed work and stating unconfirmed findings.

How do I prevent unverified findings during ClickHouse operational workflows?

Prevent unverified findings during ClickHouse operational workflows by enforcing confidence-separated reporting that distinguishes confirmed data findings, likely inferences, and unverified hypotheses.

When do I need structured task planning for ClickHouse cross-table analysis?

Structured task planning is needed for ClickHouse cross-table analysis when investigations span 3 or more tool calls, schema recommendations, or anomaly diagnoses where incorrect outputs carry real operational cost.

Does this approach work for validating measurable effects of query rewrites?

Yes, this approach works for validating query rewrites by requiring measurable effect validation for all recommendations and EXPLAIN comparisons before reporting results.

Can I use task planning checklists for slow query investigations on ClickHouse tables?

Yes, you can use task planning checklists for slow query investigations on ClickHouse tables to plan the investigation, verify part count trends, and report confirmed root causes with measurement guidance.