subnetmarco/pgmcp
An MCP server to query any Postgres database in natural language.
Implements a Go-based MCP server that converts natural language queries to SQL using OpenAI's API, with automatic schema caching and streaming result handling. Integrates with Cursor, Claude Desktop, VS Code, and any MCP-compatible client via HTTP transport, while enforcing read-only access and supporting mixed-case table names through intelligent query validation. Includes built-in text search, multiple output formats (JSON/CSV/table), and graceful error recovery when AI-generated SQL fails.
524 stars. No commits in the last 6 months.
Stars
524
Forks
58
Language
Go
License
—
Category
Last pushed
Sep 25, 2025
Commits (30d)
0
Get this data via API
curl "https://pt-edge.onrender.com/api/v1/quality/mcp/subnetmarco/pgmcp"
Open to everyone — 100 requests/day, no key needed. Get a free key for 1,000/day.
Higher-rated alternatives
bytebase/dbhub
Zero-dependency, token-efficient database MCP server for Postgres, MySQL, SQL Server, MariaDB, SQLite.
HenkDz/postgresql-mcp-server
A Powerful PostgreSQL MCP server with 14 consolidated database management tools for AI assistants.
IzumiSy/mcp-duckdb-memory-server
MCP Memory Server with DuckDB backend
alexander-zuev/supabase-mcp-server
Query MCP enables end-to-end management of Supabase via chat interface: read & write query...
wenb1n-dev/mysql_mcp_server_pro
Model Context Protocol (MCP) server that supports secure interaction with MySQL databases and...