Skills/PyPI/postgres-mcp-jacob

postgres-mcp-jacob@0.3.4

VERIFIED· not started

Publisher claims: "PostgreSQL Tuning and Analysis Tool" Observed in sandbox: no network, touches nothing outside the project, writes no memory.

Registry PyPI (MCP server)Publisher johann-schleier-smith-jssmith · publishing for 579 daysInstalls 201Last detonated 27 min ago
$claude mcp add postgres-mcp-jacob -- uvx postgres-mcp-jacob
WatchReport an issue

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: Verified 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 codeAlso psycopg.org, postgresql.org — not the publisher's domain; check what for before connecting.
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 postgres-mcp-jacob

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-14 and scored it 81/100 (Verified). In what ran, nothing we could detect went wrong: no undeclared network egress, no credential reads, no persistent instruction writes. What it does with a real credential was not observed; the static findings and the publisher carry the rest of the score. 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.1sprocessdependency install exit 1 ·
0.1sclaimednot 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

HIGH
Privileged sudo commandsrc/postgres_mcp/sql/extension_utils.py:232 · Privileged sudo command — agent may execute with elevated privilegesf"2. For RHEL/CentOS: `sudo yum install postgresql{major_version_str}-hypopg`\n"Fix: Build commands from fixed arguments; do not interpolate untrusted strings into a shell.
AST05
HIGH
Privileged sudo commandsrc/postgres_mcp/sql/extension_utils.py:231 · Privileged sudo command — agent may execute with elevated privilegesf"1. For Debian/Ubuntu: `sudo apt-get install postgresql-{major_version_str}-hypopg`\n"Fix: Build commands from fixed arguments; do not interpolate untrusted strings into a shell.
AST05
HIGH
Privileged sudo commandsrc/postgres_mcp/sql/extension_utils.py:241 · Privileged sudo command — agent may execute with elevated privilegesf"1. For Debian/Ubuntu: sudo apt-get install postgresql-{major_version_str}-hypopg\n"Fix: Build commands from fixed arguments; do not interpolate untrusted strings into a shell.
AST05
HIGH
Privileged sudo commandsrc/postgres_mcp/sql/extension_utils.py:242 · Privileged sudo command — agent may execute with elevated privilegesf"2. For RHEL/CentOS: sudo yum install postgresql{major_version_str}-hypopg\n"Fix: Build commands from fixed arguments; do not interpolate untrusted strings into a shell.
AST05
MEDIUM
Destructive file system command detectedDockerfile:50 · Destructive file system command detected&& rm -rf /var/lib/apt/lists/*Fix: Build commands from fixed arguments; do not interpolate untrusted strings into a shell.
AST05
MEDIUM
Privileged sudo command.github/workflows/build.yml:28 · Privileged sudo command — agent may execute with elevated privilegesrun: sudo service docker start || trueFix: Build commands from fixed arguments; do not interpolate untrusted strings into a shell.
AST05
MEDIUM
Destructive file system command detectedDockerfile:15 · Destructive file system command detected&& rm -rf /var/lib/apt/lists/*Fix: Build commands from fixed arguments; do not interpolate untrusted strings into a shell.
AST05
MEDIUM
File permission modification commandDockerfile:53 · File permission modification command — agent changes file ownership/permissionsRUN chmod +x /app/docker-entrypoint.shFix: Request the narrowest permission that works; replace wildcards with the exact paths or hosts.
AST05
LOW
Prompt injectionREADME.md:614 · Prompt injection — known jailbreak technique reference · informational: not an instruction fileUnrestricted mode aligns with the approach of [Cursor's auto-run mode](https://docs.cursor.com/chat/tools#auto-run), where the AI agent operates with limited human oversight or approvals.Fix: Keep SKILL.md to visible, descriptive text. Remove comments and encoded text that address the agent.
AST01
LOW
Prompt injectionREADME.md:224 · Prompt injection — known jailbreak technique reference · informational: not an instruction file- **Unrestricted Mode**: Allows full read/write access to modify data and schema. It is suitable for development environments.Fix: Keep SKILL.md to visible, descriptive text. Remove comments and encoded text that address the agent.
AST01
MEDIUM
File type combined with upload actiontests/conftest.py:8 · File type combined with upload action — agent may exfiltrate local data filesfrom postgres_mcp.sql import reset_postgres_version_cacheFix: Remove the call, or declare the host in frontmatter and explain in the README what is sent and why.
AST07
MEDIUM
File type combined with upload actionsrc/postgres_mcp/explain/explain_plan.py:16 · File type combined with upload action — agent may exfiltrate local data filesfrom ..sql import check_postgres_version_requirementFix: Remove the call, or declare the host in frontmatter and explain in the README what is sent and why.
AST07
MEDIUM
File type combined with upload actionsrc/postgres_mcp/top_queries/top_queries_calc.py:11 · File type combined with upload action — agent may exfiltrate local data filesfrom ..sql.extension_utils import get_postgres_versionFix: Remove the call, or declare the host in frontmatter and explain in the README what is sent and why.
AST07
MEDIUM
Access to sensitive file pathstests/unit/sql/test_safe_sql.py:365 · Access to sensitive file paths — SSH keys, AWS credentials, env files, or system files"SELECT pg_read_file('/etc/passwd');",Fix: Stop enumerating or reading credential locations; take secrets from a declared environment variable the user sets on purpose.
AST05
MEDIUM
Access to sensitive file pathstests/unit/sql/test_safe_sql.py:366 · Access to sensitive file paths — SSH keys, AWS credentials, env files, or system files"SELECT lo_import('/etc/passwd');",Fix: Stop enumerating or reading credential locations; take secrets from a declared environment variable the user sets on purpose.
AST05

Cost to the agent

Instructions loaded
≈48 tok
1 file · 65 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 postgres-mcp-jacob@0.3.4 as of 4 min ago. This is the package itself, not its dependencies.