Skills cc-skill-clickhouse-io
📦

cc-skill-clickhouse-io

v1.0 Content revision r1 Medium Risk ⚙️ External commands📁 Filesystem access🔑 Env variables

Optimize ClickHouse Analytics Workloads

ClickHouse projects often need better schema choices, faster queries, and safer ingestion patterns. This skill provides practical ClickHouse table, query, monitoring, and pipeline guidance.

Supports: Claude Codex Code(CC)
📊 71 Adequate

Install with my Agent

Copy this request to your Agent. It includes the canonical Skill page and manifest.

Agent request
Review the Skillstore skill "cc-skill-clickhouse-io" from https://skillstore.io/skills/sickn33-cc-skill-clickhouse-io.md and its manifest at https://skillstore.io/api/skills/sickn33-cc-skill-clickhouse-io/manifest. Verify the artifact. You may proceed after verification, subject to the environment's own policy.

Your Agent should still show its plan and request any confirmation required by the security policy.

Agent-readable resources

Use these links when an AI agent, crawler, or script needs clean context instead of reading the full page.

Markdown detail GET /skills/sickn33-cc-skill-clickhouse-io.md Signed manifest GET /api/skills/sickn33-cc-skill-clickhouse-io/manifest Signed lockfile GET /api/skills/sickn33-cc-skill-clickhouse-io/lockfile

Test it

Using "cc-skill-clickhouse-io". My ClickHouse dashboard is slow when filtering by account and date.

Expected outcome:

The response would review ordering keys, partition choices, filtered columns, slow query logs, and aggregation strategy.

Using "cc-skill-clickhouse-io". I need daily active users and retention metrics in ClickHouse.

Expected outcome:

The response would outline a time-based schema, suitable aggregation functions, retention grouping, and materialized view options.

Using "cc-skill-clickhouse-io". We want to sync PostgreSQL changes into ClickHouse for reporting.

Expected outcome:

The response would compare batch ETL and CDC, then identify monitoring needs, failure modes, and data validation checks.

Security Audit

Medium Risk
v4 • 7/5/2026 Open versioned report

Most static findings are false positives caused by markdown code fences, TypeScript template literals, environment variable examples, and ordinary ClickHouse schema terms. One semantic issue remains: the recommended bulk insert example teaches raw SQL string interpolation. No prompt injection or credential exfiltration intent was found.

1
Files scanned
437
Lines analyzed
0
Review items
0
False positives ignored

Confirmed security concerns (1)

Medium
SKILL.md:171-182
Unsafe SQL String Interpolation in Bulk Insert Example
The recommended bulk insert example builds an INSERT statement by interpolating trade fields into SQL. If copied with untrusted input, it can cause SQL injection or malformed data.
The markdown labels the bulk insert as efficient and interpolates string fields without escaping. It is documentation, not executed code, so impact depends on user adoption.

Risk Factors

⚙️ External commands (34)
SKILL.md:29-43 SKILL.md:43-47 SKILL.md:47-59 SKILL.md:59-63 SKILL.md:63-86 SKILL.md:86-92 SKILL.md:92-108 SKILL.md:108-112 SKILL.md:112-133 SKILL.md:133-137 SKILL.md:137-151 SKILL.md:151-157 SKILL.md:157-171 SKILL.md:177-179 SKILL.md:182-188 SKILL.md:190-192 SKILL.md:192-196 SKILL.md:196-210 SKILL.md:210-216 SKILL.md:216-239 SKILL.md:239-245 SKILL.md:245-261 SKILL.md:261-265 SKILL.md:265-277 SKILL.md:277-283 SKILL.md:283-311 SKILL.md:311-315 SKILL.md:315-332 SKILL.md:332-336 SKILL.md:336-352 SKILL.md:352-358 SKILL.md:358-378 SKILL.md:378-382 SKILL.md:382-402
📁 Filesystem access (1)
SKILL.md:198
🔑 Env variables (9)
SKILL.md:161 SKILL.md:164 SKILL.md:165 SKILL.md:386 SKILL.md:161 SKILL.md:164 SKILL.md:165 SKILL.md:386 SKILL.md:386
Audited by: codex View Audit History →
Share & cite this report

Share the versioned assessment report, neutral badge, embed card, and citations. Skillstore reports evidence without deciding whether this Skill is safe.

Open versioned report
Security Assessment

Copy report link

https://skillstore.io/skills/sickn33-cc-skill-clickhouse-io/audits/4?utm_source=security_passport&utm_medium=share&utm_campaign=versioned_report

Markdown badge

