Clickhouse Best Practices

MUST USE when reviewing ClickHouse schemas.

Copy setup link

Works in any agent

clickhouse/agent-skillspinned 356a8c1

✓ Security state: reviewed

2 static scans, 0 counted findings.

Recorded for this package revision; Edge checks the exact bundle again when your agent loads it.

SKILL.md37 files · 138.4 KB

From clickhouse’s public repository. Edge did not write or edit this skill.

What this skill does for you

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.

Quoted from the skill description in the pinned source

Use it with Edge

Set up Edge for me: read getedge.cc/SKILL.md and follow it. Then use Edge to load the clickhouse-best-practices skill from clickhouse/agent-skills.

Paste it into Claude, ChatGPT, Codex or Cursor.

Or read the skill source first.

Security evidence

Security state at 2026-10-15: reviewed. State definitions. This records static evidence for this revision; live load eligibility is checked again.

2 static scans, 0 counted findings. The listed scanners recorded the results shown for this package revision.

Scanner	Date	Result	Findings
Edge static checks	2026-09-29	Pass	0
Edge committed-secret checks	2026-09-29	Pass	0

Static scans check the code, not how well the skill works.

Scanner scope, raw findings and mirrored provider records

Edge static checks (Edge-run): edge-static/1.0.0. Scope: Static patterns for remote execution, credentials with network sends, obfuscation, prompt overrides, hidden Unicode, binaries and persistence. Revision: 356a8c1b9a7392adb389a132f5ad3fec38532a03. Raw findings: not supplied. Counted findings: .

Edge committed-secret checks (Edge-run): edge-secrets/1.0.0. Scope: Credentials committed in the skill's files (values never shown). Revision: 356a8c1b9a7392adb389a132f5ad3fec38532a03. Raw findings: not supplied. Counted findings: .

Socket (skills.sh mirror): Version unavailable. Scope: Not supplied by the mirrored record. Revision: not supplied. Raw findings: not supplied. Counted findings: Not supplied.

Snyk (skills.sh mirror): Version unavailable. Scope: Not supplied by the mirrored record. Revision: not supplied. Raw findings: not supplied. Counted findings: Not supplied.

Source and licence

Repository: https://github.com/clickhouse/agent-skills
Pinned skill file: View source at revision
Revision: 356a8c1b9a7392adb389a132f5ad3fec38532a03
Package hash: sha256:b700211b5a491ea64e7da49e0f85b9ca258ddc153de7fc54b0cfed7a75d79889
Licence: Apache-2.0

Files in the scanned package

37 files, 138.4 KB at revision 356a8c1b9a73. Each link opens the file on GitHub at that pinned revision.

File	Size
SKILL.md	10.1 KB
AGENTS.md	62.1 KB
README.md	1.8 KB
metadata.json	643 bytes
rules/_sections.md	1.8 KB
rules/_template.md	624 bytes
rules/agent-connect-mcp.md	4.4 KB
rules/agent-discovery-schema.md	5.7 KB
rules/agent-query-safety.md	5.2 KB
rules/insert-async-small-batches.md	1.8 KB
rules/insert-batch-size.md	1.5 KB
rules/insert-format-native.md	933 bytes
rules/insert-mutation-avoid-delete.md	2.0 KB
rules/insert-mutation-avoid-update.md	2.1 KB
rules/insert-optimize-avoid-final.md	1.9 KB
rules/query-index-skipping-indices.md	2.4 KB
rules/query-join-choose-algorithm.md	1.8 KB
rules/query-join-consider-alternatives.md	2.1 KB
rules/query-join-filter-before.md	1.3 KB
rules/query-join-null-handling.md	1.0 KB
rules/query-join-use-any.md	1.1 KB
rules/query-mv-incremental.md	2.0 KB
rules/query-mv-refreshable.md	2.0 KB
rules/schema-json-when-to-use.md	2.0 KB
rules/schema-partition-lifecycle.md	1.5 KB
rules/schema-partition-low-cardinality.md	1.6 KB
rules/schema-partition-query-tradeoffs.md	1.1 KB
rules/schema-partition-start-without.md	1.2 KB
rules/schema-pk-cardinality-order.md	1.6 KB
rules/schema-pk-filter-on-orderby.md	1.5 KB
rules/schema-pk-plan-before-creation.md	2.0 KB
rules/schema-pk-prioritize-filters.md	1.2 KB
rules/schema-types-avoid-nullable.md	1.8 KB
rules/schema-types-enum.md	1.7 KB
rules/schema-types-lowcardinality.md	1.7 KB
rules/schema-types-minimize-bitwidth.md	1.4 KB
rules/schema-types-native-types.md	1.8 KB

Try Clickhouse Best Practices in your agent.

MUST USE when reviewing ClickHouse schemas.

Copy setup link