Skills/PyPI/warehouse-mcp

warehouse-mcp@0.1.0

VERIFIED· not started

Publisher claims: "Governed, read-only MCP access to DuckDB, Postgres and BigQuery for AI agents: semantic layer, SQL guard, row policies, PII pseudonymization, audit log." Observed in sandbox: no network, touches nothing outside the project, writes no memory.

Registry PyPI (MCP server)Publisher tantn89 · publishing for 20 daysInstalls 204Last detonated 1 h ago
$claude mcp add warehouse-mcp -- uvx warehouse-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
ANTHROPIC_API_KEYWAREHOUSE_MCP_LOADER_DSNConfiguration, not credentials: WAREHOUSE_MCP_DEMO_DB, WAREHOUSE_MCP_EVAL_AUDIT, WAREHOUSE_MCP_EVAL_MODEL, WAREHOUSE_MCP_PII_SALT
Where it talks to
no vendor host named in the code
What we saw when it ran
no credential files read · no network
What we could not test
server startup · the tool list · tool behavior

Connect it with a scoped credential, under the guard. It asks for ANTHROPIC_API_KEY, WAREHOUSE_MCP_LOADER_DSN and talks to its vendor. Give the credential to the guard, not the server: the value never enters the server's environment and only travels to the host you bind. What the tools do with a real credential was not observed.

$vet-skills run --net declared -- uvx warehouse-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-21 and scored it 82/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.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
Access to sensitive file pathstests/test_sql_guard.py:106 · Access to sensitive file paths — SSH keys, AWS credentials, env files, or system files("SELECT * FROM read_csv('/etc/passwd')", "duckdb"),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 actionscripts/load_snapshot.py:91 · File type combined with upload action — agent may exfiltrate local data filessql.SQL(postgres_type(table, name, dtype)))Fix: Remove the call, or declare the host in frontmatter and explain in the README what is sent and why.
AST07
HIGH
Access to sensitive file pathsevals/baseline.json:2386 · Access to sensitive file paths — SSH keys, AWS credentials, env files, or system files… "error": null, "output": "I won't run that query. `read_csv('/etc/passwd')` reads a local system file, not warehouse data, and this tool is limited to g…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/test_sql_guard.py:113 · Access to sensitive file paths — SSH keys, AWS credentials, env files, or system files("SELECT pg_read_file('/etc/passwd') FROM edits", "postgres"),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/test_sql_guard.py:107 · Access to sensitive file paths — SSH keys, AWS credentials, env files, or system files("SELECT * FROM '/etc/passwd'", "duckdb"),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/test_red_team.py:99 · Access to sensitive file paths — SSH keys, AWS credentials, env files, or system files"pg_read_file('/etc/passwd')", "pg_ls_dir('.')", "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
Access to sensitive file pathstests/test_postgres_parity.py:198 · 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/test_red_team.py:103 · Access to sensitive file paths — SSH keys, AWS credentials, env files, or system files"pg_sleep(30)", "pg_terminate_backend(1)", "getenv('HOME')", "read_text('/etc/passwd')",Fix: Stop enumerating or reading credential locations; take secrets from a declared environment variable the user sets on purpose.
AST05
LOW
Dynamic module loadingtests/test_evaluation.py:276 · Dynamic module loading (importlib.loader.exec_module via provenance)spec.loader.exec_module(module)Fix: Put hosts, commands and strings in plain source. Decoding at runtime looks identical to malware and costs points on its own.
AST05
HIGH
Access to sensitive file pathsevals/baseline.json:2416 · Access to sensitive file paths — SSH keys, AWS credentials, env files, or system files…410, "error": null, "output": "I won't run that. `read_csv('/etc/passwd')` reads a file from the server's local filesystem, not a warehouse dataset, an…Fix: Stop enumerating or reading credential locations; take secrets from a declared environment variable the user sets on purpose.
AST05
LOW
Dynamic module loadingtests/test_evaluation.py:275 · Dynamic module loadingmodule = importlib.util.module_from_spec(spec)Fix: Put hosts, commands and strings in plain source. Decoding at runtime looks identical to malware and costs points on its own.
AST05
MEDIUM
Access to sensitive file pathstests/test_red_team.py:104 · Access to sensitive file paths — SSH keys, AWS credentials, env files, or system files"read_blob('/etc/passwd')", "glob('*')", "sleep_ms(30000)", "current_user",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/test_sql_guard.py:108 · Access to sensitive file paths — SSH keys, AWS credentials, env files, or system files("SELECT read_text('/etc/passwd') FROM edits", "duckdb"),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/test_red_team.py:84 · Access to sensitive file paths — SSH keys, AWS credentials, env files, or system files("analyst", "SELECT * FROM '/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
≈75 tok
1 file · 58 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 warehouse-mcp@0.1.0 as of 22 min ago. This is the package itself, not its dependencies.