Skip to main content

clickhouse-reference-architecture

Provides a comprehensive reference architecture for building ClickHouse-backed applications, focusing on project layout and data flow.

Install this skill

or
87/100

Security score

The clickhouse-reference-architecture skill was audited on May 30, 2026 and we found 13 security issues across 3 threat categories. Review the findings below before installing.

Categories Tested

Security Issues

low line 51

Webhook reference - potential data exfiltration

SourceSKILL.md
51│ │ ├── webhook-receiver.ts # HTTP webhook endpoint
low line 76

Webhook reference - potential data exfiltration

SourceSKILL.md
76│ (Webhooks, API, │
low line 66

Access to .env file

SourceSKILL.md
66├── development.env
low line 67

Access to .env file

SourceSKILL.md
67├── staging.env
low line 68

Access to .env file

SourceSKILL.md
68└── production.env
low line 210

Access to .env file

SourceSKILL.md
210url: process.env.CLICKHOUSE_HOST!,
low line 211

Access to .env file

SourceSKILL.md
211username: process.env.CLICKHOUSE_USER!,
low line 212

Access to .env file

SourceSKILL.md
212password: process.env.CLICKHOUSE_PASSWORD!,
low line 213

Access to .env file

SourceSKILL.md
213database: process.env.CLICKHOUSE_DATABASE ?? 'analytics',
low line 214

Access to .env file

SourceSKILL.md
214max_open_connections: Number(process.env.CH_MAX_CONNECTIONS ?? 10),
low line 261

External URL reference

SourceSKILL.md
261- [ClickHouse Architecture](https://clickhouse.com/docs/development/architecture)
low line 262

External URL reference

SourceSKILL.md
262- [SharedMergeTree (Cloud)](https://clickhouse.com/docs/cloud/reference/shared-merge-tree)
low line 263

External URL reference

SourceSKILL.md
263- [Materialized Views](https://clickhouse.com/blog/using-materialized-views-in-clickhouse)
Scanned on May 30, 2026
View Security Dashboard
Installation guide →