io.github.YawLabs/postgres-mcp

What we checked

Six static checks, weighted by risk. Every result reflects only what could be observed in the published package and repository — never intent.

• Injection surface

  pass25% of grade

  Tool descriptions/manifest scanned for instruction-injection patterns (imperatives at the model, hidden text, 'ignore previous', data-exfil URLs).

  Scanned 172 text field(s); no instruction-injection patterns found. PASS = no static red flag. A server can serve different tool descriptions at runtime (the rug-pull class), which static scanning cannot see.

• Supply chain

  warn25% of grade

  Package provenance: namespace verification, repo linkage, maintainer count, account age, postinstall scripts, typosquat distance.

  no resolvable repository linked to the package (provenance unverifiable)

• Credential hygiene

  pass15% of grade

  How the server takes secrets (env vs plaintext config vs hardcoded); secrets appearing in tool schemas.

  No hardcoded secrets, secret-shaped tool parameters, or leaked keys found. PASS = no static red flag; static analysis cannot prove the code honors env-based secret handling at runtime.

• Permission scope

  pass15% of grade

  Declared tools vs. breadth (filesystem, network, exec); flags shell-exec and unbounded filesystem access.

  No shell-exec, unbounded/sensitive filesystem, or download-and-run primitives found in scanned source. PASS = no static red flag. Static scanning is blind to code fetched or executed at runtime.

• Version behavior

  fail10% of grade

  Diff of tool definitions between versions; new permissions or changed descriptions in a patch release (the postmark-mcp class).

  vs prior 0.12.0 (patch bump): new tool "pg_readonly" touches a sensitive surface (email/exec/net/fs); new tool "pg_query" touches a sensitive surface (email/exec/net/fs); new tool "pg_list_schemas" appeared; new tool "pg_list_tables" appeared; new tool "pg_describe_table" touches a sensitive surface (email/exec/net/fs); new tool "pg_list_views" appeared; new tool "pg_list_functions" appeared; new tool "pg_list_extensions" appeared; new tool "pg_search_columns" appeared; new tool "pg_explain" touches a sensitive surface (email/exec/net/fs); new tool "pg_index_advisor" touches a sensitive surface (email/exec/net/fs); new tool "pg_health" touches a sensitive surface (email/exec/net/fs); new tool "pg_top_queries" touches a sensitive surface (email/exec/net/fs); new tool "pg_seq_scan_tables" appeared; new tool "pg_unused_indexes" touches a sensitive surface (email/exec/net/fs); new tool "pg_io_stats" touches a sensitive surface (email/exec/net/fs); new tool "pg_inspect_locks" touches a sensitive surface (email/exec/net/fs); new tool "pg_list_roles" touches a sensitive surface (email/exec/net/fs); new tool "pg_table_privileges" touches a sensitive surface (email/exec/net/fs); new tool "pg_kill" touches a sensitive surface (email/exec/net/fs); new tool "pg_replication_status" appeared; new tool "pg_advisor" touches a sensitive surface (email/exec/net/fs); new tool "pg_table_bloat" touches a sensitive surface (email/exec/net/fs).

• Transport config

  unscannable10% of grade

  Remote servers: TLS and auth mode (none/token/OAuth). Local servers: whether the manifest indicates it phones home.

  local stdio server: no remote transport or auth surface, and no phone-home/telemetry signal found in source. Absence of transport findings is NOT a safety guarantee — phone-home hosts can be constructed at runtime and defeat static analysis.