clickhouse-io
Optimize ClickHouse Analytics Workloads
Analytical database work needs schema and query choices that match ClickHouse behavior. This skill gives Claude, Codex, and Claude Code practical patterns for tables, ingestion, aggregation, monitoring, and pipelines.
Install with my Agent
Copy this request to your Agent. It includes the canonical Skill page and manifest.
Review the Skillstore skill "clickhouse-io" from https://skillstore.io/skills/sickn33-clickhouse-io.md and its manifest at https://skillstore.io/api/skills/sickn33-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.
Test it
Using "clickhouse-io". I need a table for daily trading metrics by market.
Expected outcome:
Recommends a MergeTree table partitioned by month, ordered by date and market, with compact numeric types.
Using "clickhouse-io". My dashboard query is slow on recent events.
Expected outcome:
Suggests filtering first by date, aligning order keys with dashboard predicates, and reviewing query logs for high read volume.
Using "clickhouse-io". I want hourly metrics without scanning raw trades.
Expected outcome:
Proposes a materialized view that stores aggregate states and a read path that merges states at query time.
Security Audit
Medium RiskMost static findings are false positives caused by Markdown code fences and illustrative TypeScript or SQL examples, not executable skill code. No prompt injection or credential exfiltration intent was found, but one example encourages unsafe SQL interpolation if copied into production.
Confirmed security concerns (1)
Risk Factors
โ๏ธ External commands (34)
๐ Filesystem access (1)
๐ Env variables (9)
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.
Copy report link
https://skillstore.io/skills/sickn33-clickhouse-io/audits/4?utm_source=security_passport&utm_medium=share&utm_campaign=versioned_reportMarkdown badge
[](https://skillstore.io/skills/sickn33-clickhouse-io?utm_source=security_passport_badge)HTML badge
<a href="https://skillstore.io/skills/sickn33-clickhouse-io?utm_source=security_passport_badge"><img src="https://skillstore.io/badges/skills/sickn33-clickhouse-io/security.svg" alt="Skillstore security assessment" loading="lazy"></a>Embed card
<iframe src="https://skillstore.io/embed/skills/sickn33-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). clickhouse-io security audit report (audit version 4) [Author version 1.0]. Skillstore. https://skillstore.io/skills/sickn33-clickhouse-io/audits/4BibTeX citation
@techreport{affaan-m-sickn33-clickhouse-io-2026,
author = {affaan-m},
title = {clickhouse-io security audit report (audit version 4)},
institution = {Skillstore},
year = {2026},
number = {4},
url = {https://skillstore.io/skills/sickn33-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: "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-clickhouse-io/audits/4"
identifiers:
- type: other
value: "skillstore:sickn33-clickhouse-io:audit:4"
description: "Skillstore immutable audit report identifier"
Skillstore Score
Why this score Evidence Confidence: HighWhat You Can Build
Design Analytics Tables
Plan ClickHouse table engines, partitions, ordering keys, and data types for large analytical datasets.
Improve Dashboard Queries
Review filtering, aggregation, and monitoring patterns for faster dashboard and reporting queries.
Build Event Pipelines
Draft ingestion, ETL, CDC, and materialized view patterns for near real-time analytics workflows.
Try These Prompts
Help me design a ClickHouse MergeTree table for [dataset]. Include partition key, ordering key, and data types.
Review this ClickHouse query goal: [goal]. Suggest filters, ordering keys, and aggregation changes that may improve performance.
Design a ClickHouse materialized view strategy for [events]. Include stored aggregates, refresh behavior, and query tradeoffs.
Create a ClickHouse ingestion plan for [source system]. Cover batching, CDC, schema evolution, monitoring, and failure handling.
Best Practices
- Validate generated SQL against your ClickHouse version before production use.
- Review ordering keys with real dashboard filters and cardinality.
- Use environment variables for secrets, and never paste credentials into prompts.
Avoid
- Copying example SQL into production without schema and data volume review.
- Using small frequent inserts when batching or streaming is available.
- Asking the skill to infer sensitive database credentials from local files.