publicPublicdnsLocal runtime

postgres-mcp

Postgres MCP Pro 是一个开源 MCP 服务器，为 AI 代理提供数据库索引调优、执行计划分析、健康检查和安全 SQL 执行等全方位支持。

article

README

🚀 Postgres MCP Pro 开发指南

本指南为希望参与 Postgres MCP Pro 开发，或选择从源代码安装 Postgres MCP Pro 的用户提供详细说明。

🚀 快速开始

📦 安装指南

本地开发环境搭建

安装 uv：

curl -sSL https://astral.sh/uv/install.sh | sh

克隆仓库：

git clone https://github.com/crystaldba/postgres-mcp.git
cd postgres-mcp

安装依赖项：

uv pip install -e .
uv sync

运行服务器：

uv run postgres-mcp "postgres://user:password@localhost:5432/dbname"

badge

Publisher / author / owner

person

crystaldbaMCP Server

open_in_newSource repository

Detail synced2026-05-20 10:06:58IDcrystaldba-postgres-mcp

data_object

Technical config

server_config

{
  "rating": 3,
  "dev_lang": "python",
  "mcp_install": "{\n  \"mcpServers\": {\n    \"postgres\": {\n      \"command\": \"docker\",\n      \"args\": [\n        \"run\",\n        \"-i\",\n        \"--rm\",\n        \"-e\",\n        \"DATABASE_URI\",\n        \"crystaldba/postgres-mcp\",\n        \"--access-mode=unrestricted\"\n      ],\n      \"env\": {\n        \"DATABASE_URI\": \"postgresql://username:password@localhost:5432/dbname\"\n      }\n    }\n  }\n}\n\n{\n  \"mcpServers\": {\n    \"postgres\": {\n      \"command\": \"postgres-mcp\",\n      \"args\": [\n        \"--access-mode=unrestricted\"\n      ],\n      \"env\": {\n        \"DATABASE_URI\": \"postgresql://username:password@localhost:5432/dbname\"\n      }\n    }\n  }\n}\n\n{\n  \"mcpServers\": {\n    \"postgres\": {\n      \"command\": \"uv\",\n      \"args\": [\n        \"run\",\n        \"postgres-mcp\",\n        \"--access-mode=unrestricted\"\n      ],\n      \"env\": {\n        \"DATABASE_URI\": \"postgresql://username:password@localhost:5432/dbname\"\n      }\n    }\n  }\n}\n\n{\n    \"mcpServers\": {\n        \"postgres\": {\n            \"type\": \"sse\",\n            \"url\": \"http://localhost:8000/sse\"\n        }\n    }\n}\n\n{\n    \"mcpServers\": {\n        \"postgres\": {\n            \"type\": \"sse\",\n            \"serverUrl\": \"http://localhost:8000/sse\"\n        }\n    }\n}"
}

Discovery labels

Categories

Search & Data

Tags

数据库调优性能分析AI辅助PostgreSQL

Locales

zh_cn

READY-TO-PASTE CONFIG

MCP client config generator

Choose your client, fill the required environment variables, then copy a config generated from this server's published metadata

terminal

Environment variableslockValues stay in this browser tab and are not uploaded or saved

DATABASE_URIRequired

{
  "mcpServers": {
    "postgres": {
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "-e",
        "DATABASE_URI",
        "crystaldba/postgres-mcp",
        "--access-mode=unrestricted"
      ],
      "env": {
        "DATABASE_URI": "postgresql://username:password@localhost:5432/dbname"
      }
    }
  }
}

Save toclaude_desktop_config.json

help

Runtime guide

cloud

Hosted runtime

Hosted servers run from a provider-managed environment. You usually connect the MCP client to the hosted endpoint or follow the provider's authorization flow, without keeping a local process alive

Open provider connection page
Authorize or copy endpoint
Connect from your MCP client

terminal

Local runtime / other methods

Local servers run on your own machine or infrastructure. You normally copy the server_config into your MCP client, install the required package, and provide env variables from env_schema when needed

Copy server_config
Install required package
Fill env variables and restart client