pgmcp

by subnetmarco · Go · ★ 529

An MCP server to query any Postgres database in natural language.

#agent#agentic-ai#ai#analytics#artificial-intelligence#data-analysis#database#kong#mcp#mcp-server#postgres#postgresql

Install

go install github.com/subnetmarco/pgmcp@latest

Claude Desktop config

Add this to your claude_desktop_config.json:

{
  "mcpServers": {
    "pgmcp": {
      "command": "npx",
      "args": [
        "-y",
        "github:subnetmarco/pgmcp"
      ]
    }
  }
}

From the README

[](https://github.com/subnetmarco/pgmcp/actions/workflows/ci.yml) [](https://goreportcard.com/report/github.com/subnetmarco/pgmcp) [](https://opensource.org/licenses/Apache-2.0) PGMCP connects AI assistants to **any PostgreSQL database** through natural language queries. Ask questions in plain English and get structured SQL results with automatic streaming and robust error handling. **Works with**: Cursor, Claude Desktop, VS Code extensions, and any [MCP-compatible client](https://modelcontextprotocol.io/) PGMCP connects to **your existing PostgreSQL database** and makes it accessible to AI…

Read full README on GitHub →