pgplex/pgconsole vmain@a7fead0

14F

Security Trust Score

Grade F · Serious issues

Tier 1 · Public sourceHigh confidence · 98%rubric 2.8.1

Declared MCP capabilities

ResourcesPrompts

This server scored F. Run it behind runtime policy enforcement so one bad tool call can't become an incident.

2 issues capping this score

criticalNo command-injection sinks — 3 occurrences
highTool descriptions free of injection markers — 1 marker(s) across 1 tool(s)

Reputation140stars9forks1open issues37d agolast commit<1yage

Security controls

Deterministic, evidence-backed. Score earned from passing controls; a failed guard caps it.

Model–MCP Runtime Guardrails

Fail
Indirect Prompt Injection (IPI) Defensesguard1 marker(s) across 1 tool(s)
Tool/prompt/resource text is free of hidden instructions that could hijack the agent. How many servers fail this?
list_connections — exfiltration directive
Fix: Remove hidden directives, HTML/comment instructions, and override phrasing from descriptions.
Pass
Strict JSON Schema EnforcementadditionalProperties:false present
Tool inputs are constrained (additionalProperties:false), so unexpected arguments can't be smuggled in.
Pass
User-in-the-Loop / Approval Scopeguardno destructive tool scope
No over-broad or destructive tools (arbitrary shell, bulk-delete) that warrant human approval.
N/A
Tool Definition Integrityguardno prior version to diff
Every consecutive version pair is diffed for new injection markers or destructive scope — a risky diff anywhere in history is a rug-pull (fail, durable); benign description drift warns.

Application Security Checks

Fail
No command-injection sinksguard3 occurrences
Untrusted tool input reaching a shell yields remote code execution. How many servers fail this?
server/lib/config.ts:366src/components/sql-editor/pg-autocomplete.ts:266src/components/sql-editor/pg-autocomplete.ts:272
Fix: Never pass tool arguments to a shell; use argv arrays with shell disabled.
Warn
No path traversalguard28 occurrences
Naive path checks let tools read/write outside intended directories (EscapeRoute-class).
server/index.ts:62server/index.ts:63server/index.ts:64server/index.ts:65
Fix: Resolve to a canonical path and verify containment; reject ../ and symlinks.
Warn
No SSRF sinksguard4 occurrences
Fetching tool-supplied URLs can pivot into internal networks and metadata services.
server/lib/oauth/keycloak.ts:57server/lib/oauth/keycloak.ts:73server/lib/oauth/okta.ts:57server/lib/oauth/okta.ts:73
Fix: Allow-list destinations; reject arbitrary/loopback/link-local URLs.
Warn
No known-vulnerable dependencies30 of 731 runtime deps vulnerable; worst critical
Runtime dependencies (parsed from the lockfile) are scanned against OSV.dev for published CVEs. Advisory: flagged dependencies lower the score but don't hard-cap it, since transitive reachability is unproven.
[email protected] — GHSA-v3rj-xjv7-4jmq@babel/[email protected] — GHSA-4x5r-pxfx-6jf8@hono/[email protected] — GHSA-frvp-7c67-39w9@protobufjs/[email protected] — GHSA-q6x5-8v7m-xcrf
Fix: Upgrade the flagged dependencies past their fixed versions.
Warn
Has a security policyno security policy
A SECURITY.md gives a private path to report vulnerabilities.
Fix: Add SECURITY.md with a disclosure contact and process.
Pass
No dynamic code executionguardno sinks found
eval()/exec()/Function() on tool-derived strings allows arbitrary code execution.
Pass
No unsafe deserializationguardno sinks found
pickle/yaml.load/etc. on untrusted data can execute code.
Pass
No committed secretsguardno secrets found
Hardcoded keys/tokens in published source are live credentials an attacker can use.
Pass
Credentials sourced from environmentreads credentials from environment
Reading secrets from env/secret stores avoids hardcoding them.
Pass
Dependencies pinned (lockfile)lockfile present
A lockfile makes installs reproducible and resistant to silent dependency swaps.
Pass
Actively maintainedrecent commits
Unmaintained servers don't receive security fixes.
Pass
Repository not archivedguardactive
Archived repositories will never be patched.
Pass
Declares a licenseApache-2.0
A clear license is required for legal enterprise use.
Pass
Adoption & popularityestablished adoption
A small, capped nudge from stars/downloads — widely-used servers get more eyes on bugs. It can never offset a real security failure.
Not checked
Signed releasesnot evaluated
Signed releases let consumers verify artifacts weren't tampered with.
N/A
No install/post-install scriptsguardno published package
install hooks run arbitrary code on every consumer at install time.
N/A
Package name not typosquattingguardno published package
Names mimicking popular packages are a common malware delivery vector.
N/A
Published with provenanceno published package
Build provenance attests the artifact was built from the claimed source by CI.
N/A
Established maintainerno published package
Brand-new / single anonymous maintainers raise takeover and malware risk.

Transport & Trust Model

Pass
Execution Sandboxingcontainerized
A container/sandbox image limits blast radius; a server that runs natively has full host access.
Pass
Network Exposureno bind-all detected
Binding 0.0.0.0 or exposing debug inspectors widens the attack surface.
N/A
Transport Encryption (TLS)guardno remote endpoints
Plaintext HTTP exposes traffic and bearer tokens to interception.
N/A
IAM / Authentication Scopingno remote endpoints
OAuth 2.1 / Protected Resource Metadata gates who can invoke tools.
N/A
Live Endpoint Reachablenot dynamically scanned
A dynamic scan connected to the declared remote endpoint and it responded — verified live, not a dead URL.
N/A
Authentication Enforced (live)not dynamically scanned
If the server declares auth is required, it must actually reject anonymous clients. Serving tools to unauthenticated callers is a real exposure.

Tools (7)

queryrun_ddlwrite_datalist_objectsexplain_querydescribe_tablelist_connections