NEW Browse AI tools across categories — updated daily. See what's new →

Cpu Profile

Profile a ClickHouse query using the sampling query profiler and system.trace_log. Use when the user wants to find CPU hotspots, analyze where time is spent in…

Version1.0.0
LicenseMIT
Token count~613
UpdatedJun 5, 2026

Install

Quick install

via npx skills · works with 57+ agents
npx skills add https://github.com/clickhouse/clickhouse/tree/HEAD/skills/cpu-profile
Or pick agent:
npx skills add clickhouse/clickhouse --skill cpu-profile --agent claude-code
npx skills add clickhouse/clickhouse --skill cpu-profile --agent cursor
npx skills add clickhouse/clickhouse --skill cpu-profile --agent codex
npx skills add clickhouse/clickhouse --skill cpu-profile --agent opencode
npx skills add clickhouse/clickhouse --skill cpu-profile --agent github-copilot
npx skills add clickhouse/clickhouse --skill cpu-profile --agent windsurf
More install options

Shorthand — useful for multi-skill repos:

npx skills add clickhouse/clickhouse --skill cpu-profile

Manual — clone the repo and drop the folder into your agent's skills directory:

git clone https://github.com/clickhouse/clickhouse.git
cp -r clickhouse/skills/cpu-profile ~/.claude/skills/
How to use: Once installed, ask your agent to "use the cpu-profile skill" or describe what you want (e.g. "Profile a ClickHouse query using the sampling query profiler and system.trace_lo"). Requires Node.js 18+.

cpu-profile

Profile a ClickHouse query using the sampling query profiler and system.trace_log. Use when the user wants to find CPU hotspots, analyze where time is spent in…

cpu-profileby clickhouse

Profile a ClickHouse query using the sampling query profiler and system.trace_log. Use when the user wants to find CPU hotspots, analyze where time is spent in…

npx skills add https://github.com/clickhouse/clickhouse --skill cpu-profileDownload ZIPGitHub

More skills from clickhouse

chdb-sqlby clickhouseRun ClickHouse SQL directly in Python — no server needed. Query local files, remote databases, and cloud storage with full ClickHouse SQL power.chdb-datastoreby clickhouseDataStore is a lazy, ClickHouse-backed pandas replacement . Your existing pandas code works unchanged — but operations compile to optimized SQL and execute only when results are needed (e.g., print() , len() , iteration).clickhouse-architecture-advisorby clickhouseMUST USE when designing ClickHouse architectures, selecting between ingestion or modeling patterns, or translating best practices into workload-specific system…clickhouse-best-practicesby clickhouse28 ClickHouse best practices rules organized by schema design, query optimization, and data ingestion strategy. Covers three critical areas: primary key and data type selection (immutable design decisions), JOIN and query optimization, and insert batching with mutation avoidance Includes 28 rules prioritized by impact, with schema design and query optimization rules marked CRITICAL due to ClickHouse's columnar storage and sparse index mechanics Provides structured review procedures for...clickhousectl-cloud-deployby clickhouseUse when a user wants to deploy ClickHouse to the cloud, go to production, use ClickHouse Cloud, host a managed ClickHouse service, or migrate from a local…clickhousectl-local-devby clickhouseUse when a user wants to build an application with ClickHouse, set up a local ClickHouse development environment, install ClickHouse, create a local server,…setupby clickhouseGuides users through setting up the ClickHouse MCP server connection bundled with this plugin. Use when the user first installs the plugin or has trouble…clickhouse-js-node-codingby clickhouseReference: https://clickhouse.com/docs/integrations/javascript

---

Source: https://github.com/clickhouse/clickhouse/tree/HEAD/skills/cpu-profile
Author: clickhouse
Discovered via: mcpservers.org

SKILL.md source

---
name: cpu-profile
description: Profile a ClickHouse query using the sampling query profiler and system.trace_log. Use when the user wants to find CPU hotspots, analyze where time is spent in…
---

# cpu-profile

Profile a ClickHouse query using the sampling query profiler and system.trace_log. Use when the user wants to find CPU hotspots, analyze where time is spent in…