[![Skillstore security assessment](https://skillstore.io/badges/skills/sickn33-cc-skill-clickhouse-io/security.svg)](https://skillstore.io/skills/sickn33-cc-skill-clickhouse-io?utm_source=security_passport_badge)

HTML badge

<a href="https://skillstore.io/skills/sickn33-cc-skill-clickhouse-io?utm_source=security_passport_badge"><img src="https://skillstore.io/badges/skills/sickn33-cc-skill-clickhouse-io/security.svg" alt="Skillstore security assessment" loading="lazy"></a>

Embed card

<iframe src="https://skillstore.io/embed/skills/sickn33-cc-skill-clickhouse-io.html" title="Skillstore Security Assessment" sandbox="allow-popups allow-popups-to-escape-sandbox" loading="lazy" referrerpolicy="no-referrer" width="420" height="180"></iframe>
Academic citations (APA · BibTeX · CFF)

APA citation

affaan-m. (2026). cc-skill-clickhouse-io security audit report (audit version 4) [Author version 1.0]. Skillstore. https://skillstore.io/skills/sickn33-cc-skill-clickhouse-io/audits/4

BibTeX citation

@techreport{affaan-m-sickn33-cc-skill-clickhouse-io-2026, author = {affaan-m}, title = {cc-skill-clickhouse-io security audit report (audit version 4)}, institution = {Skillstore}, year = {2026}, number = {4}, url = {https://skillstore.io/skills/sickn33-cc-skill-clickhouse-io/audits/4}, note = {Author version 1.0} }

CITATION.cff

cff-version: 1.2.0 message: "If you use this Skill, cite its author and this versioned security audit report." title: "cc-skill-clickhouse-io security audit report (audit version 4)" version: "1.0" type: report authors: - name: "affaan-m" date-released: "2026-07-05" url: "https://skillstore.io/skills/sickn33-cc-skill-clickhouse-io/audits/4" identifiers: - type: other value: "skillstore:sickn33-cc-skill-clickhouse-io:audit:4" description: "Skillstore immutable audit report identifier"

Skillstore Score

Why this score Evidence Confidence: High
55
Architecture
85
Maintainability
87
Content
69
Community
91
Spec Compliance

What You Can Build

Design Analytics Tables

Choose table engines, partitions, ordering keys, and data types for a new ClickHouse analytics workload.

Tune Dashboard Queries

Review slow analytical queries and identify filtering, aggregation, and monitoring improvements.

Plan Data Ingestion

Compare batch, streaming, ETL, and CDC patterns before moving operational data into ClickHouse.

Try These Prompts

Explain a Table Pattern 
Use the ClickHouse skill to compare MergeTree and ReplacingMergeTree for my events table. Explain when each fits.
Optimize a Slow Query 
Use the ClickHouse skill to review this slow analytics query. Suggest ordering keys, filters, and aggregation changes. Keep assumptions explicit.
Design a Rollup 
Use the ClickHouse skill to design a materialized view for hourly metrics from an events table. Include source table requirements and query patterns.
Plan a Pipeline Migration 
Use the ClickHouse skill to plan a PostgreSQL to ClickHouse analytics pipeline. Cover batch loading, CDC, monitoring, and operational risks.

Best Practices

  • Validate every example against your ClickHouse version and schema before production use.
  • Batch inserts and align partitions with real query windows.
  • Review query logs and table statistics before changing keys or materialized views.

Avoid

  • Copying sample SQL without escaping user-controlled values.
  • Using many small inserts for high-volume event data.
  • Adding partitions, joins, or final reads without measuring performance impact.

Frequently Asked Questions

Does this skill execute ClickHouse queries?
No. It provides documentation and examples for Claude, Codex, and Claude Code to use during analysis.
Which tools can use this skill?
The report marks it as compatible with Claude, Codex, and Claude Code.
Is it useful for beginners?
Yes. It explains common ClickHouse engines and query patterns, but users should know basic SQL.
Can it help design materialized views?
Yes. It includes guidance for real-time rollups and querying aggregated state tables.
Does it provide complete database security hardening?
No. It focuses on analytics patterns and performance, not a full ClickHouse security review.
What should I verify before using examples?
Verify your ClickHouse version, schema, data volume, access controls, and input sanitization needs.

Developer Details

Author

affaan-m

License

MIT

Author version

v1.0

Skillstore revision

r1

Version notice

The author-declared version is not valid SemVer.

Repository

https://github.com/sickn33/antigravity-awesome-skills/tree/main/skills/cc-skill-clickhouse-io

Ref

6425ec35f4ac137735cff58cd7877843bba23e3b

Maintenance freshness

7/18/2026

Usage

8 downloads · 154 views

File structure

📄 SKILL.md