subnetmarco/pgmcp

Overview

An MCP server that translates natural language queries into SQL for Postgres databases. It uses the Model Context Protocol to accept plain English input and execute corresponding queries. Built in Go, it connects to any Postgres instance with minimal setup.

Best for

Best for
Teams building MCP-based tools that need natural language access to Postgres databases

Use cases

• Query Postgres databases using natural language instead of writing SQL
• Integrate with MCP-compatible clients like AI assistants for database access
• Rapidly explore database contents without knowing the schema

How to use

Tools exposed

• go

Tested with

Cursor, Claude Desktop, VS Code, ChatGPT

Example client config

{\n  "mcp.servers": {\n    "pgmcp": {\n      "transport": {\n        "type": "http",\n        "url": "http://localhost:8080/mcp"\n      }\n    }\n  }\n}

Notes

An MCP server that translates natural language queries into SQL for Postgres databases. It uses the Model Context Protocol to accept plain English input and execute corresponding queries. Built in Go, it connects to any Postgres instance with minimal setup.

532 stars on GitHub. Last updated 2026-05-26.

Use cases

• Query Postgres databases using natural language instead of writing SQL
• Integrate with MCP-compatible clients like AI assistants for database access
• Rapidly explore database contents without knowing the schema

Pros

• Simplifies database interaction for non-technical users
• Supports any Postgres database without custom configuration
• Built in Go for performance and low resource usage

Cons

• Limited to Postgres; no support for other database types
• Natural language may produce incorrect or inefficient SQL queries
• Requires an MCP client to interface with the server

Indexed from awesome-mcp-servers-punkpeye and enriched against its public facts.