clickhouse-data-handling
Manages data lifecycle in ClickHouse, including TTL expiration, GDPR compliance, and sensitive data handling with SQL.
Install this skill
or
85/100
Security score
The clickhouse-data-handling skill was audited on May 30, 2026 and we found 7 security issues across 3 threat categories. Review the findings below before installing.
Categories Tested
Security Issues
medium line 143
Template literal with variable interpolation in command context
SourceSKILL.md
| 143 | query: `SELECT * FROM analytics.${table} WHERE user_id = {uid:UInt64}`, |
medium line 160
Template literal with variable interpolation in command context
SourceSKILL.md
| 160 | query: `ALTER TABLE analytics.${table} DELETE WHERE user_id = {uid:UInt64}`, |
low line 135
Access to .env file
SourceSKILL.md
| 135 | const client = createClient({ url: process.env.CLICKHOUSE_HOST! }); |
low line 155
Access to .env file
SourceSKILL.md
| 155 | const client = createClient({ url: process.env.CLICKHOUSE_HOST! }); |
low line 250
External URL reference
SourceSKILL.md
| 250 | - [TTL for Data Management](https://clickhouse.com/docs/engines/table-engines/mergetree-family/mergetree#table_engine-mergetree-ttl) |
low line 251
External URL reference
SourceSKILL.md
| 251 | - [DELETE Statement](https://clickhouse.com/docs/sql-reference/statements/delete) |
low line 252
External URL reference
SourceSKILL.md
| 252 | - [Mutations](https://clickhouse.com/docs/guides/developer/mutations) |
Scanned on May 30, 2026
View Security DashboardGitHub Stars 51
Rate this skill
Categorydevelopment
UpdatedOctober 27, 2026
claude-codedatabaseapidata-engineerdatabase-administratordata-analystml-ai-engineerbusiness-process-analystdevelopmentdata analyticsoperations
ComeOnOliver/skillshub