AgentHubAgentHub

PostgreSQL MCP Server

MCP ServerMCP Registry官方收录

io.github.musaddiq-dev/postgresql-mcp-server · v0.1.2

Python MCP server for PostgreSQL database inspection and querying

源仓库 ↗

概览

PostgreSQL MCP Server 是一个MCP Server，收录自 官方 MCP Registry。支持 stdio 传输。本页提供 Cursor、Claude Code 等客户端的安装配置片段。

安装

选择你的平台查看安装方式

{
  "mcpServers": {
    "postgresql-mcp-server": {
      "command": "uvx",
      "args": [
        "mdev-postgresql-mcp-server"
      ],
      "env": {
        "POSTGRES_HOST": "<POSTGRES_HOST>",
        "POSTGRES_PORT": "<POSTGRES_PORT>",
        "POSTGRES_USER": "<POSTGRES_USER>",
        "POSTGRES_DB": "<POSTGRES_DB>"
      }
    }
  }
}

环境变量

POSTGRES_HOST必填

PostgreSQL host

POSTGRES_PORT必填

PostgreSQL port

POSTGRES_USER必填

PostgreSQL username

POSTGRES_PASSWORD可选secret

PostgreSQL password

POSTGRES_DB必填

PostgreSQL database name

POSTGRES_READ_QUERY_LIMIT可选

Maximum rows returned by read queries

相关资源

统一 Manifest

{
  "id": "io.github.musaddiq-dev/postgresql-mcp-server",
  "type": "mcp-server",
  "version": "0.1.2",
  "displayName": "PostgreSQL MCP Server",
  "description": "Python MCP server for PostgreSQL database inspection and querying",
  "repository": {
    "url": "https://github.com/musaddiq-dev/postgresql-mcp-server",
    "source": "github"
  },
  "distribution": {
    "packages": [
      {
        "registryType": "pypi",
        "identifier": "mdev-postgresql-mcp-server",
        "version": "0.1.2",
        "runtimeHint": "uvx",
        "transport": "stdio",
        "environmentVariables": [
          {
            "name": "POSTGRES_HOST",
            "description": "PostgreSQL host",
            "isRequired": true
          },
          {
            "name": "POSTGRES_PORT",
            "description": "PostgreSQL port",
            "isRequired": true
          },
          {
            "name": "POSTGRES_USER",
            "description": "PostgreSQL username",
            "isRequired": true
          },
          {
            "name": "POSTGRES_PASSWORD",
            "description": "PostgreSQL password",
            "isSecret": true
          },
          {
            "name": "POSTGRES_DB",
            "description": "PostgreSQL database name",
            "isRequired": true
          },
          {
            "name": "POSTGRES_READ_QUERY_LIMIT",
            "description": "Maximum rows returned by read queries"
          }
        ]
      }
    ],
    "remotes": []
  },
  "dependencies": [],
  "installTargets": [
    "claude-code",
    "claude-desktop",
    "cursor",
    "vscode"
  ],
  "keywords": [],
  "provenance": {
    "origin": "official-mcp-registry",
    "originalId": "io.github.musaddiq-dev/postgresql-mcp-server",
    "originalUrl": "https://registry.modelcontextprotocol.io/v0.1/servers/io.github.musaddiq-dev%2Fpostgresql-mcp-server/versions/latest",
    "isOfficial": true,
    "status": "active"
  }
}
PostgreSQL MCP Server — MCP Server 安装与配置 · AgentHub