New: 98,000+ skills indexed from GitHub repos with 100+ stars · every skill safety-checkedBrowse top skillsTop skills
Esc to closeBrowse all skills
Submit a skillBrowse skills
Submit a skillBrowse skills

Agent skill

Clickhouse Best Practices

by chmonitor in chmonitor/chmonitor

Production operational practices: insert batching, async writes, query cache, connection pooling, and recommended settings.

GPL-3.0Auto-check passedDatabases

Install Clickhouse Best Practices

skills CLI
$ npx skills add chmonitor/chmonitor --skill clickhouse-best-practices -a claude-code

Project install by default; add -g for ~/.claude/skills/.

GitHub CLI
$ gh skill install chmonitor/chmonitor clickhouse-best-practices --agent claude-code

Project scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).

Manual copy
$ git clone --depth 1 https://github.com/chmonitor/chmonitor.git skills-src && mkdir -p .claude/skills && cp -r skills-src/.agents/skills/clickhouse-best-practices .claude/skills/clickhouse-best-practices && rm -rf skills-src

Use ~/.claude/skills/ instead of .claude/skills for a personal install. The folder must contain SKILL.md.

Claude Code skills documentation · loads skills from .claude/skills/

Facts

Skill name
clickhouse-best-practices
GitHub stars
299
Token cost
~434 tokens
SKILL.md length
150 words
Files
1
Skills in repo
53
Repo updated
First seen
Licence
GPL-3.0

At a glance

Production operational practices: insert batching, async writes, query cache, connection pooling, and recommended settings.

  • Tasks that involve Data warehousing
  • SKILL.md covers Insert Best Practices, Async Inserts, Query Cache (v23.5+) and Connection Pooling, plus 2 more sections
  • Instructions only: no scripts, shell commands, URLs or credentials in SKILL.md
  • Tasks that involve Database administration

What it does

Clickhouse Best Practices is an agent skill from chmonitor/chmonitor. Production operational practices: insert batching, async writes, query cache, connection pooling, and recommended settings.

Its SKILL.md is about 430 tokens, which your agent loads only when the skill is triggered. It is a single SKILL.md file with no bundled scripts.

It sits in Databases, covering Data warehousing and Database administration. It works with ClickHouse. The repository describes itself as: Open-source operational advisor for ClickHouse — real-time monitoring plus AI-driven index/partition/materialized-view recommendations. The licence is GPL-3.0.

When your agent uses it

  • Tasks that involve Data warehousing
  • Tasks that involve Database administration

Example prompts

  • “/clickhouse-best-practices”

What it can do on your machine

Read from SKILL.md and the folder at commit fc39ef0. It shows what the files ask for, not the result of running them.

  • Tool permissions

    Pre-approves nothing: there is no allowed-tools line, so your agent's usual permission prompts apply.

    From allowed-tools in the SKILL.md frontmatter.

  • Runs code

    No scripts in the folder and no shell commands in SKILL.md.

    From the folder's file list and the shell code blocks in SKILL.md.

  • Network

    No URLs in SKILL.md.

    From URLs in SKILL.md, links to its own repository left out.

  • Credentials

    Names no API keys, tokens, secrets or passwords.

    From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.

Context cost

Clickhouse Best Practices loads about 434 tokens when it runs. Until then it costs about 37 tokens; SKILL.md has 150 words of instructions outside code blocks.

Always · name and description, kept in context so the agent knows when to use it
~37
When it runs · the whole SKILL.md, loaded when a task matches
~434

Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.

Safety

Auto-check passed

The automated check found no risky patterns in SKILL.md.

Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); files beside SKILL.md are not scanned.

SKILL.md

The full file from chmonitor/chmonitor at commit fc39ef0, republished under its GPL-3.0 licence (© chmonitor). 150 words, ~434 tokens.

