# io.github.sparta2025/postgres-mcp

> PostgreSQL MCP server with 15 tools (SQL, EXPLAIN, health, indexes) plus a Gradio UI with LLM chat.

- name: io.github.sparta2025/postgres-mcp
- version: 0.4.2
- connection class: L0 (run_local_package)
- trust: 87/100
- quality: –/100 (not scored)
- owner: not claimed
- descriptor: https://api.protogrid.dev/v1/servers/io.github.sparta2025%2Fpostgres-mcp
- tools: https://api.protogrid.dev/v1/servers/io.github.sparta2025%2Fpostgres-mcp/tools

**Runs on your machine: something must execute the package.** Only local packages are published (npm, PyPI, OCI, …). The registry never executes them, so tools are unknown until you run it.

## Connection (mcpServers)

```json
{
  "mcpServers": {
    "postgres-mcp": {
      "command": "uvx",
      "args": [
        "postgres-mcp-pro==0.4.2"
      ],
      "env": {
        "DATABASE_URL": "${DATABASE_URL}"
      }
    }
  }
}
```

Placeholders to fill: `${DATABASE_URL}`.

## Trust

- hygiene: 100
- liveness: n/a
- freshness: 85
- provenance: 80
- drivers: +repository +namespace-matches-repo ~liveness-unmeasured ~updated-60d-ago
- Derived from observable signals (official registry feed and our own credential-free probes); no code audit performed.

## Quality –/100 (not scored)

Not scored: fewer than three checks apply, usually because no remote answered a credential-free probe or the server is a local package.

### protocol: n/a (weight 25)

- n/a `protocol.modern`, `protocol.stateless`, `protocol.transport`, `protocol.list_ttl`: no remote answered a protocol handshake (not probed yet, unreachable, or local-only)

### authorization: n/a (weight 15)

- n/a `auth.prm`, `auth.as_metadata`, `auth.cimd`: no remote uses OAuth
- n/a `auth.secret_in_url`: no templated URL

### tool hygiene: n/a (weight 30)

- n/a `tools.descriptions`, `tools.description_length`, `tools.schemas`, `tools.annotations`, `tools.directory_hints`, `tools.token_cost`, `tools.api_dump`: tool list unknown (behind auth, not probed, or empty)

### stability: n/a (weight 15)

- n/a `stability.changes`, `stability.rug_pull`: tool list unknown

### dependencies: 67 (weight 15)

- fail `deps.known_vulns`: 21 advisories to act on (malicious, or rated high or critical with a fix available): GHSA-2g87-pp6c-29x5 in aiohttp@3.14.3 (indirect, fixed in 3.14.4), GHSA-5wr8-gcqf-gqf3 in aiohttp@3.14.3 (indirect, fixed in 3.14.4), GHSA-39mp-8hj3-5c49 in gradio@5.50.0 (direct, fixed in 6.7.0), ...; 12 more of lower severity or without a fix
- pass `deps.mcp_sdk_version`: mcp 1.30.0, no known advisory
- pass `deps.resolvable`: postgres-mcp-pro@0.4.2 resolved: 97 packages

