Pgedge Postgres Mcp Server And Natural Language Agent
**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
Server Config
{
"mcpServers": {
"pgedge": {
"command": "/absolute/path/to/bin/pgedge-postgres-mcp",
"env": {
"PGHOST": "localhost",
"PGPORT": "5432",
"PGDATABASE": "mydb",
"PGUSER": "myuser",
"PGPASSWORD": "mypass"
}
}
}
}