{"repo":"subnetmarco/pgmcp","free":true,"listed":false,"github":"https://github.com/subnetmarco/pgmcp","clone":"git clone https://github.com/subnetmarco/pgmcp.git","description":"An MCP server to query any Postgres database in natural language.","language":"Go","stars":540,"topics":["agent","agentic-ai","ai","analytics","artificial-intelligence","kong","mcp","mcp-server","postgres","postgresql"],"license":null,"category":"mcp-servers","readme_excerpt":"PGMCP - PostgreSQL Model Context Protocol Server 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 Quick Start PGMCP connects to your existing PostgreSQL database and makes it accessible to AI assistants through natural language queries. Prerequisites - PostgreSQL database (existing database with your schema) - OpenAI API key (optional, for AI-powered SQL generation) Basic Usage Here is how it works: Features - Natural Language to SQL : Ask questions in plain English - Automatic Streaming : Handles large result sets automatically - Safe Read-Only Access : Prevents any write operations - Text Search : Search across all text columns - Multiple Output Formats : Table, JSON, and CSV - PostgreSQL Case Sensitivity : Handles mixed-case table names correctly - Universal Compatibility : Works with any PostgreSQL database Environment Variables Required: - DATABASE URL : PostgreSQL connection string to your existing database Optional: - OPENAI API KEY : OpenAI API key for AI-powered SQL generation - OPENAI MODEL : Model to use (default: \"gpt-4o-mini\") - HTTP ADDR : Server address (default: \":8080\") - HTTP PATH : MCP endpoint path (default: \"/mcp\") - AUTH BEARER : Bearer token for authentication Installation Download Pre-compiled Binaries 1. Go to Git","default_branch":null,"files":null,"tree":[],"storefront":"/r/subnetmarco","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/subnetmarco/pgmcp/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}