- tools: unknown
- badge: [![protogrid quality](https://protogrid.dev/badge/io.github.sparta2025/postgres-mcp.svg)](https://protogrid.dev/servers/io.github.sparta2025/postgres-mcp)
- Checks run on what our credential-free, read-only probes observe; tools are never called and no code audit is performed.

### Tool changes

_No tool definition changes recorded._

## Dependencies

- pypi postgres-mcp-pro@0.4.2: resolved, 96 dependencies, MCP SDK mcp 1.30.0
  - GHSA-2g87-pp6c-29x5 (high) in `` aiohttp@3.14.3 ``, indirect, fixed in `` 3.14.4 ``, advisory summary: "aiohttp: Multiple instances of excessive or unbounded memory/CPU use" https://osv.dev/vulnerability/GHSA-2g87-pp6c-29x5
  - GHSA-5wr8-gcqf-gqf3 (high) in `` aiohttp@3.14.3 ``, indirect, fixed in `` 3.14.4 ``, advisory summary: "aiohttp server lacks an initial request/header timeout" https://osv.dev/vulnerability/GHSA-5wr8-gcqf-gqf3
  - GHSA-39mp-8hj3-5c49 (high) in `` gradio@5.50.0 ``, direct, fixed in `` 6.7.0 ``, advisory summary: "Gradio is Vulnerable to Absolute Path Traversal on Windows with Python 3.13+" https://osv.dev/vulnerability/GHSA-39mp-8hj3-5c49
  - GHSA-7hp7-4p35-3cx2 (high) in `` gradio@5.50.0 ``, direct, fixed in `` 6.15.0 ``, advisory summary: "Gradio contains a cookie injection vulnerability" https://osv.dev/vulnerability/GHSA-7hp7-4p35-3cx2
  - GHSA-j36p-7w88-g82j (high) in `` gradio@5.50.0 ``, direct, fixed in `` 6.16.0 ``, advisory summary: "Gradio FileExplorer preprocess path traversal allows files outside root\_dir to reach callbacks" https://osv.dev/vulnerability/GHSA-j36p-7w88-g82j
  - GHSA-jmh7-g254-2cq9 (high) in `` gradio@5.50.0 ``, direct, fixed in `` 6.6.0 ``, advisory summary: "Gradio has SSRF via Malicious \`proxy\_url\` Injection in \`gr.load()\` Config Processing" https://osv.dev/vulnerability/GHSA-jmh7-g254-2cq9
  - GHSA-45hq-cxwh-f6vc (high) in `` pillow@11.3.0 ``, indirect, fixed in `` 12.3.0 ``, advisory summary: "Pillow \`BdfFontFile\`: \`Image.new()\` called without \`\_decompression\_bomb\_check()\` — bomb protection bypass via font loading" https://osv.dev/vulnerability/GHSA-45hq-cxwh-f6vc
  - GHSA-5x94-69rx-g8h2 (high) in `` pillow@11.3.0 ``, indirect, fixed in `` 12.3.0 ``, advisory summary: "Pillow: \`FontFile.compile()\`: \`Image.new()\` called without \`\_decompression\_bomb\_check()\`" https://osv.dev/vulnerability/GHSA-5x94-69rx-g8h2
  - GHSA-62p4-gmf7-7g93 (high) in `` pillow@11.3.0 ``, indirect, fixed in `` 12.3.0 ``, advisory summary: "Pillow: Out-of-bounds read via attacker-controlled row stride on Pillow's mmap path (McIdas AREA files)" https://osv.dev/vulnerability/GHSA-62p4-gmf7-7g93
  - GHSA-6r8x-57c9-28j4 (high) in `` pillow@11.3.0 ``, indirect, fixed in `` 12.3.0 ``, advisory summary: "Pillow: Heap out-of-bounds write \`Image.paste()\` / \`Image.crop()\` via signed coordinate overflow" https://osv.dev/vulnerability/GHSA-6r8x-57c9-28j4
  - GHSA-8v84-f9pq-wr9x (high) in `` pillow@11.3.0 ``, indirect, fixed in `` 12.3.0 ``, advisory summary: "Pillow \`PcfFontFile.\_load\_bitmaps()\`: \`Image.frombytes()\` called without \`\_decompression\_bomb\_check()\` — bomb protection bypass via PCF font loading" https://osv.dev/vulnerability/GHSA-8v84-f9pq-wr9x
  - GHSA-9hw9-ch79-4vh6 (high) in `` pillow@11.3.0 ``, indirect, fixed in `` 12.3.0 ``, advisory summary: "Pillow: Controlled heap out-of-bounds write in Pillow \`ImageCmsTransform.apply()\` via output mode mismatch" https://osv.dev/vulnerability/GHSA-9hw9-ch79-4vh6
  - GHSA-cfh3-3jmp-rvhc (high) in `` pillow@11.3.0 ``, indirect, fixed in `` 12.1.1 ``, advisory summary: "Pillow affected by out-of-bounds write when loading PSD images" https://osv.dev/vulnerability/GHSA-cfh3-3jmp-rvhc
  - GHSA-jjj6-mw9f-p565 (high) in `` pillow@11.3.0 ``, indirect, fixed in `` 12.3.0 ``, advisory summary: "Pillow: Decompression Bomb DoS via PdfParser.PdfStream.decode()" https://osv.dev/vulnerability/GHSA-jjj6-mw9f-p565
  - GHSA-phj9-mv4w-65pm (high) in `` pillow@11.3.0 ``, indirect, fixed in `` 12.3.0 ``, advisory summary: "Pillow \`GdImageFile.\_open()\`: image dimensions accepted without \`\_decompression\_bomb\_check()\`" https://osv.dev/vulnerability/GHSA-phj9-mv4w-65pm
  - GHSA-pwv6-vv43-88gr (high) in `` pillow@11.3.0 ``, indirect, fixed in `` 12.2.0 ``, advisory summary: "Pillow has an OOB Write with Invalid PSD Tile Extents (Integer Overflow)" https://osv.dev/vulnerability/GHSA-pwv6-vv43-88gr
  - GHSA-vjc4-5qp5-m44j (high) in `` pillow@11.3.0 ``, indirect, fixed in `` 12.3.0 ``, advisory summary: "Pillow JPEG2000 tiled decode retains a growing scratch buffer and can be used for denial of service" https://osv.dev/vulnerability/GHSA-vjc4-5qp5-m44j
  - GHSA-whj4-6x5x-4v2j (high) in `` pillow@11.3.0 ``, indirect, fixed in `` 12.2.0 ``, advisory summary: "FITS GZIP decompression bomb in Pillow" https://osv.dev/vulnerability/GHSA-whj4-6x5x-4v2j
  - GHSA-xj96-63gp-2gmr (high) in `` pillow@11.3.0 ``, indirect, fixed in `` 12.3.0 ``, advisory summary: "Pillow: Heap out-of-bounds write in \`ImageFilter.RankFilter\` via integer overflow in \`ImagingExpand\`" https://osv.dev/vulnerability/GHSA-xj96-63gp-2gmr
  - GHSA-82w8-qh3p-5jfq (high) in `` starlette@0.52.1 ``, indirect, fixed in `` 1.3.1 ``, advisory summary: "Starlette: request.form() limits silently ignored for application/x-www-form-urlencoded enable DoS" https://osv.dev/vulnerability/GHSA-82w8-qh3p-5jfq
  - GHSA-wqp7-x3pw-xc5r (high) in `` starlette@0.52.1 ``, indirect, fixed in `` 1.1.0 ``, advisory summary: "Starlette: SSRF and NTLM credential theft via UNC paths in StaticFiles on Windows" https://osv.dev/vulnerability/GHSA-wqp7-x3pw-xc5r
  - GHSA-pfjf-5gxr-995x (moderate) in `` gradio@5.50.0 ``, direct, fixed in `` 6.6.0 ``, advisory summary: "Gradio has an Open Redirect in its OAuth Flow" https://osv.dev/vulnerability/GHSA-pfjf-5gxr-995x
  - GHSA-4x4j-2g7c-83w6 (moderate) in `` pillow@11.3.0 ``, indirect, fixed in `` 12.3.0 ``, advisory summary: "Pillow: WindowsViewer.get\_command() OS command injection via unescaped shell path" https://osv.dev/vulnerability/GHSA-4x4j-2g7c-83w6
  - GHSA-5xmw-vc9v-4wf2 (moderate) in `` pillow@11.3.0 ``, indirect, fixed in `` 12.2.0 ``, advisory summary: "Pillow has a heap buffer overflow with nested list coordinates" https://osv.dev/vulnerability/GHSA-5xmw-vc9v-4wf2
  - GHSA-fj7v-r99m-22gq (moderate) in `` pillow@11.3.0 ``, indirect, fixed in `` 12.3.0 ``, advisory summary: "Pillow TGA RLE encoder can serialize up to ~57 KB of adjacent heap data into generated images" https://osv.dev/vulnerability/GHSA-fj7v-r99m-22gq
  - GHSA-r73j-pqj5-w3x7 (moderate) in `` pillow@11.3.0 ``, indirect, fixed in `` 12.2.0 ``, advisory summary: "Pillow has a PDF Parsing Trailer Infinite Loop (DoS)" https://osv.dev/vulnerability/GHSA-r73j-pqj5-w3x7
  - GHSA-wjx4-4jcj-g98j (moderate) in `` pillow@11.3.0 ``, indirect, fixed in `` 12.2.0 ``, advisory summary: "Pillow has an integer overflow when processing fonts" https://osv.dev/vulnerability/GHSA-wjx4-4jcj-g98j
  - GHSA-86qp-5c8j-p5mr (moderate) in `` starlette@0.52.1 ``, indirect, fixed in `` 1.0.1 ``, advisory summary: "Starlette has missing Host header validation that poisons request.url.path, bypassing path-based security checks" https://osv.dev/vulnerability/GHSA-86qp-5c8j-p5mr
  - GHSA-x746-7m8f-x49c (moderate) in `` starlette@0.52.1 ``, indirect, fixed in `` 1.1.0 ``, advisory summary: "Starlette: Arbitrary HTTP method dispatched to \`HTTPEndpoint\` attributes via \`getattr\`" https://osv.dev/vulnerability/GHSA-x746-7m8f-x49c
  - GHSA-494j-54xm-rwp3 (low) in `` aiohttp@3.14.3 ``, indirect, fixed in `` 3.14.4 ``, advisory summary: "AIOHTTP: Secure attribute not enforced for shared cookie" https://osv.dev/vulnerability/GHSA-494j-54xm-rwp3
  - GHSA-6655-8ph2-63j3 (low) in `` gradio@5.50.0 ``, direct, fixed in `` 6.15.1 ``, advisory summary: "Gradio: Audio cache key ignores metadata when saving numpy audio outputs" https://osv.dev/vulnerability/GHSA-6655-8ph2-63j3
  - GHSA-h3h8-3v2v-rg7m (low) in `` gradio@5.50.0 ``, direct, fixed in `` 6.6.0 ``, advisory summary: "Gradio: Mocked OAuth Login Exposes Server Credentials and Uses Hardcoded Session Secret" https://osv.dev/vulnerability/GHSA-h3h8-3v2v-rg7m
  - GHSA-jp82-jpqv-5vv3 (low) in `` starlette@0.52.1 ``, indirect, fixed in `` 1.3.0 ``, advisory summary: "Starlette: Unvalidated request path concatenated into authority poisons request.url.hostname" https://osv.dev/vulnerability/GHSA-jp82-jpqv-5vv3

Dependency graphs from deps.dev; advisories from OSV.dev, including the GitHub Advisory Database and the PyPI Advisory Database; all CC BY 4.0.

## Remotes

_none_

## Packages

- pypi postgres-mcp-pro@0.4.2 secrets: DATABASE_URL

## Tools (0)

_none observed_