Pgedge Postgres Mcp Server And Natural Language Agent

@pgEdge

25 days ago

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.

Overview Tools Comments

Overview

**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

Try in Playground

Server Config

{
  "mcpServers": {
    "pgedge": {
      "command": "/absolute/path/to/bin/pgedge-postgres-mcp",
      "env": {
        "PGHOST": "localhost",
        "PGPORT": "5432",
        "PGDATABASE": "mydb",
        "PGUSER": "myuser",
        "PGPASSWORD": "mypass"
      }
    }
  }
}

Build with ShipAny.