Claude Code, Plugin
Clickhouse Best Practices
28 best practice rules for ClickHouse schema design, query optimization, and data ingestion — prioritized by impact
Compatibility: Portable across standard formats.
Grade C
One Medium finding. Read the findings before installing.
Not a guarantee. A hygiene check of the source at the commit shown, not a security audit.
Rescanned at commit 69a8354b05b5.
SECRETS_PATH_CREDENTIAL
Why this grade
- SECRETS_PATH_CREDENTIAL Medium
Mentions a credential store path (~/.ssh, id_rsa, .npmrc, .aws/credentials, credentials.json, .netrc).
skills/clickstack-otel-collector/SKILL.md, line 254
{ echo "export CLICKHOUSE_CLOUD_API_KEY=$(jq -r .api_key "$HOME/.clickhouse/credentials.json")"
Any High, or two or more Medium findings, give D. One Medium gives C. Low findings or a security Note give B. Each code names a finding behind the letter.
Grades are a hygiene check of the source at the commit shown, on the date checked, not a security audit or a guarantee. The free directory grades are automated. Before release, a PlugVet engineer reviews every paid report and any grade we hold back, including all F grades, against the source code and the evidence we quote.
What was checked
Plain notes from the hygiene checks.
Permissions
Pass
No shell or command execution found, and no extra permission was declared.
Install and update
Note
The docs document an installer that pipes a download into a shell.
INSTALL_DOCUMENTED_INSTALLER
skills/clickstack-otel-collector/SKILL.md, line 201
curl -fsSL https://clickhouse.com/cli | sh
skills/infra-clickhouse/SKILL.md, line 41
curl -fsSL https://clickhouse.com/cli | sh
skills/infra-postgres/SKILL.md, line 42
curl -fsSL https://clickhouse.com/cli | sh
Network
Concern
can reach a host that is not written as a fixed address. can reach api.clickhouse.cloud. The description does not name that host.
NETWORK_NO_FIXED_HOST NETWORK_UNNAMED_HOST
packages/clickhouse-best-practices-build/src/check-external-links.ts, line 116
let response = await fetch(url, {
packages/clickhouse-best-practices-build/src/check-external-links.ts, line 125
response = await fetch(url, {
packages/clickhouse-best-practices-build/src/validate-sql.ts, line 76
await execAsync(`curl -L -o "${CLICKHOUSE_BINARY}" "${url}"`)
Show more
skills/clickhouse-best-practices/AGENTS.md, line 1754
curl -s "https://abc123.clickhouse.cloud:8443/" \
skills/clickhouse-best-practices/rules/agent-connect-mcp.md, line 86
curl -s "https://abc123.clickhouse.cloud:8443/" \
skills/clickhouse-js-node-troubleshooting/reference/socket-hangup.md, line 70
curl -v --data-binary "SELECT 1" <your_clickhouse_url>
skills/clickhouse-managed-postgres-rca/AGENTS.md, line 109
curl -s https://api.clickhouse.cloud/v1 > /tmp/ch-cloud-openapi.json
skills/clickhouse-managed-postgres-rca/AGENTS.md, line 264
curl -s -u "$CH_CLOUD_KEY:$CH_CLOUD_SECRET" \
Secrets
Concern
reads a credential or environment file.
SECRETS_ENV_READ SECRETS_PATH_CREDENTIAL SECRETS_PATH_DOTENV
skills/clickhouse-js-node-coding/reference/async-insert.md, line 24
password: process.env.CLICKHOUSE_PASSWORD,
skills/clickhouse-js-node-coding/reference/client-configuration.md, line 38
password: process.env.CLICKHOUSE_PASSWORD, // defaults to ''
skills/clickstack-otel-collector/SKILL.md, line 254
{ echo "export CLICKHOUSE_CLOUD_API_KEY=$(jq -r .api_key "$HOME/.clickhouse/credentials.json")"
Show more
skills/clickhouse-js-node-coding/reference/ping.md, line 35
password: process.env.CLICKHOUSE_PASSWORD,
skills/infra-clickhouse/ref/cloud.md, line 119
echo "CLICKHOUSE_PASSWORD=$PASSWORD" >> .env
skills/clickstack-otel-collector/SKILL.md, line 255
echo "export CLICKHOUSE_CLOUD_API_SECRET=$(jq -r .api_secret "$HOME/.clickhouse/credentials.json")"
skills/clickhouse-js-node-coding/reference/client-configuration.md, line 59
# In your shell environment / deployment config (e.g. .env, Kubernetes secret):
skills/infra-clickhouse/ref/cloud.md, line 118
echo "CLICKHOUSE_USER=app_user" >> .env
.claude-plugin/marketplace.json, line 137
"description": "Local and cloud workflows for running Postgres with clickhousectl — local Docker-backed Postgres for development (start, psql client, .env wiring, lifecycle) and ma
.gitignore, line 6
.env
Agent instructions
Pass
No instruction to ignore earlier instructions or to hide a step.
Obfuscation
Pass
No encoded or minified payload found.
Licence
Pass
A licence file is present (LICENSE).
Maintainer activity
Pass
The latest commit is within the last 365 days.
Note
Hygiene check of commit 69a8354b05b5. can reach a host that is not written as a fixed address. can reach api.clickhouse.cloud. The description does not name that host. reads a credential or environment file.
Date and source
Date checked:
github.com
Commit graded: 69a8354b05b5942e5cea77b6c87be7788303fc18
This link goes to the original host. PlugVet does not host or check what you download from there, and installing it is your own decision and risk.