Developer · Local MCP server
Postgres MCP
PostgreSQL MCP server with 15 tools (SQL, EXPLAIN, health, indexes) plus a Gradio UI with LLM chat.
What the MCP Registry states
The entry as published to the official MCP Registry (read 2026-10-04), latest version.
- Registry name
io.github.sparta2025/postgres-mcp- Version
- 0.4.2
- Status
- Active
- Category
- developer
- Transport
- stdio (local process)
- Package
- PyPI
- Published
- 2026-08-21
- Updated
- 2026-08-21
- Publisher
- sparta2025 (GitHub)
- Listed under
- PostgreSQL MCP servers
- Repository
- github.com/sparta2025/postgres-mcp
- Source
- Registry API entry
Packages
| Registry | Package | Version | Transport |
|---|---|---|---|
| PyPI | postgres-mcp-pro | 0.4.2 | stdio |
How to connect Postgres MCP
Postgres MCP runs locally from a Python package published to PyPI: postgres-mcp-pro version 0.4.2. It speaks MCP over stdio, so the client starts it as a program and talks to it through standard input and output. It needs Python; clients usually start it with uvx (from uv) or after pip install — the usual command is uvx postgres-mcp-pro. It reads the environment variable DATABASE_URL (required, secret); set it in the client's configuration for this server.
In the mcpServers JSON format that many desktop and editor MCP clients read, the entry looks like this (placeholders in angle brackets):
{
"mcpServers": {
"postgres-mcp": {
"command": "uvx",
"args": [
"postgres-mcp-pro"
],
"env": {
"DATABASE_URL": "<secret>"
}
}
}
}Derived from the registry entry, not tested here. What the server does, and on what terms, is set by its publisher; check its repository or website before giving it access to your accounts or files. How to add an MCP server to an assistant · Before you connect
More developer servers
| Server | Runs |
|---|---|
| PostgresPostgreSQL MCP — query databases, inspect schemas, explain queries. | Local · stdio |
| Postgres AIopsGoverned PostgreSQL DBA ops: slow-query RCA, bloat/vacuum & blocking-lock analysis; 35 MCP tools. | Local · stdio |
| Postgres MCPPostgreSQL MCP wrapper with.env credential mapping, tool selection, and safe read-only defaults. | Local · stdio |
| Postgres MCPEnterprise PostgreSQL MCP server with NL queries, hybrid search (pgvector+BM25), and web UI. | Local · stdio |
| Postgres Scout MCPScout your PostgreSQL databases with AI - safety features, monitoring, and data quality. | Local · stdio |
| PostgreSQLMCP server for PostgreSQL: local, Docker, RDS, Neon, Supabase, or behind an SSH bastion. | Local · stdio |
| PostgreSQL (hardened, read-only)Read-only PostgreSQL over MCP. Writes refused at the parsed SQL, plus a READ ONLY transaction. | Local · stdio, HTTP |
| PostgreSQL CVE & Release IntelligencePostgreSQL security for AI agents: CVEs, yanked releases, exploits, and upgrade paths. | Local · stdio |