generating-clickhouse-query-performance-reports
generating-clickhouse-query-performance-reports is a SQL analytics & reporting skill for AI agents, published by PostHog in the posthog repository on GitHub. Skillspace rates generating-clickhouse-query-performance-reports D (62/100) and it passed the safety scan; a judge model has also reviewed it.
Produce and structure slow-query performance reports for PostHog's production ClickHouse (US and EU). Use when asked for a slow query report, query performance analysis over the last N days, per-team query cost, OOM or timeout investigation, cluster cost/memory regressions, or materialization candidates. Covers the modern `query_log_archive` source (typed `lc_*` columns, multi-day retention), how to categorize and attribute slow queries, root-cause patterns (unmaterialized JSONExtract, high-cardinality breakdowns, heavy joins), and the report structure. Runs queries via the `query-clickhouse-via-metabase` skill.
- Grade
- D
- Quality
- 62 / 100
- Safety
- Passed
- GitHub stars
- 35,560
Placed #3 of 6 in the judged category final for SQL analytics & reporting.
Our two independent classifiers differ on this skill's category, so treat the placement as provisional.
This rating describes the version of the repository we crawled; it may have changed since, so go by its current files.
Our review
- Architecture
- 78 / 100
- Maturity
- Structured: ships references or scripts
- Security scan
- No issues found
- License
- Not declared. Check the repository before reusing it.
- Adoption
- Adopted by 1 other repositories, in 0 collections
- Scope
- Repo-internal: written for the repository it lives in. PostHog's production ClickHouse clusters and internal hogli/Metabase tooling
Judge review
Placed #3 of 6 in the judged category final for SQL analytics & reporting.
- Trigger
86 86 - Instructions
85 85 - Specificity
88 88 - Safety
78 78 - Disclosure
85 85 - Maintenance
82 82
Cleanly separates methodology from access mechanism and degrades gracefully to a temp file when its expected private report repo is not present.
Not checked yet
- Category is a classifier prediction; no model has read this skill yet
- No blind task eval yet
- Sibling files (scripts, references) not fetched; security scan covers SKILL.md only
Skillspace indexes and rates this skill; it does not host or endorse it. Run third-party skills at your own risk.