Skills/PyPI/mcp-read-only-sql

mcp-read-only-sql@0.9.0

CAUTION· not started

Publisher claims: "MCP server for read-only SQL queries supporting PostgreSQL and ClickHouse" Observed in sandbox: no network, touches nothing outside the project, writes no memory.

Registry PyPI (MCP server)Publisher lukleh · publishing for 231 daysInstalls 544Last detonated 5d ago
What would fix thisWatchDispute verdict

Coverage

Not started: dependency install failed; the server itself was not observed.
Tested
the dependency install step · every file read, file written and host contacted by what ran
Not tested
server startup · the tool list · tool behavior

What this means for the label: Caution here covers what ran. The server's tools were not exercised with a real credential, so nothing about their behavior is asserted; the credential summary below says what to do with that.

Before you give it your token

It will ask for
no credential variables read in the code
Where it talks to
no vendor host named in the code
What the honeypot saw
no credential files read · no network
What we could not test
server startup · the tool list · tool behavior

Connect it under the guard. Not started: dependency install failed; the server itself was not observed. The code names no credential variable; the guard pins the network to what the honeypot saw and logs every call.

$vet-skills run --net declared -- uvx mcp-read-only-sql

Never paste a credential into a chat, a ticket or a report, including ours. How the guard holds it.

Is [email protected] safe to install?

KillerSkills ran it in the KillerSkills honeypot sandbox (2 scenarios; not started: dependency install failed; the server itself was not observed) on 2026-11-09 and scored it 75/100 (Caution). It is not known to be malicious, but it has behaviour or code a security policy should decide on before install. Notable findings: Access to sensitive file paths; Destructive file system command detected; Access to sensitive file paths. Summary: no network, touches nothing outside the project, writes no memory.

Behavior trace

Honeypot run · 0 s · 2 scenarios · 0 deviations
t+CategoryObserved action
0.0sprocessno install scripts in bundle
0.2sprocessdependency install exit 1 ·
0.2sclaimednot started: dependency install failed (exit 1); the server itself was not observed
0.2sprocessscript backend runs setup only
0.2sprocessno install scripts to re-run

Static findings

