NestDaddy
All servers NestDaddy MCP Blog Sign inTry it free
Databases

Pg Readonly Mcp

io.github.les-k/pg-readonly-mcp · v0.1.1

A read-only Postgres MCP server that parses SQL rather than pattern-matching it.

Website Source code Set it up

Connect Runs on your machine

Terminal
claude mcp add pg-readonly-mcp -e PG_READONLY_MCP_DSN=<PG_READONLY_MCP_DSN> -- uvx pg-readonly-mcp==0.1.1
claude_desktop_config.json
{
  "mcpServers": {
    "pg-readonly-mcp": {
      "command": "uvx",
      "args": [
        "pg-readonly-mcp==0.1.1"
      ],
      "env": {
        "PG_READONLY_MCP_DSN": "<PG_READONLY_MCP_DSN>"
      }
    }
  }
}
~/.cursor/mcp.json
{
  "mcpServers": {
    "pg-readonly-mcp": {
      "command": "uvx",
      "args": [
        "pg-readonly-mcp==0.1.1"
      ],
      "env": {
        "PG_READONLY_MCP_DSN": "<PG_READONLY_MCP_DSN>"
      }
    }
  }
}
.vscode/mcp.json
{
  "servers": {
    "pg-readonly-mcp": {
      "type": "stdio",
      "command": "uvx",
      "args": [
        "pg-readonly-mcp==0.1.1"
      ],
      "env": {
        "PG_READONLY_MCP_DSN": "<PG_READONLY_MCP_DSN>"
      }
    }
  }
}

Replace the values in angle brackets with your own. Keys stay on your machine; we never see them.

Tools

This server runs locally, so its tools are listed by your MCP client once it starts.

Environment variables

NameDescription
PG_READONLY_MCP_DSN
Required, secret		Postgres connection string for a role that holds only SELECT. The server refuses to start otherwise.

Details

Package[email protected] (PYPI, stdio)
First published2 Oct 2026
Last updated2 Oct 2026
Registry nameio.github.les-k/pg-readonly-mcp

More databases servers See all

  • VibeScale

    Pre-launch checks for AI-built apps: leaked keys, Supabase RLS gaps, browser-exposed env vars.

  • Imf Mcp Server

    Query IMF SDMX 3.0 macroeconomic dataflows — WEO, BOP, CPI, exchange rates, 190 countries.

  • Apex DB

    Vehicle specifications, emissions, and powertrain data with source provenance.

  • TrialBase DB

    Clinical trials across multiple registries with identifiers and source links.

  • PatchLabs

    Security checks for AI-built apps (Lovable, Supabase, Bolt): RLS, headers, monitoring, fixes.

  • Tidy Byte Tools API

    Remote MCP for JSON repair, hashing, formatting, IDs, dates, units, and other small tools.

Listing data from the official MCP registry. Status and tools from NestDaddy's daily check. Browse all MCP servers.