# @contextflo/postgres-mcp

Read-only Postgres: drop-in for the archived server-postgres, with schema context.

- **Type:** MCP server
- **Trust:** 85/100 (A), scored on the package rubric
- **Verification:** verified (build provenance)
- **Version:** 0.1.4
- **Author:** io.github.contextflo
- **License:** Unknown
- **npm:** @contextflo/postgres-mcp
- **Source:** https://github.com/contextflo/postgres-mcp
- **Compatible clients:** claude-code, cursor, copilot, gemini (basis: transport)

## Trust

85/100 (A), scored on the package rubric
- Publisher verified: no
- Build provenance: verified attestation
- npm trusted publishing (OIDC): yes
- Install scripts: nothing suspicious found
- Prompt-injection scan: not run
- Obfuscation scan: not run
- Evidence age: 6 days

## Security scan

- **Status:** clean
- **Scanned:** 2026-09-28T21:57:14.576Z
- **Version scanned:** 0.1.4
- **CVEs:** none found by OSV at scan time

## Tools

4 declared. Statically extracted from the shipped source — a floor on the surface, not a census.
- `add_table_context` — Record a durable fact about a table or its columns that you learned from working with the
- `get_table_context` — Describe one or more tables: columns, types, nullability, primary keys, foreign key
- `list_tables` — List the tables, views, and materialized views this connection can read, with their
- `query` — Run a read-only SQL query against the Postgres database. Accepts a single SELECT

## Install

**Verdict: install** — No blocking findings and no open coverage gaps — safe to install as configured.
**Config** (claude-code):
```json
"{\n  \"mcpServers\": {\n    \"postgres\": {\n      \"command\": \"npx\",\n      \"args\": [\n        \"-y\",\n        \"@contextflo/postgres-mcp\"\n      ],\n      \"env\": {\n        \"DATABASE_URL\": \"<YOUR_DATABASE_URL>\"\n      }\n    }\n  }\n}"
```
**Credentials it will ask for** (names only — Forge never holds a value):
- `DATABASE_URL` — Database URL (required)
Placeholders only. Forge never holds, brokers, or transmits a credential value — replace each <YOUR_NAME> in your own config file. Do not send a value back to Forge; no Forge endpoint accepts one.
- This entry needs 1 credential (1 required). The generated config carries placeholders, so it will fail in the editor rather than at runtime if they are left unset.

## Blast radius

Moderate blast radius — holds an api key; runs on your machine.
- Floor 23, ceiling 23 (tier: moderate)
- This is impact, not likelihood. A high radius is not a defect: a filesystem server is supposed to write files. It is never part of the trust score.

## Machine-readable views of this entry

- Signed JSON: https://forgeregistry.com/api/v1/packages/%40contextflo%2Fpostgres-mcp
- Install plan: https://forgeregistry.com/api/v1/packages/%40contextflo%2Fpostgres-mcp/install-plan
- Alternatives: https://forgeregistry.com/api/v1/alternatives/%40contextflo%2Fpostgres-mcp
- HTML page: https://forgeregistry.com/registry/%40contextflo%2Fpostgres-mcp
- MCP: POST https://forgeregistry.com/api/mcp → `forge_get_package` / `forge_install_plan`

## About this document

Generated by Forge (https://forgeregistry.com) — a compact rendering of the same record served, signed, at the JSON URL above. Trust and scan facts are the registry's own measurements; anything Forge did not measure is named as unmeasured rather than omitted.