read-only-local-postgres-mcp-server

Our take

Small, honest single-purpose server: read-only PostgreSQL access for Claude Desktop and Claude Code, with query validation that permits only SELECT statements, env-var connection config, runtime override to connect to other databases dynamically, and JSON-formatted results. MIT-licensed Node.js over stdio, one-line install via claude mcp add or npx, published to the official MCP registry, and pulling a respectable ~500 npm downloads/week for a niche tool. It is a minimal offering from a small shop — 2 stars, 3 contributors, created January 2026 — and 'read-only' rests on statement-prefix validation rather than a read-only database role, so pairing it with a restricted Postgres user is still wise. For anyone who wants Claude querying a local or dev Postgres database with guardrails and zero SaaS dependency.

reviewed by hand · 2026-07-05

Something wrong or dead here? Report it

Verification record

last verified

yesterday

github stars

2

last commit

5 days ago

archived

no

license

MIT

npm

@hovecapital/read-only-postgres-mcp-server

downloads / wk

500

latest version

0.4.0

in registry since

2026-01-29

github.com/hovecapital/read-only-local-postgres-mcp-server