PostgreSQL MCP Server MCP Server

io.github.musaddiq-dev/postgresql-mcp-server

Repository Registry

What is the PostgreSQL MCP Server MCP server?

Python MCP server for PostgreSQL database inspection and querying

How to install PostgreSQL MCP Server

Copy-paste configuration for popular MCP clients.

transport: stdio

Config generated by PluginBench — verify against the source before use.

Environment / auth

POSTGRES_HOST
required
PostgreSQL host
POSTGRES_PORT
required
PostgreSQL port
POSTGRES_USER
required
PostgreSQL username
POSTGRES_PASSWORD
secret
PostgreSQL password
POSTGRES_DB
required
PostgreSQL database name
POSTGRES_READ_QUERY_LIMIT
Maximum rows returned by read queries

~/Library/Application Support/Claude/claude_desktop_config.json

{
  "mcpServers": {
    "postgresql-mcp-server": {
      "command": "uvx",
      "args": [
        "mdev-postgresql-mcp-server"
      ],
      "env": {
        "POSTGRES_HOST": "<YOUR_POSTGRES_HOST>",
        "POSTGRES_PORT": "<YOUR_POSTGRES_PORT>",
        "POSTGRES_USER": "<YOUR_POSTGRES_USER>",
        "POSTGRES_PASSWORD": "<YOUR_POSTGRES_PASSWORD>",
        "POSTGRES_DB": "<YOUR_POSTGRES_DB>",
        "POSTGRES_READ_QUERY_LIMIT": "<YOUR_POSTGRES_READ_QUERY_LIMIT>"
      }
    }
  }
}