Supabase
by supabase
Supabase’s official server lets AI create tables, query data and review project settings in your Supabase database.
Computer or cloud★ 2,993Apache-2.0Updated 22 days ago
Postgres MCP
Overview
Description from the maker (original English)
Enterprise PostgreSQL MCP server with NL queries, hybrid search (pgvector+BM25), and web UI
PopNx MCP’s three pillars
These three are never merged into one score: opinions, measurements and popularity are different things.
- User voiceiNo reviews yetReviews open together with accounts in a later step
- Our basic checksi3 of 3 passedChecked from public information; code not scanned yet
- UsageiEarly★ 244
What you can do with it
We have not written a plain-language summary for this one yet. Below are the facts we read from the registry.
- Connection: Runs on your computer
- Transport: stdio
- Category: Databases & datasets
Install
Pick the AI app you use, then copy the settings.
You need
- DockerDocker installed
Open Claude Desktop → Settings → Developer → Edit Config, and paste this into claude_desktop_config.json
{
"mcpServers": {
"postgres": {
"command": "docker",
"args": [
"run",
"-i",
"--rm",
"ghcr.io/pgedge/postgres-mcp:latest"
]
}
}
}Run this in your terminal
claude mcp add postgres -- docker run -i --rm ghcr.io/pgedge/postgres-mcp:latestPaste into .cursor/mcp.json in your project, or ~/.cursor/mcp.json
{
"mcpServers": {
"postgres": {
"command": "docker",
"args": [
"run",
"-i",
"--rm",
"ghcr.io/pgedge/postgres-mcp:latest"
]
}
}
}Paste into .vscode/mcp.json in your project
{
"servers": {
"postgres": {
"type": "stdio",
"command": "docker",
"args": [
"run",
"-i",
"--rm",
"ghcr.io/pgedge/postgres-mcp:latest"
]
}
}
}These settings are generated from the maker’s registry entry. If the README says otherwise, follow the README.
Basic checksi
We check information anyone can see; we have not read the code. Checks that do not apply are left out of the count. · Checked Nov 5, 2026
- ✓ Pass
Maker matches the repo
The registry name was verified with the GitHub account pgEdge, which owns the repo
- ✓ Pass
Still maintained
Code last changed yesterday
- ✓ Pass
Has a licence
Uses PostgreSQL
- – Not applicable
Endpoint responds
This one runs on your computer; there is no internet endpoint
- – Not applicable
Sign-in with OAuth
Runs on your computer and uses local settings instead
- … Not checked yet
No hidden instructions in tool descriptions
Needs the server’s tool list first; this check starts in the next step
Compared with others in Databases & datasetsi
- More stars than 0% of the other 3 servers in this category
- Published to the registry more recently than 33% of the other 3 servers in this category
- Basic checks equal to or better than 100% of the other 3 servers in this category
Compared only with servers in this prototype, not the whole registry.
Common questions
Is Postgres MCP safe?
It passed 3 of 3 applicable basic checks. We have not read the code. Before adding a key or token, see what access the server asks for and use a key with only the permissions you need.
What keys or codes does it need?
The registry does not list a required key, though some servers ask you to sign in on first use.
Does it run on my computer or in the cloud?
It runs on your computer. Your AI app starts it when needed, and data does not pass through the maker’s servers (unless it calls an online service itself).
Is it still maintained?
The GitHub repo last changed yesterday, and the latest version (1.0.0) reached the registry 10 months ago.
Which apps can use it?
Apps that support MCP, such as Claude Desktop, Claude Code, Cursor and VS Code. You also need Docker on your computer.
What can I use instead?
In the same category: Supabase, MongoDB MCP Server, Elasticsearch MCP Server
Alternatives
Servers in the same category from other makers, sorted by stars.
Reading a card:★ GitHub starsiThree pillars: reviews · checks · usageiUpdated = latest version published to the registryi
MongoDB MCP Server
by mongodb-js
MongoDB Model Context Protocol Server
Runs on your computer★ 1,157Apache-2.0Updated yesterday
Elasticsearch MCP Server
by cr7258
MCP server for interacting with Elasticsearch
Runs on your computer★ 315Apache-2.0Updated 14 months ago
README from the maker
Open the README
Copied from the maker’s repo as written. PopNx MCP has not reviewed or endorsed it. HTML, images and scripts are removed. Links lead off this site.
pgEdge Postgres MCP Server and Natural Language Agent
- About the pgEdge Postgres MCP Server
- pgEdge Postgres MCP Server
- Choosing the Right Solution
- Best Practices - Querying the Server
- Installing the MCP Server
- Quick Start
- Quickstart Demo with Northwind
- Deploying on Docker
- Deploying from Source
- Testing the MCP Server Deployment
- Configuring the MCP Server
- Specifying Configuration Preferences
- Using Environment Variables to Specify Options
- Including Provider Embeddings in a Configuration File
- Configuring the Agent for Multiple Databases
- Configuring Supporting Services; HTTP, systemd, and nginx
- Using an Encryption Secret File
- Enabling or Disabling Features
- Configuring and Using a Client Application
- Connecting with the Web Client
- Using the Go Chat Client
- Configuring the Server for use with Claude Desktop
- Configuring the Server for use with Cursor
- Reviewing Server Logs
- Authentication and Security
- Authentication - Overview
- Authentication - User Management
- Authentication - OAuth
- Authentication - Token Management
- Security Checklist
- Security Management
- Reference
- Using MCP Tools
- Using MCP Resources
- Using MCP Prompts
- Error Reference
- Server Configuration File
- API Token Configuration File
- CLI Client Configuration Details
- Advanced Topics
- Creating Custom Definitions
- Configuring and Using Knowledgebase Search
- Using the LLM Proxy
- Row-Level and Column-Level Security
- Distributed Deployment
- For Developers
- For Developers - Overview
- MCP Protocol
- API Reference
- API Browser
- Client Examples
- Building Chat Clients
- Overview
- Python (Stdio + Claude)
- Python (HTTP + Ollama)
- Contributing
- Development Setup
- Architecture
- Internal Architecture
- Testing
- CI/CD
- Accessing Online Help
- Troubleshooting
- Release Notes
- Licence
The pgEdge Postgres Model Context Protocol (MCP) server enables SQL queries against PostgreSQL databases through MCP-compatible clients. The Natural Language Agent provides supporting functionality that allows you to use natural language to form SQL queries.
Supported Versions: PostgreSQL 14 and higher.
NOT FOR PUBLIC-FACING APPLICATIONS: This MCP server provides
LLMs with read access to your entire database schema and data.
It should only be used for internal tools, developer workflows,
or environments where all users are trusted. For public-facing
applications, consider the
instead. See the
for details.
Quick Start
The Quick Start guide covers installation and setup for all supported clients:
| Client | Transport | Best For |
|---|---|---|
| CLI (Stdio) | Stdio | Local single-user development |
| CLI (HTTP) | HTTP | Multi-user or remote access |
| Web UI | HTTP | Browser-based chat interface |
| Claude Code | Stdio | Anthropic CLI agent |
| Claude Desktop | Stdio | Anthropic desktop app |
| Cursor | Stdio | AI code editor |
| Windsurf | Stdio | Codeium code editor |
| VS Code Copilot | Stdio | GitHub Copilot agent |
For a guided demo with sample data, see the Quickstart Demo with Northwind.
Key Features
- Read-Only Protection - All queries run in read-only transactions by default
- 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 user and token authentication
- Web Interface - Modern React-based UI with AI-powered chat for natural language database interaction
- Docker Support - Pre-built images on GitHub Container Registry with Docker Compose deployment
- Secure - TLS support, user and token auth, read-only enforcement
- Hot Reload - Automatic reload of authentication files without server restart
Development
Prerequisites
- Go 1.26.10 or higher
- PostgreSQL 14 or higher (for testing)
- golangci-lint v1.x (for linting)
Setup Linter
The project uses golangci-lint v1.x. Install it with:
go install github.com/golangci/golangci-lint/cmd/golangci-lint@latestNote: The configuration file .golangci.yml is compatible with golangci-lint v1.x (not v2).
Building
git clone https://github.com/pgEdge/pgedge-postgres-mcp.gitcd pgedge-postgres-mcp make build
Testing
# Run all testsmake test
Run server tests with a database
export TEST_PGEDGE_POSTGRES_CONNECTION_STRING=\ "postgres://localhost/postgres?sslmode=disable" go test ./...
Run with coverage
go test -v -cover ./...
Run linting
make lint
Web UI Tests
The web UI has a comprehensive test suite. See web/TEST_SUMMARY.md for details.
cd webnpm test # Run all tests npm run test:watch # Watch mode npm run test:coverage # With coverage
Security
- Read-only transaction enforcement (configurable per database)
- User and API token authentication with expiration
- TLS/HTTPS support
- SHA256 token hashing
- File permission enforcement (0600)
- Input validation and sanitization
See the Security Guide for comprehensive security documentation.
Troubleshooting
Tools not visible in Claude Desktop?
- Use absolute paths in config
- Restart Claude Desktop completely
- Check JSON syntax
Database connection errors?
- Ensure database connection is configured before starting the server (via config file, environment variables, or command-line flags)
- Verify PostgreSQL is running:
pg_isready - Check connection parameters are correct
See the Troubleshooting Guide for detailed solutions.
Support
To report an issue with the software, visit: GitHub Issues
For more information, visit docs.pgedge.com
This project is licensed under the PostgreSQL License.