MEDIUM
Privileged sudo command.github/workflows/publish.yml:52 · Privileged sudo command — agent may execute with elevated privilegessudo apt-get install -y apt-transport-https ca-certificates curl gnupgFix: Build commands from fixed arguments; do not interpolate untrusted strings into a shell.
AST05
MEDIUM
Privileged sudo command.github/workflows/publish.yml:50 · Privileged sudo command — agent may execute with elevated privilegessudo apt-get install -y postgresql-clientFix: Build commands from fixed arguments; do not interpolate untrusted strings into a shell.
AST05
HIGH
Access to sensitive file pathssrc/mcp_read_only_sql/config/dbeaver_import.py:296 · Access to sensitive file paths — SSH keys, AWS credentials, env files, or system files# Keep DBeaver's default explicit: an omitted port inherits ~/.ssh/config.Fix: Stop enumerating or reading credential locations; take secrets from a declared environment variable the user sets on purpose.
AST05
HIGH
Destructive file system command detectedrun_tests.sh:161 · Destructive file system command detectedrm -f /tmp/docker_test_keyFix: Build commands from fixed arguments; do not interpolate untrusted strings into a shell.
AST05
HIGH
Access to sensitive file pathssrc/mcp_read_only_sql/config/connection.py:183 · Access to sensitive file paths — SSH keys, AWS credentials, env files, or system files# SSH default, ~/.ssh/known_hosts.Fix: Stop enumerating or reading credential locations; take secrets from a declared environment variable the user sets on purpose.
AST05
HIGH
Access to sensitive file pathssrc/mcp_read_only_sql/utils/ssh_tunnel_cli.py:34 · Access to sensitive file paths — SSH keys, AWS credentials, env files, or system filesssh resolves ``~/.ssh/config`` (including HostName and HostKeyAlias)Fix: Stop enumerating or reading credential locations; take secrets from a declared environment variable the user sets on purpose.
AST05
HIGH
Access to sensitive file pathssrc/mcp_read_only_sql/utils/ssh_tunnel_cli.py:23 · Access to sensitive file paths — SSH keys, AWS credentials, env files, or system filesDEFAULT_USER_KNOWN_HOSTS_FILES = ("~/.ssh/known_hosts", "~/.ssh/known_hosts2")Fix: Stop enumerating or reading credential locations; take secrets from a declared environment variable the user sets on purpose.
AST05
MEDIUM
Privileged sudo command.github/workflows/publish.yml:49 · Privileged sudo command — agent may execute with elevated privilegessudo apt-get updateFix: Build commands from fixed arguments; do not interpolate untrusted strings into a shell.
AST05
MEDIUM
Privileged sudo command.github/workflows/publish.yml:53 · Privileged sudo command — agent may execute with elevated privilegescurl -fsSL 'https://packages.clickhouse.com/rpm/lts/repodata/repomd.xml.key' | sudo gpg --dearmor -o /usr/share/keyrings/clickhouse-keyring.gpgFix: Build commands from fixed arguments; do not interpolate untrusted strings into a shell.
AST05
MEDIUM
Privileged sudo command.github/workflows/test.yml:61 · Privileged sudo command — agent may execute with elevated privilegescurl -fsSL 'https://packages.clickhouse.com/rpm/lts/repodata/repomd.xml.key' | sudo gpg --dearmor -o /usr/share/keyrings/clickhouse-keyring.gpgFix: Build commands from fixed arguments; do not interpolate untrusted strings into a shell.
AST05
MEDIUM
Python subprocess execution detectedtests/test_clickhouse_sql.py:226 · Python subprocess execution detectedresult = subprocess.run(Fix: Build commands from fixed arguments, never from interpolated strings; prefer an API client over shelling out.
AST05
MEDIUM
Access to sensitive file pathstests/test_config_connection.py:72 · Access to sensitive file paths — SSH keys, AWS credentials, env files, or system files"private_key": "~/.ssh/id_rsa",Fix: Stop enumerating or reading credential locations; take secrets from a declared environment variable the user sets on purpose.
AST05
MEDIUM
Privileged sudo command.github/workflows/test.yml:57 · Privileged sudo command — agent may execute with elevated privilegessudo apt-get updateFix: Build commands from fixed arguments; do not interpolate untrusted strings into a shell.
AST05
MEDIUM
File permission modification commanddocker/ssh/Dockerfile:32 · File permission modification command — agent changes file ownership/permissionschown tunnel:tunnel /home/tunnel/.ssh/*Fix: Request the narrowest permission that works; replace wildcards with the exact paths or hosts.
AST05
MEDIUM
Destructive file system command detectedtests/test_clickhouse_sql.py:128 · Destructive file system command detected"SELECT 1 AS format /* \u200b ‘x’ */",Fix: Build commands from fixed arguments; do not interpolate untrusted strings into a shell.
AST05
MEDIUM
Unicode escape sequence detectedsrc/mcp_read_only_sql/connectors/clickhouse/sql.py:21 · Unicode escape sequence detected — may contain obfuscated payloads_EXTRA_WHITESPACE = frozenset("\u180e\u200b\u200c\u200d\u2060\ufeff")Fix: Put hosts, commands and strings in plain source. Decoding at runtime looks identical to malware and costs points on its own.
AST07
MEDIUM
Privileged sudo command.github/workflows/test.yml:58 · Privileged sudo command — agent may execute with elevated privilegessudo apt-get install -y postgresql-clientFix: Build commands from fixed arguments; do not interpolate untrusted strings into a shell.
AST05
MEDIUM
Privileged sudo command.github/workflows/publish.yml:54 · Privileged sudo command — agent may execute with elevated privilegesecho "deb [signed-by=/usr/share/keyrings/clickhouse-keyring.gpg] https://packages.clickhouse.com/deb stable main" | sudo tee /etc/apt/sources.list.d/clickhouse.listFix: Build commands from fixed arguments; do not interpolate untrusted strings into a shell.
AST05
MEDIUM
File permission modification commandtests/README.md:51 · File permission modification command — agent changes file ownership/permissionsdocker cp mcp-ssh-bastion:/tmp/test_key /tmp/docker_test_key && chmod 600 /tmp/docker_test_keyFix: Request the narrowest permission that works; replace wildcards with the exact paths or hosts.
AST05
MEDIUM
Privileged sudo command.github/workflows/test.yml:60 · Privileged sudo command — agent may execute with elevated privilegessudo apt-get install -y apt-transport-https ca-certificates curl gnupgFix: Build commands from fixed arguments; do not interpolate untrusted strings into a shell.
AST05
MEDIUM
Destructive file system command detectedtests/test_clickhouse_sql.py:65 · Destructive file system command detected"SELECT 1 AS format // trailing comment\n;",Fix: Build commands from fixed arguments; do not interpolate untrusted strings into a shell.
AST05
MEDIUM
Python subprocess execution detectedtests/conftest.py:221 · Python subprocess execution detectedresult = subprocess.run(Fix: Build commands from fixed arguments, never from interpolated strings; prefer an API client over shelling out.
AST05
MEDIUM
Python subprocess execution detectedsrc/mcp_read_only_sql/utils/ssh_tunnel_cli.py:106 · Python subprocess execution detectedchecked = subprocess.run(Fix: Build commands from fixed arguments, never from interpolated strings; prefer an API client over shelling out.
AST05
MEDIUM
Destructive file system command detectedtests/test_clickhouse_sql.py:330 · Destructive file system command detected("SELECT 1 AS format // trailing comment\n;", ["format", "1"]),Fix: Build commands from fixed arguments; do not interpolate untrusted strings into a shell.
AST05
MEDIUM
File permission modification commanddocker/ssh/Dockerfile:25 · File permission modification command — agent changes file ownership/permissionschown -R tunnel:tunnel /home/tunnel/.ssh && \Fix: Request the narrowest permission that works; replace wildcards with the exact paths or hosts.
AST05
MEDIUM
Python subprocess execution detectedtests/conftest.py:239 · Python subprocess execution detectedresult = subprocess.run(Fix: Build commands from fixed arguments, never from interpolated strings; prefer an API client over shelling out.
AST05
MEDIUM
File permission modification commanddocker/ssh/Dockerfile:31 · File permission modification command — agent changes file ownership/permissionschmod 600 /home/tunnel/.ssh/authorized_keys && \Fix: Request the narrowest permission that works; replace wildcards with the exact paths or hosts.
AST05
MEDIUM
Python subprocess execution detectedsrc/mcp_read_only_sql/config/dbeaver_import.py:95 · Python subprocess execution detectedresult = subprocess.run(cmd, capture_output=True, check=False)Fix: Build commands from fixed arguments, never from interpolated strings; prefer an API client over shelling out.
AST05
MEDIUM
Python subprocess execution detectedsrc/mcp_read_only_sql/cli_binaries.py:77 · Python subprocess execution detectedresult = subprocess.run(Fix: Build commands from fixed arguments, never from interpolated strings; prefer an API client over shelling out.
AST05
MEDIUM
Destructive file system command detectedtests/test_clickhouse_sql.py:56 · Destructive file system command detected"SELECT 1 /* FORMAT /* JSON */ inner */", "SELECT 1 # FORMAT JSON\n",Fix: Build commands from fixed arguments; do not interpolate untrusted strings into a shell.
AST05
MEDIUM
Destructive file system command detectedtests/test_clickhouse_sql.py:22 · Destructive file system command detected"SELECT 1 FORMAT JSON", "SELECT 1 format /* comment */ JSON;",Fix: Build commands from fixed arguments; do not interpolate untrusted strings into a shell.
AST05
MEDIUM
References a credential file in the home directorytests/test_config_connection.py:188 · References a credential file in the home directory"private_key": "~/.ssh/id_rsa",Fix: Stop enumerating or reading credential locations; take secrets from a declared environment variable the user sets on purpose.
AST03
MEDIUM
File permission modification commanddocker/ssh/Dockerfile:26 · File permission modification command — agent changes file ownership/permissionschmod 700 /home/tunnel/.sshFix: Request the narrowest permission that works; replace wildcards with the exact paths or hosts.
AST05
MEDIUM
File type combined with upload actionAGENTS.md:21 · File type combined with upload action — agent may exfiltrate local data files…ils with a connection error. `just test` emits JUnit XML at `test-results/pytest.xml` for CI uploads. ## Commit & Pull Request Guidelines Recent commits favour imperative, concis…Fix: Remove the call, or declare the host in frontmatter and explain in the README what is sent and why.
AST07
MEDIUM
Python subprocess execution detectedsrc/mcp_read_only_sql/utils/ssh_tunnel_cli.py:40 · Python subprocess execution detectedresolved = subprocess.run(Fix: Build commands from fixed arguments, never from interpolated strings; prefer an API client over shelling out.
AST05
MEDIUM
Access to sensitive file pathstests/test_config_connection.py:106 · Access to sensitive file paths — SSH keys, AWS credentials, env files, or system files{"user": "tunneluser", "private_key": "~/.ssh/id_rsa"}Fix: Stop enumerating or reading credential locations; take secrets from a declared environment variable the user sets on purpose.
AST05
MEDIUM
References a credential file in the home directorytests/test_config_connection.py:142 · References a credential file in the home directory"private_key": "~/.ssh/id_rsa",Fix: Stop enumerating or reading credential locations; take secrets from a declared environment variable the user sets on purpose.
AST03
MEDIUM
File permission modification commandrun_tests.sh:132 · File permission modification command — agent changes file ownership/permissionschmod 600 /tmp/docker_test_keyFix: Request the narrowest permission that works; replace wildcards with the exact paths or hosts.
AST05
MEDIUM
Python subprocess execution detectedsrc/mcp_read_only_sql/utils/ssh_tunnel_cli.py:79 · Python subprocess execution detectedfound = subprocess.run(Fix: Build commands from fixed arguments, never from interpolated strings; prefer an API client over shelling out.
AST05
MEDIUM
References a credential file in the home directorytests/test_config_connection.py:72 · References a credential file in the home directory"private_key": "~/.ssh/id_rsa",Fix: Stop enumerating or reading credential locations; take secrets from a declared environment variable the user sets on purpose.
AST03
MEDIUM
Access to sensitive file pathstests/test_config_connection.py:142 · Access to sensitive file paths — SSH keys, AWS credentials, env files, or system files"private_key": "~/.ssh/id_rsa",Fix: Stop enumerating or reading credential locations; take secrets from a declared environment variable the user sets on purpose.
AST05
MEDIUM
Privileged sudo command.github/workflows/test.yml:62 · Privileged sudo command — agent may execute with elevated privilegesecho "deb [signed-by=/usr/share/keyrings/clickhouse-keyring.gpg] https://packages.clickhouse.com/deb stable main" | sudo tee /etc/apt/sources.list.d/clickhouse.listFix: Build commands from fixed arguments; do not interpolate untrusted strings into a shell.
AST05
MEDIUM
References a credential file in the home directorytests/test_config_connection.py:106 · References a credential file in the home directory{"user": "tunneluser", "private_key": "~/.ssh/id_rsa"}Fix: Stop enumerating or reading credential locations; take secrets from a declared environment variable the user sets on purpose.
AST03
MEDIUM
File permission modification commanddocker/ssh/Dockerfile:36 · File permission modification command — agent changes file ownership/permissionschmod 644 /tmp/test_keyFix: Request the narrowest permission that works; replace wildcards with the exact paths or hosts.
AST05
MEDIUM
File type combined with upload actiontests/test_dbeaver_import.py:641 · File type combined with upload action — agent may exfiltrate local data files_run_import(monkeypatch, [str(workspace), "--only", "prod.db", "--output", str(output)])Fix: Remove the call, or declare the host in frontmatter and explain in the README what is sent and why.
AST07
MEDIUM
Process kill commandtests/test_ssh_host_keys.py:508 · Process kill command — agent can terminate processes">> /etc/ssh/sshd_config; kill -HUP 1"Fix: Build commands from fixed arguments; do not interpolate untrusted strings into a shell.
AST05
MEDIUM
Python subprocess execution detectedtests/test_ssh_host_keys.py:447 · Python subprocess execution detectedscan = subprocess.run(Fix: Build commands from fixed arguments, never from interpolated strings; prefer an API client over shelling out.
AST05
MEDIUM
Python subprocess execution detectedtests/test_ssh_host_keys.py:475 · Python subprocess execution detectedlog = subprocess.run(Fix: Build commands from fixed arguments, never from interpolated strings; prefer an API client over shelling out.
AST05
MEDIUM
Access to sensitive file pathstests/test_ssh_host_keys.py:335 · Access to sensitive file paths — SSH keys, AWS credentials, env files, or system filesf'"{os.path.expanduser("~/.ssh/known_hosts")}" 'Fix: Stop enumerating or reading credential locations; take secrets from a declared environment variable the user sets on purpose.
AST05
MEDIUM
Python subprocess execution detectedtests/test_ssh_host_keys.py:115 · Python subprocess execution detectedsubprocess.run(["ssh-keygen", "-q", "-H", "-f", str(path)], check=True)Fix: Build commands from fixed arguments, never from interpolated strings; prefer an API client over shelling out.
AST05
MEDIUM
Access to sensitive file pathstests/test_ssh_host_keys.py:70 · Access to sensitive file paths — SSH keys, AWS credentials, env files, or system filesconfig = _config(known_hosts_file="~/.ssh/bastions")Fix: Stop enumerating or reading credential locations; take secrets from a declared environment variable the user sets on purpose.
AST05
MEDIUM
Python subprocess execution detectedtests/test_ssh_host_keys.py:49 · Python subprocess execution detectedsubprocess.run(["ssh-keygen", "-q", "-t", "ed25519", "-N", "", "-f", str(path)], check=True)Fix: Build commands from fixed arguments, never from interpolated strings; prefer an API client over shelling out.
AST05
MEDIUM
Process kill commandtests/test_process_cleanup.py:68 · Process kill command — agent can terminate processes# Verify that kill was called on the processFix: Build commands from fixed arguments; do not interpolate untrusted strings into a shell.
AST05
MEDIUM
Access to sensitive file pathstests/test_ssh_host_keys.py:71 · Access to sensitive file paths — SSH keys, AWS credentials, env files, or system filesassert config.known_hosts_file == os.path.expanduser("~/.ssh/bastions")Fix: Stop enumerating or reading credential locations; take secrets from a declared environment variable the user sets on purpose.
AST05
MEDIUM
Process kill commandtests/test_process_cleanup.py:35 · Process kill command — agent can terminate processesmock_process.kill = MagicMock()Fix: Build commands from fixed arguments; do not interpolate untrusted strings into a shell.
AST05
MEDIUM
Access to sensitive file pathstests/test_config_connection.py:188 · Access to sensitive file paths — SSH keys, AWS credentials, env files, or system files"private_key": "~/.ssh/id_rsa",Fix: Stop enumerating or reading credential locations; take secrets from a declared environment variable the user sets on purpose.
AST05
MEDIUM
Process kill commandtests/test_process_cleanup.py:94 · Process kill command — agent can terminate processesmock_process.kill = MagicMock()Fix: Build commands from fixed arguments; do not interpolate untrusted strings into a shell.
AST05
MEDIUM
Access to sensitive file pathstests/test_ssh_host_keys.py:336 · Access to sensitive file paths — SSH keys, AWS credentials, env files, or system filesf'"{os.path.expanduser("~/.ssh/known_hosts2")}"'Fix: Stop enumerating or reading credential locations; take secrets from a declared environment variable the user sets on purpose.
AST05
MEDIUM
Python subprocess execution detectedtests/test_ssh_host_keys.py:464 · Python subprocess execution detectedfound = subprocess.run(Fix: Build commands from fixed arguments, never from interpolated strings; prefer an API client over shelling out.
AST05

Cost to the agent

Instructions loaded
≈962 tok
2 files · 81 in bundle
Tool list per prompt
≈0 tok
0 tools · 0 per tool
Handshake
no reply
launch to tools/list, stdio
Undocumented tools
0
description under 20 chars · avg 0

Tokens estimated at four characters each. The tool list is re-read by the agent on every turn, so it is the number to compare between servers that do the same job: ranked across the index.

Known vulnerabilities

No advisories in OSV for mcp-read-only-sql@0.9.0 as of 5d ago. This is the package itself, not its dependencies.

What would make this Verified

5 points to 80 · weights: behavior 45%, static 25%, prompt 15%, publisher 15%
  1. Unclaimed publisher≈ +8 on the totalClaim lukleh: a verified publisher gets +50 on publisher trust. It is free and usually instant with GitHub sign-in.
  2. Access to sensitive file paths≈ +4 on the totalStop enumerating or reading credential locations; take secrets from a declared environment variable the user sets on purpose.
  3. Destructive file system command detected≈ +4 on the totalBuild commands from fixed arguments; do not interpolate untrusted strings into a shell.
  4. Privileged sudo command≈ +2 on the totalBuild commands from fixed arguments; do not interpolate untrusted strings into a shell.
  5. Python subprocess execution detected≈ +2 on the totalBuild commands from fixed arguments, never from interpolated strings; prefer an API client over shelling out.
  6. File permission modification command≈ +2 on the totalRequest the narrowest permission that works; replace wildcards with the exact paths or hosts.
Publish a new version to PyPI, then queue it here. Not your skill? Claim the handle to get verdict changes by email.Claim luklehPropose a patch to the maintainer