Skip to content
anyai.fyi

clickhouse-best-practices

Skill from ClickHouse/agent-skills

Agents & Workflows No risky patterns found curated

Install

npx skills add ClickHouse/agent-skills --skill clickhouse-best-practices

Runs the open skills CLI and installs the skill for your agent (Claude Code, Codex, Cursor …). Alternatively copy the skill folder into .claude/skills/ or upload it in Claude.ai under Settings → Skills.

As a Claude Code plugin

/plugin marketplace add anthropics/claude-plugins-official /plugin install clickhouse-best-practices@clickhouse-agent-skills

This skill is part of the plugin “clickhouse-best-practices”. In Claude Code the plugin installs it together with the plugin’s other skills, commands and hooks.

What does the clickhouse-best-practices skill do?

MUST USE when reviewing ClickHouse schemas, queries, or configurations. Contains 31 rules that MUST be checked before providing recommendations. Always read relevant rule files and cite specific rules in responses.

Description from the SKILL.md in the source repository.

Questions about clickhouse-best-practices

What does the clickhouse-best-practices skill do?

MUST USE when reviewing ClickHouse schemas, queries, or configurations. Contains 31 rules that MUST be checked before providing recommendations. Always read relevant rule files and cite specific rules in responses.

How do I install clickhouse-best-practices?

In a terminal: npx skills add ClickHouse/agent-skills --skill clickhouse-best-practices. The skills CLI asks which agents to install it for. In Claude.ai you can upload the skill folder as a ZIP under Settings → Skills.

Which agents can use clickhouse-best-practices?

Skills use the open SKILL.md format, which Claude Code, Claude.ai, the Claude API, OpenAI Codex, Cursor, Gemini CLI and other agents support.

Is clickhouse-best-practices safe to use?

Our automatic check found no risky patterns (piped shell scripts, hidden characters, secret access, prompt overrides). It is not a full audit – read the SKILL.md and any scripts before installing.

More skills from ClickHouse/agent-skills

chdb-datastore
ClickHouse/agent-skills

Use when the user has tabular data (pandas DataFrame, parquet, csv, Arrow, json) and wants to filter, group, aggregate, join, or speed up slow pandas.

Data & Databases curated
No risky patterns found
chdb-sql
ClickHouse/agent-skills

Use when the user wants to run SQL — especially analytical SQL — on local files (parquet/csv/json), URLs, S3 paths, or remote databases (Postgres, MySQL, MongoDB, ClickHouse Cloud, Iceberg, Delta Lake) without …

Data & Databases curated
No risky patterns found
clickhouse-architecture-advisor
ClickHouse/agent-skills

MUST USE when designing ClickHouse architectures, selecting between ingestion or modeling patterns, or translating best practices into workload-specific system designs. Complements clickhouse-best-practices with decision frameworks and explicit provenance labels.

Development curated
No risky patterns found
clickhouse-js-node-coding
ClickHouse/agent-skills

Write idiomatic application code with the ClickHouse Node.js client (`@clickhouse/client`). Use this skill whenever a user is *building* against the Node.js client — configuring the client, pinging, inserting rows in JSON or …

Development curated
Worth a look
clickhouse-js-node-rowbinary
ClickHouse/agent-skills

Generate TypeScript/JavaScript code that reads/decodes AND writes/encodes ClickHouse RowBinary streams for the ClickHouse HTTP server. Use this skill whenever a user wants to parse or produce `RowBinary`, `RowBinaryWithNames`, or `RowBinaryWithNamesAndTypes`.

Development curated
No risky patterns found
clickhouse-js-node-troubleshooting
ClickHouse/agent-skills

Troubleshoot and resolve common issues with the ClickHouse Node.js client (@clickhouse/client). Use this skill whenever a user reports errors, unexpected behavior, or configuration questions involving the Node.js client specifically — including socket …

Data & Databases curated
No risky patterns found
clickhouse-managed-postgres-rca
ClickHouse/agent-skills

MUST USE when investigating performance issues on a ClickHouse-managed Postgres instance. Provides an evidence-based RCA workflow that scrapes the Prometheus endpoint for system signal, pulls per-digest evidence from the Slow Query Patterns …

Data & Databases curated
No risky patterns found
infra-clickhouse
ClickHouse/agent-skills

Sets up and manages ClickHouse using the clickhousectl CLI — installs and runs a local ClickHouse server for development, and creates managed ClickHouse Cloud services for production (authentication, service creation, schema migration …

DevOps & Cloud curated
Risky patterns

Related skills in Agents & Workflows