Skills/PyPI/pg-airman-mcp

pg-airman-mcp@1.1.1

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 283Last detonated 2 h ago
$claude mcp add pg-airman-mcp -- uvx pg-airman-mcp
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, evil.com — 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 pg-airman-mcp

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/pg_airman_mcp/sql/extension_utils.py:274 · Privileged sudo command — agent may execute with elevated privileges"1. For Debian/Ubuntu: sudo apt-get install "Fix: Build commands from fixed arguments; do not interpolate untrusted strings into a shell.
AST05
HIGH
Privileged sudo commandsrc/pg_airman_mcp/sql/extension_utils.py:276 · Privileged sudo command — agent may execute with elevated privileges"2. For RHEL/CentOS: sudo yum install "Fix: Build commands from fixed arguments; do not interpolate untrusted strings into a shell.
AST05
HIGH
Privileged sudo commandsrc/pg_airman_mcp/sql/extension_utils.py:262 · Privileged sudo command — agent may execute with elevated privilegesf"2. For RHEL/CentOS: `sudo yum install "Fix: Build commands from fixed arguments; do not interpolate untrusted strings into a shell.
AST05
HIGH
Privileged sudo commandsrc/pg_airman_mcp/sql/extension_utils.py:260 · Privileged sudo command — agent may execute with elevated privilegesf"1. For Debian/Ubuntu: `sudo apt-get install "Fix: Build commands from fixed arguments; do not interpolate untrusted strings into a shell.
AST05
MEDIUM
Privileged sudo command.github/workflows/linters.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:37 · 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
LOW
Prompt injectionREADME.md:962 · 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
MEDIUM
MCP server using network transport (SSE/HTTP)src/pg_airman_mcp/server.py:1729 · MCP server using network transport (SSE/HTTP) — data sent over network"AIRMAN_MCP_SERVER_URL environment variable (e.g., http://localhost:8000)"Fix: Namespace tool names and keep tool descriptions literal; no instructions to the agent inside them.
AST04
MEDIUM
Privileged sudo command.github/workflows/tests.yml:37 · 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
LOW
URL to a private-network addresstests/unit/server/test_server_settings.py:250 · URL to a private-network address — a LAN or development targetassert settings.determine_server_url() == "http://192.168.1.10:9001"Fix: Replace encoded or assembled strings with plain literals and remove undeclared network calls.
AST07
LOW
URL to a private-network addresstests/unit/test_jwt_verifier.py:158 · URL to a private-network address — a LAN or development target"http://192.168.1.1/jwks",Fix: Replace encoded or assembled strings with plain literals and remove undeclared network calls.
AST07
LOW
URL to a private-network addresstests/unit/test_token_verifier.py:23 · URL to a private-network address — a LAN or development target"http://10.0.0.1/introspect",Fix: Replace encoded or assembled strings with plain literals and remove undeclared network calls.
AST07
MEDIUM
MCP server using network transport (SSE/HTTP)tests/unit/server/test_server_settings.py:382 · MCP server using network transport (SSE/HTTP) — data sent over network"AIRMAN_MCP_SERVER_URL": "http://resource.test",Fix: Namespace tool names and keep tool descriptions literal; no instructions to the agent inside them.
AST04
LOW
URL to a private-network addresstests/unit/server/test_server_settings.py:229 · URL to a private-network address — a LAN or development targetassert settings.determine_server_url() == "http://10.0.0.5:9000"Fix: Replace encoded or assembled strings with plain literals and remove undeclared network calls.
AST07
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
LOW
Prompt injectionREADME.md:183 · 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 permission modification commandDockerfile:42 · File permission modification command — agent changes file ownership/permissions&& chown -R app:app /appFix: Request the narrowest permission that works; replace wildcards with the exact paths or hosts.
AST05
MEDIUM
File type combined with upload actionsrc/pg_airman_mcp/top_queries/top_queries_calc.py:5 · File type combined with upload action — agent may exfiltrate local data filesfrom ..sql.extension_utils import check_extension, get_postgres_versionFix: Remove the call, or declare the host in frontmatter and explain in the README what is sent and why.
AST07
LOW
URL to a private-network addresstests/unit/test_jwt_verifier.py:156 · URL to a private-network address — a LAN or development target"http://10.0.0.1/.well-known/jwks.json",Fix: Replace encoded or assembled strings with plain literals and remove undeclared network calls.
AST07
MEDIUM
Access to sensitive file pathstests/unit/sql/test_safe_sql.py:380 · 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
MEDIUM
File type combined with upload actiontests/conftest.py:8 · File type combined with upload action — agent may exfiltrate local data filesfrom pg_airman_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
LOW
Prompt injectionREADME.md:669 · Prompt injection — known jailbreak technique reference · informational: not an instruction file| `refresh_kb` | Refresh semantic KB to sync with current schema metadata (unrestricted mode only). |Fix: Keep SKILL.md to visible, descriptive text. Remove comments and encoded text that address the agent.
AST01
LOW
URL to a private-network addresstests/unit/test_token_verifier.py:24 · URL to a private-network address — a LAN or development target"http://192.168.1.1/introspect",Fix: Replace encoded or assembled strings with plain literals and remove undeclared network calls.
AST07
MEDIUM
Access to sensitive file pathstests/unit/sql/test_safe_sql.py:379 · 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

Cost to the agent

Instructions loaded
≈46 tok
1 file · 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 pg-airman-mcp@1.1.1 as of 2 h ago. This is the package itself, not its dependencies.