mcp-clickhouse
Flagged as possibly malicious Reviewed: expected behaviour
Bawwab's static rules matched a pattern it treats as critical. Read the review notes: a reviewed false alarm is marked as such.
Why it was flagged
The static rules marked this “Flagged as possibly malicious” because of:
exfil.combo: Reads credentials and makes network calls (critical, 1× ยท first at PKG-INFO:281)
- Kind
- MCP server
- Source
- pypi
- Version
0.7.0- Popularity
- 63,485 PyPI downloads/week (2026-11-20)
- Link
- https://pypi.org/project/mcp-clickhouse/0.7.0/
- Scanned
- 2026-11-20T22:02:28+00:00
- Scan time
- 4.0 s
Review note: Loads its own .env settings file, as documented; the other flags are README text and tests.
Findings (7)
credential-access: Touches credentials or secrets high
PKG-INFO:281
OWASP LLM LLM03 Supply ChainOWASP Agentic ASI03 Identity and Privilege AbuseOWASP Agentic ASI04 Agentic Supply Chain VulnerabilitiesMITRE ATLAS AML.T0055 Unsecured CredentialsMITRE ATLAS AML.T0083 Credentials from AI Agent Configuration
The default `.env` load starts at the installed `mcp_clickhouse` package directory,
What this means: Reads files or environment holding keys, tokens or sessions.
The rule's general advice: Confirm the tool needs this; otherwise do not install. (see the review note for this case)
Known false alarm
README text (PKG-INFO) explaining how the server finds its .env settings file. Documentation only.
Reviewed by Claude (AI-assisted review), 2026-11-21
exfil.combo: Reads credentials and makes network calls critical
PKG-INFO:281
OWASP LLM LLM03 Supply ChainOWASP Agentic ASI04 Agentic Supply Chain VulnerabilitiesMITRE ATLAS AML.T0037 Data from Local SystemMITRE ATLAS AML.T0055 Unsecured CredentialsMITRE ATLAS AML.T0025 Exfiltration via Cyber Means
The default `.env` load starts at the installed `mcp_clickhouse` package directory,
What this means: Credential access together with outbound requests in one file is the shape of data theft.
The rule's general advice: Do not install unless the flow is understood and benign. (see the review note for this case)
Known false alarm
README text (PKG-INFO) explaining how the server finds its .env settings file. Documentation only.
Reviewed by Claude (AI-assisted review), 2026-11-21
credential-access: Touches credentials or secrets high
mcp_clickhouse/auth.py:214
OWASP LLM LLM03 Supply ChainOWASP Agentic ASI03 Identity and Privilege AbuseOWASP Agentic ASI04 Agentic Supply Chain VulnerabilitiesMITRE ATLAS AML.T0055 Unsecured CredentialsMITRE ATLAS AML.T0083 Credentials from AI Agent Configuration
"""Find the nearest .env at or above the installed package directory."""
What this means: Reads files or environment holding keys, tokens or sessions.
The rule's general advice: Confirm the tool needs this; otherwise do not install. (see the review note for this case)
Expected for what this tool does
_find_default_dotenv walks up from the installed package folder to the first .env and loads it into the process environment for ClickHouse and auth settings, as the README says. Nothing is sent anywhere except the ClickHouse server the user configured.
Reviewed by Claude (AI-assisted review), 2026-11-21
exfil.combo: Reads credentials and makes network calls med
mcp_clickhouse/auth.py:214
OWASP LLM LLM03 Supply ChainOWASP Agentic ASI04 Agentic Supply Chain VulnerabilitiesMITRE ATLAS AML.T0037 Data from Local SystemMITRE ATLAS AML.T0055 Unsecured CredentialsMITRE ATLAS AML.T0025 Exfiltration via Cyber Means
"""Find the nearest .env at or above the installed package directory."""
What this means: Credential access together with outbound requests in one file is the shape of data theft.
The rule's general advice: Do not install unless the flow is understood and benign. (see the review note for this case)
Expected for what this tool does
_find_default_dotenv walks up from the installed package folder to the first .env and loads it into the process environment for ClickHouse and auth settings, as the README says. Nothing is sent anywhere except the ClickHouse server the user configured.
Reviewed by Claude (AI-assisted review), 2026-11-21
credential-access: Touches credentials or secrets high
tests/test_auth_config.py:258
OWASP LLM LLM03 Supply ChainOWASP Agentic ASI03 Identity and Privilege AbuseOWASP Agentic ASI04 Agentic Supply Chain VulnerabilitiesMITRE ATLAS AML.T0055 Unsecured CredentialsMITRE ATLAS AML.T0083 Credentials from AI Agent Configuration
lambda: "/package/.env",
What this means: Reads files or environment holding keys, tokens or sessions.
The rule's general advice: Confirm the tool needs this; otherwise do not install. (see the review note for this case)
Known false alarm
Unit tests that fake the .env lookup ('/package/.env') or write an empty .env into a temp folder.
Reviewed by Claude (AI-assisted review), 2026-11-21
exfil.combo: Reads credentials and makes network calls med
tests/test_auth_config.py:258
OWASP LLM LLM03 Supply ChainOWASP Agentic ASI04 Agentic Supply Chain VulnerabilitiesMITRE ATLAS AML.T0037 Data from Local SystemMITRE ATLAS AML.T0055 Unsecured CredentialsMITRE ATLAS AML.T0025 Exfiltration via Cyber Means
lambda: "/package/.env",
What this means: Credential access together with outbound requests in one file is the shape of data theft.
The rule's general advice: Do not install unless the flow is understood and benign. (see the review note for this case)
Known false alarm
Unit tests that fake the .env lookup ('/package/.env') or write an empty .env into a temp folder.
Reviewed by Claude (AI-assisted review), 2026-11-21
credential-access: Touches credentials or secrets high
tests/test_startup_contract.py:19
OWASP LLM LLM03 Supply ChainOWASP Agentic ASI03 Identity and Privilege AbuseOWASP Agentic ASI04 Agentic Supply Chain VulnerabilitiesMITRE ATLAS AML.T0055 Unsecured CredentialsMITRE ATLAS AML.T0083 Credentials from AI Agent Configuration
(source_root / ".env").write_text("")
What this means: Reads files or environment holding keys, tokens or sessions.
The rule's general advice: Confirm the tool needs this; otherwise do not install. (see the review note for this case)
Known false alarm
Unit tests that fake the .env lookup ('/package/.env') or write an empty .env into a temp folder.
Reviewed by Claude (AI-assisted review), 2026-11-21
4 low-severity notes (informational, do not affect the result)
credential-access: Touches credentials or secrets low
tests/test_chdb_tool.py:6
OWASP LLM LLM03 Supply ChainOWASP Agentic ASI03 Identity and Privilege AbuseOWASP Agentic ASI04 Agentic Supply Chain VulnerabilitiesMITRE ATLAS AML.T0055 Unsecured CredentialsMITRE ATLAS AML.T0083 Credentials from AI Agent Configuration
What this means: Reads files or environment holding keys, tokens or sessions.
What you can do: Confirm the tool needs this; otherwise do not install.
credential-access: Touches credentials or secrets low
tests/test_mcp_server.py:9
OWASP LLM LLM03 Supply ChainOWASP Agentic ASI03 Identity and Privilege AbuseOWASP Agentic ASI04 Agentic Supply Chain VulnerabilitiesMITRE ATLAS AML.T0055 Unsecured CredentialsMITRE ATLAS AML.T0083 Credentials from AI Agent Configuration
from dotenv import load_dotenv
What this means: Reads files or environment holding keys, tokens or sessions.
What you can do: Confirm the tool needs this; otherwise do not install.
credential-access: Touches credentials or secrets low
tests/test_pagination.py:3
OWASP LLM LLM03 Supply ChainOWASP Agentic ASI03 Identity and Privilege AbuseOWASP Agentic ASI04 Agentic Supply Chain VulnerabilitiesMITRE ATLAS AML.T0055 Unsecured CredentialsMITRE ATLAS AML.T0083 Credentials from AI Agent Configuration
What this means: Reads files or environment holding keys, tokens or sessions.
What you can do: Confirm the tool needs this; otherwise do not install.
credential-access: Touches credentials or secrets low
tests/test_tool.py:5
OWASP LLM LLM03 Supply ChainOWASP Agentic ASI03 Identity and Privilege AbuseOWASP Agentic ASI04 Agentic Supply Chain VulnerabilitiesMITRE ATLAS AML.T0055 Unsecured CredentialsMITRE ATLAS AML.T0083 Credentials from AI Agent Configuration
What this means: Reads files or environment holding keys, tokens or sessions.
What you can do: Confirm the tool needs this; otherwise do not install.
Dispute this result
Maintainer and think this is wrong? Open a dispute on GitHub with the target id mcp-pypi-mcp-clickhouse-4ec723.