Download SKILL.mdSave it as .claude/skills/clickhouse-best-practices/SKILL.md (or your agent's skills folder).
name
clickhouse-best-practices
description
Production operational practices: insert batching, async writes, query cache, connection pooling, and recommended settings.

ClickHouse Best Practices

Insert Best Practices

  • Batch 10k-100k rows per insert; max 1-2 inserts/sec per table
  • Sub-1k-row inserts cause part proliferation; insert in sorting-key order to reduce merge work
  • For bulk loads, tune min_insert_block_size_rows / max_insert_block_size_rows

Async Inserts

  • SET async_insert = 1; SET wait_for_async_insert = 1; (1=durable, 0=fire-and-forget)
  • Tune async_insert_max_data_size (1M) and async_insert_busy_timeout_ms (10s) for batch window

Query Cache (v23.5+)

  • SET allow_experimental_query_cache = 1; SET use_query_cache = 1;
  • TTL: query_cache_ttl; share across users: query_cache_shared_between_users = 1
  • Control: enable_writes_to_query_cache, enable_reads_from_query_cache

Connection Pooling

  • HTTP: set pool_size, max_queries; keep-alive is critical
  • TCP: built-in multiplexing; tune max_connections
  • Monitor system.metrics for HTTPConnection/TCPConnection to size pools

Production Settings

  • max_threads — lower for concurrent loads; max_insert_threads — raise for parallel inserts
  • max_execution_time / max_memory_usage — per-query limits
  • join_algorithm — prefer grace_hash or auto for large joins
  • input_format_allow_errors_num / ratio — tolerate parse errors in bulk imports

Query Patterns

  • COLUMNS('pattern') — regex column selection; APPLY func transforms matches
  • clusterAllReplicas('cluster') — aggregate across all replicas
  • FINAL — force merge for ReplacingMergeTree; use sparingly (full scan)

© chmonitor, GPL-3.0. Rendered from Markdown: HTML in the file is shown as text, images as links, and headings moved down two levels. Raw file

Files

Just SKILL.md in .agents/skills/clickhouse-best-practices of chmonitor/chmonitor.

Open the folder on GitHubat commit fc39ef0

Compare with similar skills

Clickhouse Best Practices next to the 5 skills that share the most tags, products or categories with it. Stars are the repository's; “used in” counts other GitHub owners with a copy.

Clickhouse Best Practices compared with similar skills
SkillStarsUsed inTokensAuto-checkLicenceRepo updated
Clickhouse Best Practices this skillchmonitor/chmonitor299—~434Automated safety check: PassGPL-3.0
Whodbxiaoyuge886/aigc198—~894Automated safety check: PassMIT
Keeper Stress AnalysisClickHouse/ClickHouse50k—~4.7kAutomated safety check: PassApache-2.0
Perf ComparisonClickHouse/ClickHouse50k—~3.9kAutomated safety check: NotesApache-2.0
Patch Release CheckClickHouse/ClickHouse50k—~4kAutomated safety check: NotesApache-2.0
Clickhouse Architecture Advisorvemetric/vemetric3942 repos~791Automated safety check: PassApache-2.0

Similar skills

  • Whodb

    xiaoyuge886/aigc

    Database operations including querying, schema exploration, and data analysis.

    198 GitHub stars~894 tokensUpdated 2 mo ago
    DatabasesAuto-check passed

  • Keeper Stress Analysis

    ClickHouse/ClickHouse

    Analyze ClickHouse Keeper stress-test results from play.clickhouse.com / keeperstresstests data warehouse.

    50k GitHub stars~4.7k tokensUpdated yesterday
    DatabasesAuto-check passed

  • Perf Comparison

    ClickHouse/ClickHouse

    Evaluate ClickHouse performance test results from existing CI/dashboard data or local perf.py runs.

    50k GitHub stars~3.9k tokensUpdated yesterday
    DatabasesAuto-check: notes

  • Patch Release Check

    ClickHouse/ClickHouse

    Check whether ClickHouse's supported versions (last 3 majors + latest LTS) have recent stable patch releases, diagnose why the scheduled AutoReleases pipeline failed, and identify which releases…

    50k GitHub stars~4k tokensUpdated yesterday
    DatabasesAuto-check: notes

  • Clickhouse Architecture Advisor

    vemetric/vemetric

    MUST USE when designing ClickHouse architectures, selecting between ingestion or modeling patterns, or translating best practices into workload-specific system designs.

    394 GitHub starsUsed in 2 repos~791 tokens
    DatabasesAuto-check passed

  • Decompress Binary

    ClickHouse/ClickHouse

    Extract the inner ELF from a ClickHouse self-extracting clickhouse binary, including when its architecture differs from the host (e.g.

    50k GitHub stars~1.1k tokensUpdated yesterday
    DatabasesAuto-check passed

More from chmonitor/chmonitor

All 53 skills in this repo

  • Hyperframes Creative

    chmonitor/chmonitor

    Non-animation creative direction for HyperFrames videos. An agent skill from chmonitor/chmonitor.

    299 GitHub starsUsed in 5 repos~1.3k tokens
    Auto-check passed

  • Hyperframes Media

    chmonitor/chmonitor

    Audio and media assets for HyperFrames compositions, produced by one shared audio engine (scripts/audio.mjs) — multi-provider TTS (HeyGen / ElevenLabs / Kokoro local), background music + sound…

    299 GitHub starsUsed in 1 repo~2.8k tokens
    Auto-check: notes

  • Remotion To Hyperframes

    chmonitor/chmonitor

    Port an existing Remotion (React) composition to HyperFrames HTML.

    299 GitHub starsUsed in 1 repo~2.5k tokens
    Auto-check passed

  • Music To Video

    chmonitor/chmonitor

    A skill your agent uses when the user has a music track (an audio file, or a video to pull audio from) and wants a beat-synced HyperFrames video, calm to hard-hitting.

    299 GitHub starsUsed in 1 repo~4k tokens
    Auto-check: notes

  • Hyperframes Animation

    chmonitor/chmonitor

    All animation knowledge for HyperFrames — atomic motion rules, multi-phase scene blueprints, scene transitions, broader motion-design techniques, AND the seven runtime adapters (GSAP default, plus…

    299 GitHub starsUsed in 2 repos~1.8k tokens
    Auto-check passed

  • Faceless Explainer

    chmonitor/chmonitor

    turn arbitrary text — an article, notes, a topic, a brief — into a faceless explainer video, up to ~3 min (sweet spot 30-90s), where every visual is invented (typography, abstract graphics…

    299 GitHub stars~4.5k tokensUpdated 3 days ago
    Auto-check: notes

Works with

Categories

Questions about Clickhouse Best Practices

What does Clickhouse Best Practices do?

Production operational practices: insert batching, async writes, query cache, connection pooling, and recommended settings. Clickhouse Best Practices is an agent skill from chmonitor/chmonitor. Production operational practices: insert batching, async writes, query cache, connection pooling, and recommended settings.

When should I use Clickhouse Best Practices?

Clickhouse Best Practices fits situations like: tasks that involve Data warehousing; tasks that involve Database administration.

How do I install Clickhouse Best Practices in Claude Code?

Run `npx skills add chmonitor/chmonitor --skill clickhouse-best-practices -a claude-code`. Or copy the skill folder (.agents/skills/clickhouse-best-practices in chmonitor/chmonitor) into .claude/skills/clickhouse-best-practices in your project. Claude Code loads it when a task matches its description.

How do I install Clickhouse Best Practices in Codex?

Run `npx skills add chmonitor/chmonitor --skill clickhouse-best-practices -a codex`. Or copy the skill folder (.agents/skills/clickhouse-best-practices in chmonitor/chmonitor) into .agents/skills/clickhouse-best-practices in your project. Codex loads it when a task matches its description.

Can I use Clickhouse Best Practices in Cursor, Gemini CLI or GitHub Copilot?

Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add chmonitor/chmonitor --skill clickhouse-best-practices -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/clickhouse-best-practices, .gemini/skills/clickhouse-best-practices, .github/skills/clickhouse-best-practices and .opencode/skills/clickhouse-best-practices in your project.

What does Clickhouse Best Practices need to run?

SKILL.md names no scripts, command-line tools or credentials: Clickhouse Best Practices is instructions for the agent only.

Does Clickhouse Best Practices access the network?

SKILL.md contains no URLs. Any network use would come from the scripts or tools the agent runs. This is read from the text; nothing was executed.

Is Clickhouse Best Practices safe to install?

Our automated static check of SKILL.md found no risky patterns, such as piping downloads into a shell, reading credential files or hidden Unicode. It is not a guarantee. Review the folder before installing.

What licence does Clickhouse Best Practices use?

Clickhouse Best Practices is published under the GPL-3.0 licence (the repository's licence). It allows redistribution, so the full SKILL.md is shown on this page.

How many tokens does Clickhouse Best Practices use?

About 434 tokens (SKILL.md is roughly 1.7k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full.

What are the alternatives to Clickhouse Best Practices?

Skills that share tags, products or a category with Clickhouse Best Practices: Whodb (xiaoyuge886/aigc, 198 stars), Keeper Stress Analysis (ClickHouse/ClickHouse, 50k stars), Perf Comparison (ClickHouse/ClickHouse, 50k stars) and Patch Release Check (ClickHouse/ClickHouse, 50k stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.

Who maintains Clickhouse Best Practices?

chmonitor (a GitHub organization) maintains it in chmonitor/chmonitor, which has 299 GitHub stars. The repository holds 53 skills in this directory. The repository was last updated on October 5, 2026.

Source: chmonitor/chmonitor on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.