mcpbeat Sign in

Postgres MCP Server

by sparta2025 Your server? Claim it
local only

Postgres MCP runs on your own machine — the client starts it, so there is no endpoint to ping. 159 installs a week from pypi. Last commit 21 Aug 2026.

PostgreSQL MCP server with 15 tools (SQL, EXPLAIN, health, indexes) plus a Gradio UI with LLM chat.

Installs per day peak 45 · avg 21 · -15% w/w
a month agotoday
159
Installs / week
pypi · postgres-mcp-pro
0
Stars
0 open issues
21 Aug 2026
Last commit
from GitHub
—
License
Python

What the code does

We read the source, 3 d ago · rules 995398eba69f

Capabilities

What this server is able to do. For an MCP server this is often the job itself — a terminal server runs commands because that is what it is for. Listed so you know what you are plugging in, not as an accusation.

    log_file_path = os.path.join(logs_path, host_log_file)

Is this your server and something here is wrong? Tell us — corrections are free and do not require a plan.

This code can reach further than it looks

We found places where it runs commands, builds paths or queries from values it is given. None of that is a flaw by itself — it becomes one when the code changes, and code changes quietly between releases. We re-read it on every one.

Three servers free · no card

Connect this server

This server runs on your own machine — install it with the package manager and the client starts it for you. Package name taken from the official registry entry.

run in your terminal
claude mcp add postgres-mcp -e 'DATABASE_URL=<DATABASE_URL>' -- uvx postgres-mcp-pro
~/Library/Application Support/Claude/claude_desktop_config.json
{
  "mcpServers": {
    "postgres-mcp": {
      "command": "uvx",
      "args": [
        "postgres-mcp-pro"
      ],
      "env": {
        "DATABASE_URL": "<DATABASE_URL>"
      }
    }
  }
}
~/.codex/config.toml
[mcp_servers.postgres-mcp]
command = "uvx"
args = ["postgres-mcp-pro"]
env = { DATABASE_URL = "<DATABASE_URL>" }
.cursor/mcp.json
{
  "mcpServers": {
    "postgres-mcp": {
      "command": "uvx",
      "args": [
        "postgres-mcp-pro"
      ],
      "env": {
        "DATABASE_URL": "<DATABASE_URL>"
      }
    }
  }
}
.vscode/mcp.json
{
  "servers": {
    "postgres-mcp": {
      "type": "stdio",
      "command": "uvx",
      "args": [
        "postgres-mcp-pro"
      ],
      "env": {
        "DATABASE_URL": "<DATABASE_URL>"
      }
    }
  }
}

Put your own value in place of <DATABASE_URL> (PostgreSQL connection URL, e.g. postgresql://user:pass@localhost:5432/dbname). The author’s registry entry marks it as required.

Alternatives to Postgres MCP

same job, measured the same way
PostgreSQL MCP Server
by yawlabs

PostgreSQL MCP server - query, schema introspection, explain, and health checks for AI assistants

2 146 installs/wk local only
PostgreSQL MCP Server
by neverinfamous

PostgreSQL MCP server with 203 tools, connection pooling, HTTP/SSE, OAuth 2.1, and tool filtering

114 installs/wk local only
Postgres
by marcelo-ochoa

MCP server for interacting with PostgreSQL databases

122 installs/wk local only
PostgreSQL MCP Server
by neverinfamous

Enterprise PostgreSQL MCP server with 63 tools, 10 resources, 10 prompts for AI-native operations

local only
D
Data
by thinair

PostgreSQL, MySQL, and SQL Server in one session. 26 read-only MCP tools for AI agents.

answering
Metabase AI Assistant
by enessari

MCP Server for Metabase - 111 tools for SQL generation, dashboards & PostgreSQL

56 installs/wk local only
AI2SQL
by ai2sql

Text-to-SQL MCP server: read-only queries on PostgreSQL, MySQL and SQL Server with your real schema

answering
A
Ailimu
by ailimu

Self-hosted MCP server for FileMaker and PostgreSQL. Turns chosen tables into tools for AI agents.

local only

Postgres MCP — questions

Answers built from our own checks of this server.

Why is there no uptime for Postgres MCP?
Postgres MCP runs on your own machine over stdio — there is no network address to reach, so uptime cannot be measured for it by anyone. What can be measured is adoption: the pypi package postgres-mcp-pro was installed 159 times last week.
How do I connect Postgres MCP?
Copy the ready config from this page. We generate it for Claude Code, Claude Desktop, Codex, Cursor and VS Code, each in the form that client actually reads. It runs locally, so the command pulls postgres-mcp-pro straight from pypi; nothing to host, nothing to sign up for.
How many people use Postgres MCP?
The pypi package postgres-mcp-pro was installed 159 times in the last week. Week over week that is -15%. We show installs rather than GitHub stars on purpose: a star is a bookmark, an install is someone actually running it.
Is Postgres MCP open source?
We cannot say either way: written in Python and 0 stars on GitHub, but we could not determine the licence, and without one the code is not open source by default.