cpu-profile
A skill kept in the ClickHouse repository for finding where a ClickHouse query spends CPU time, using the server's built-in sampling profiler rather than Linux perf.
What the skill teaches
A skill kept in the ClickHouse repository for finding where a ClickHouse query spends CPU time, using the server's built-in sampling profiler rather than Linux perf. Given a query ID, the agent analyses existing traces; given SQL, it runs the query through clickhouse-client with a fresh ID and fine-grained profiler settings; with no input it can list recent slow queries. Three parallel subagents pull the busiest leaf functions, the most common full stacks and a collapsed-stack export from the trace log, and the agent reports hotspots, a breakdown by subsystem and findings. Follow-ups filter by function, compare wall-clock with CPU samples or draw a flamegraph. It needs introspection functions enabled and the debug symbols package.
Capabilities
- Run a ClickHouse query with the sampling profiler
- List the busiest functions and stacks
- Export collapsed stacks for a flamegraph
- Compare wall-clock and CPU samples
About
- Publisher
- ClickHouse
- Tool
- Debugging
Works with
Install
The project doesn't document install steps that we could confirm. See the project's own instructions
MCP servers and skills can run code on your computer and act on your data. Review the source before installing.
Details
| Fact | Value | Source |
|---|---|---|
| Type | Skill | |
| Tool | Debugging | |
| Publisher | ClickHouse | source |
| Official status | Not stated in its documentation | |
| Needs an API key or sign-in | Not stated in its documentation | |
| Includes scripts | No | source |
| Platforms | Not stated in its documentation | |
| AI clients | Claude Code | source |
| Licence | Apache-2.0 | source |
| Pricing | Not stated in its documentation | |
| Activity | Last commit Nov 11, 202650,877 GitHub starsDownload data not available (not on npm or PyPI) | source |
| Links | Repository Website |
More from ClickHouse
22 skills
- clickhouse-pr-description (Skill)
- continue-pr (Skill)
- good-prs (Skill)
- alloc-profile (Skill)
- bisect (Skill)
- clean-old-worktrees-global (Skill)
Also listed under: Debugging
Sources
- Skill file (SKILL.md)github.com/ClickHouse/ClickHouse · Backs: Includes scriptsNov 10, 2026
- GitHub repositorygithub.com/ClickHouse/ClickHouse · Backs: PublisherNov 17, 2026
- GitHub repositorygithub.com/clickhouse/clickhouse · Backs: Activity, LicenceNov 11, 2026
- Folder in the repository (cpu-profile)github.com/ClickHouse/ClickHouse · Backs: Includes scriptsNov 10, 2026