Postgres Mcp
by pgedgecommunityv1.0.0
143
12
The pgEdge Postgres MCP server enables SQL queries against PostgreSQL databases through MCP-compatible clients, while the Natural Language Agent allows users to form SQL queries using natural language.
From the registry: Enterprise PostgreSQL MCP server with NL queries, hybrid search (pgvector+BM25), and web UI
Install & configure
Prerequisites
- requiredPostgreSQL 14+PostgreSQL database to connect to
- requiredGo 1.21+ or DockerGo to build from source, or use Docker image from GitHub Container Registry
$ git clone https://github.com/pgEdge/pgedge-postgres-mcp.git && cd pgedge-postgres-mcp && make build
Install in your client
Paste into the AI you're chatting with — it will figure out the rest
Please install the `postgres-mcp-pgedge` MCP server into my current AI client (that's you).
Required prerequisites (do these first if not already done):
- **PostgreSQL 14+** — PostgreSQL database to connect to
- **Go 1.21+ or Docker** — Go to build from source, or use Docker image from GitHub Container Registry Run: `git clone https://github.com/pgEdge/pgedge-postgres-mcp.git && cd pgedge-postgres-mcp && make build`
Canonical MCP server config (stdio transport):
- command: `./pgedge-postgres-mcp`
- args: []
- required environment variables:
- `TEST_PGEDGE_POSTGRES_CONNECTION_STRING`: PostgreSQL connection string (example: `postgres://user:password@localhost/dbname?sslmode=disable`)
Note: Read-only by default. Requires building from source (Go) or Docker. Supports HTTP/HTTPS mode with user and token auth. Web UI and CLI client included. Full documentation at docs.pgedge.com.
Add this MCP server to my current client's config in the correct format for you. If you need secrets or credentials I haven't provided, ASK me — do not invent values or leave raw placeholders. After adding it, tell me how to verify the server is connected.Note: Read-only by default. Requires building from source (Go) or Docker. Supports HTTP/HTTPS mode with user and token auth. Web UI and CLI client included. Full documentation at docs.pgedge.com.
Tools (8)
CLI (Stdio)
Local single-user development
CLI (HTTP)
Multi-user or remote access
Web UI
Browser-based chat interface
Claude Code
Anthropic CLI agent
Claude Desktop
Anthropic desktop app
Cursor
AI code editor
Windsurf
Codeium code editor
VS Code Copilot
GitHub Copilot agent
Environment variables
TEST_PGEDGE_POSTGRES_CONNECTION_STRINGrequiredDatabase connection string for testingPackages
ghcr.io/pgedge/postgres-mcp:latest
ocitransport: stdio
Details
- Language
- Go
- License
- PostgreSQL
- Released
- Jan 16, 2026
- Last commit
- Apr 10, 2026
- Registry name
- io.github.pgEdge/postgres-mcp