# cpu-profileby clickhouse
Profile a ClickHouse query using the sampling query profiler and system.trace_log. Use when the user wants to find CPU hotspots, analyze where time is spent in…

`npx skills add https://github.com/clickhouse/clickhouse --skill cpu-profile`Download ZIPGitHub

## More skills from clickhouse
chdb-sqlby clickhouseRun ClickHouse SQL directly in Python — no server needed. Query local files, remote databases, and cloud storage with full ClickHouse SQL power.chdb-datastoreby clickhouseDataStore is a lazy, ClickHouse-backed pandas replacement . Your existing pandas code works unchanged — but operations compile to optimized SQL and execute only when results are needed (e.g., print() , len() , iteration).clickhouse-architecture-advisorby clickhouseMUST USE when designing ClickHouse architectures, selecting between ingestion or modeling patterns, or translating best practices into workload-specific system…clickhouse-best-practicesby clickhouse28 ClickHouse best practices rules organized by schema design, query optimization, and data ingestion strategy. Covers three critical areas: primary key and data type selection (immutable design decisions), JOIN and query optimization, and insert batching with mutation avoidance Includes 28 rules prioritized by impact, with schema design and query optimization rules marked CRITICAL due to ClickHouse's columnar storage and sparse index mechanics Provides structured review procedures for...clickhousectl-cloud-deployby clickhouseUse when a user wants to deploy ClickHouse to the cloud, go to production, use ClickHouse Cloud, host a managed ClickHouse service, or migrate from a local…clickhousectl-local-devby clickhouseUse when a user wants to build an application with ClickHouse, set up a local ClickHouse development environment, install ClickHouse, create a local server,…setupby clickhouseGuides users through setting up the ClickHouse MCP server connection bundled with this plugin. Use when the user first installs the plugin or has trouble…clickhouse-js-node-codingby clickhouseReference: https://clickhouse.com/docs/integrations/javascript

---

**Source**: https://github.com/clickhouse/clickhouse/tree/HEAD/skills/cpu-profile
**Author**: clickhouse
**Discovered via**: mcpservers.org

Related skills 6

caveman

★ Featured

Ultra-compressed communication mode. Cuts token usage ~75% by speaking like caveman while keeping full technical accuracy. Supports intensity levels: lite, full (default), ultra, wenyan-lite, wenyan-full, wenyan-ultra. Use when user says "caveman mode", "talk like caveman", "use caveman", "less tokens", "be brief", or invokes /caveman. Also auto-triggers when token efficiency is requested.

juliusbrussee 167k
Development

secure-linux-web-hosting

★ Featured

Use when setting up, hardening, or reviewing a cloud server for self-hosting, including DNS, SSH, firewalls, Nginx, static-site hosting, reverse-proxying an app, HTTPS with Let's Encrypt or ACME clients, safe HTTP-to-HTTPS redirects, or optional post-launch network tuning such as BBR.

xixu-me 155k
Development

readme-i18n

★ Featured

Use when the user wants to translate a repository README, make a repo multilingual, localize docs, add a language switcher, internationalize the README, or update localized README variants in a GitHub-style repository.

xixu-me 155k
Development

lark-shared

★ Featured

Use when first setting up lark-cli, running auth login, switching user/bot identity (--as), handling permission denied or scope errors, needing to update lark-cli, or seeing _notice in JSON output.

larksuite 155k
Development

improve-codebase-architecture

★ Featured

Find deepening opportunities in a codebase, informed by the domain language in CONTEXT.md and the decisions in docs/adr/. Use when the user wants to improve architecture, find refactoring opportunities, consolidate tightly-coupled modules, or make a codebase more testable and AI-navigable.

mattpocock 151k
Development

paper-context-resolver

★ Featured

Optional RigorPilot helper for README-first deep learning repo reproduction. Use only when the README and repository files leave a narrow reproduction-critical gap and the task is to resolve a specific paper detail such as dataset split, preprocessing, evaluation protocol, checkpoint mapping, or runtime assumption from primary paper sources while recording conflicts. Do not use for general paper summary, repo scanning, environment setup, command execution, title-only paper lookup, or replacin...

lllllllama 127k
Development