MCP Server

PostgreSQL MCP Server MCP Server

Name: PostgreSQL MCP Server MCP Server
Author: io.github.musaddiq-dev

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

Claude Desktop

~/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>"
      }
    }
  }
}

Cursor

~/.cursor/mcp.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>"
      }
    }
  }
}

Windsurf

~/.codeium/windsurf/mcp_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>"
      }
    }
  }
}

VS Code

.vscode/mcp.json

{
  "servers": {
    "postgresql-mcp-server": {
      "type": "stdio",
      "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>"
      }
    }
  }
}

Claude Code

claude mcp add postgresql-mcp-server --env POSTGRES_HOST=<YOUR_POSTGRES_HOST> --env POSTGRES_PORT=<YOUR_POSTGRES_PORT> --env POSTGRES_USER=<YOUR_POSTGRES_USER> --env POSTGRES_PASSWORD=<YOUR_POSTGRES_PASSWORD> --env POSTGRES_DB=<YOUR_POSTGRES_DB> --env POSTGRES_READ_QUERY_LIMIT=<YOUR_POSTGRES_READ_QUERY_LIMIT> -- uvx mdev-postgresql-mcp-server

Related MCP servers

AWS CLI MCP Server

Python MCP server for AWS CLI inspection and operations

View repository →

MySQL MCP Server

Python MCP server for MySQL database inspection and querying

View repository →