The pgEdge Postgres Model Context Protocol (MCP) server enables SQL queries against PostgreSQL databases through MCP-compatible clients like Claude Desktop. The Natural Language Agent provides supporting functionality that allows you to use natural language to form SQL queries.
Key Features:
🔒 Read-Only Protection - All queries run in read-only transactions
📊 Resources - Access PostgreSQL statistics and more
🛠️ Tools - Query execution, schema analysis, advanced hybrid search (BM25+MMR), embedding generation, resource reading, and more
🧠 Prompts - Guided workflows for semantic search setup, database exploration, query diagnostics, and more
💬 Production Chat Client - Full-featured Go client with Anthropic prompt caching (90% cost reduction)
🌐 HTTP/HTTPS Mode - Direct API access with token authentication
🖥️ Web Interface - Modern React-based UI with AI-powered chat for natural language database interaction
🐳 Docker Support - Complete containerized deployment with Docker Compose
🔐 Secure - TLS support, token auth, read-only enforcement
🔄 Hot Reload - Automatic reload of authentication files without server restart