PGEdge PostgreSQL
Enterprise PostgreSQL MCP server with NL queries, hybrid search (pgvector+BM25), and web UI
What is PGEdge PostgreSQL?
PGEdge PostgreSQL is a Model Context Protocol (MCP) server that allows AI assistants like Claude, Cursor, and VS Code to enterprise postgresql mcp server with nl queries, hybrid search (pgvector+bm25), and web ui
Enterprise PostgreSQL MCP server with NL queries, hybrid search (pgvector+BM25), and web UI
This server falls under the Databases category on MCPgee, the world's largest MCP server directory with 33,000+ servers.
Features
- Enterprise PostgreSQL MCP server with NL queries, hybrid sea
Use Cases
Maintainer
Works with
Installation
Manual Installation
npx pgedge-postgresConfiguration
Configuration Details
claude_desktop_config.json
Performance
Response Metrics
Resource Usage
How to Set Up and Use PGEdge PostgreSQL
The pgEdge PostgreSQL MCP server is an enterprise-grade Go-based server that connects AI assistants to PostgreSQL databases with support for natural language queries, hybrid search combining pgvector semantic embeddings with BM25 full-text ranking, schema analysis, query diagnostics, and a built-in web UI. It enforces read-only transactions by default, supports TLS, user/API token authentication with expiration, and can manage multiple databases simultaneously. Data teams and developers use it to let Claude or Cursor explore large PostgreSQL schemas, run analytical queries in plain English, and perform semantic search over stored content without writing SQL.
Prerequisites
- Go 1.21 or newer installed (for building from source)
- A running PostgreSQL database (pgEdge or standard PostgreSQL)
- The pgvector extension installed in your database for semantic search features
- An MCP-capable client: Claude Desktop, Claude Code, Cursor, or Windsurf
- make build tools installed for compiling the binary
Clone the repository and build the binary
Clone the pgEdge PostgreSQL MCP server repository and build it with make.
git clone https://github.com/pgEdge/pgedge-postgres-mcp.git
cd pgedge-postgres-mcp
make buildSet the database connection string
Export the connection string environment variable pointing to your PostgreSQL database.
export PGEDGE_POSTGRES_CONNECTION_STRING="postgres://user:password@localhost/mydb?sslmode=disable"Run the MCP server in stdio mode
Start the server in stdio transport mode for integration with Claude Desktop or Cursor.
./pgedge-postgres-mcp --transport stdioOr run in HTTP mode with the web UI
Start the server in HTTP mode to access the built-in web dashboard for exploring your database interactively.
./pgedge-postgres-mcp --transport http --port 8080Connect your MCP client
Add the server configuration to your Claude Desktop or Cursor config file to complete the integration.
PGEdge PostgreSQL Examples
Client configuration (Claude Desktop)
Configure Claude Desktop to use the pgEdge PostgreSQL MCP server in stdio mode.
{
"mcpServers": {
"pgedge-postgres": {
"command": "/path/to/pgedge-postgres-mcp",
"args": ["--transport", "stdio"],
"env": {
"PGEDGE_POSTGRES_CONNECTION_STRING": "postgres://user:password@localhost/mydb?sslmode=disable"
}
}
}
}Prompts to try
These prompts leverage the natural language query, hybrid search, and schema analysis capabilities.
- "Show me the schema for the orders table"
- "Find all customers who placed more than 5 orders in the last month"
- "Semantically search the product descriptions for 'wireless audio devices'"
- "What are the slowest queries hitting my database right now?"
- "Explain the relationships between the users, orders, and products tables"
- "Show me indexes that are never used and could be dropped"Troubleshooting PGEdge PostgreSQL
Build fails with missing Go dependencies
Ensure Go 1.21+ is installed ('go version'). Run 'go mod download' inside the repository to fetch all dependencies before running 'make build'.
pgvector extension not found when using semantic search
Install pgvector in your PostgreSQL database: 'CREATE EXTENSION IF NOT EXISTS vector;'. You need PostgreSQL 12+ and the pgvector extension installed at the OS level first ('apt install postgresql-16-pgvector' on Debian/Ubuntu).
Permission denied errors when running queries
The server enforces read-only transactions by default. Ensure your database user has SELECT privileges on the tables you want to query. Check the server's configuration file for the read-only transaction setting if you need write access.
Frequently Asked Questions about PGEdge PostgreSQL
What is PGEdge PostgreSQL?
PGEdge PostgreSQL is a Model Context Protocol (MCP) server that enterprise postgresql mcp server with nl queries, hybrid search (pgvector+bm25), and web ui It connects AI assistants to external tools and data sources through a standardized interface.
How do I install PGEdge PostgreSQL?
Follow the installation instructions on the PGEdge PostgreSQL GitHub repository. Clone the repo, install dependencies, and add the server config to your AI client.
Which AI clients work with PGEdge PostgreSQL?
PGEdge PostgreSQL works with all major MCP-compatible AI clients including Claude Desktop, Claude Code, Cursor, VS Code (GitHub Copilot), Windsurf, and Cline.
Is PGEdge PostgreSQL free to use?
Yes, PGEdge PostgreSQL is open source and available under the PostgreSQL license. You can use it freely in both personal and commercial projects.
PGEdge PostgreSQL Alternatives — Similar Databases Servers
Looking for alternatives to PGEdge PostgreSQL? Here are other popular databases servers you can use with Claude, Cursor, and VS Code.
Excelize
★ 20.6kGo language library for reading and writing Microsoft Excel™ (XLAM / XLSM / XLSX / XLTM / XLTX) spreadsheets
MCP Toolbox for Databases
★ 15.3kOpen source MCP server specializing in easy, fast, and secure tools for Databases.
DBHub
★ 2.8kA universal database gateway MCP server that enables AI assistants to connect to and query multiple databases (PostgreSQL, MySQL, MariaDB, SQL Server, SQLite) with support for schema exploration, SQL execution, and secure connections via SSH tunnels.
Tabularis
★ 2.1kA lightweight, cross-platform database client for developers. Supports MySQL, PostgreSQL and SQLite. Hackable with plugins. Built for speed, security, and aesthetics.
Postgres AI Guide
★ 1.7kMCP server and Claude plugin for Postgres skills and documentation. Helps AI coding tools generate better PostgreSQL code.
Anyquery
★ 1.7k🏎️ 🏠 ☁️ - Query more than 40 apps with one binary using SQL. It can also connect to your PostgreSQL, MySQL, or SQLite compatible database. Local-first and private by design.
Browse More Databases MCP Servers
Explore all databases servers available in the MCPgee directory. Each server includes setup guides for Claude, Cursor, and VS Code.
Set Up PGEdge PostgreSQL in Your Editor
Choose your AI client for step-by-step setup instructions.
Quick Config Preview
Add this to your claude_desktop_config.json or .cursor/mcp.json
Ready to use PGEdge PostgreSQL?
Browse our complete directory of 33,000+ MCP servers, read setup guides for your editor, and start building with the Model Context Protocol.