Clickhouse Best Practices
v1.0.0ClickHouse 数据库优化专家技能。MUST USE when reviewing ClickHouse schemas, queries, or configurations. 审查 CREATE TABLE、ALTER TABLE、SELECT、JOIN、聚合查询、写入策略和配置。包含 28 条规则，涵...
⭐ 0· 97·2 current·2 all-time
MIT-0
Download zip
LicenseMIT-0 · Free to use, modify, and redistribute. No attribution required.
Security Scan
Capability signals
These labels describe what authority the skill may exercise. They are separate from suspicious or malicious moderation verdicts.
OpenClaw
Benign
high confidencePurpose & Capability
Name, description, and the included rules (28 rule files) all relate to ClickHouse schema/query/write optimizations. There are no unrelated environment variables, binaries, or install steps requested — the required surface is proportionate to the stated purpose.
Instruction Scope
SKILL.md confines runtime behavior to consulting the rules/ directory and applying rule-based checks. It also allows falling back to LLM knowledge or network searches when no rule applies; that fallback is reasonable for keeping advice current but is an open-ended permission to fetch external web content. The skill does not instruct reading local system files or environment variables beyond its own bundle.
Install Mechanism
No install spec and no code to execute — instruction-only skill. Nothing will be downloaded or written to the agent's environment by the skill itself.
Credentials
Requires no environment variables, credentials, or config paths. The guidance and rule files do not request secrets or access to unrelated services.
Persistence & Privilege
always:false and default invocation settings. The skill does not request persistent/system-wide privileges or modify other skills' configurations.
Assessment
This skill appears coherent and focused: it bundles a comprehensive set of ClickHouse rules and gives a clear output format for reviews. Before installing, consider: (1) whether the agent is allowed to access the public web (the skill may perform network searches when rules are missing); (2) validate that the suggested best-practices match your ClickHouse version and organizational constraints (some recommendations depend on ClickHouse 24.x+ features); and (3) test any schema or write-policy changes in staging — the rules are prescriptive and can require heavyweight migrations (e.g., changing ORDER BY requires table migration). There are no requests for credentials or installs, so the direct security risk from this skill bundle is low.Like a lobster shell, security has layers — review code before you run it.
latestvk97e0c95nfh0bcapk5cw2hszxn84gx90
License
MIT-0
Free to use, modify, and redistribute. No attribution required.