Pgmoat MCP Server: Install & Setup

Install Pgmoat in Claude Code

Claude Code

claude mcp add pgmoat -e PGMOAT_DATABASE_URL=... -- npx -y pgmoat

mcp.json (Claude Desktop, Cursor, VS Code, Windsurf)

{
  "mcpServers": {
    "pgmoat": {
      "command": "npx",
      "args": [
        "-y",
        "pgmoat"
      ],
      "env": {
        "PGMOAT_DATABASE_URL": "..."
      }
    }
  }
}

Replace each ... with your own value.

Frequently asked questions

What does the Pgmoat MCP server do?

Governed, read-only Postgres access for AI agents: SQL safety, RLS, budgets, tamper-evident audit.

Is the Pgmoat MCP server free?

Yes, most likely. Open source and no paid account or API key is mentioned in the listing. Check the provider for current pricing.

Does Pgmoat run locally or remotely?

Local. Runs on your machine (stdio). You install it with npx, uvx, Docker or from source.

How do I add Pgmoat to Claude Code?

Run: claude mcp add pgmoat -e PGMOAT_DATABASE_URL=... -- npx -y pgmoat

More databases MCP servers

View all

pgops

arzharch/pgops-mcp

Safe, audited PostgreSQL operations for AI agents: queries, migrations, EXPLAIN, containers

LocalFree

pgmcp

pascalallen/pgmcp

Read-only Postgres ops/DBA diagnostics: slow queries, EXPLAIN, locks, index and table health.

LocalFree

pgvector

mittalpk/mcp-server-pgvector

Similarity search, hybrid search, and index management for pgvector-backed PostgreSQL tables

LocalFree

pgbrake

lexang/pgbrake

Postgres brake for AI agents: risky SQL waits for approval, UPDATE/DELETE get one-command undo.

LocalFree

PgVouch

01.4k

Shubh-Sgr/pgvouch

Safe PostgreSQL migrations: schema drift, lock analysis, safe rewrites, data checksums. Read-only.

LocalFree

pg Readonly

les-k/pg-readonly-mcp

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

LocalFree