PostgreSQL MCP Server

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.

claude mcp add postgresql-mcp-server -- uvx mdev-postgresql-mcp-server

{
  "mcpServers": {
    "postgresql-mcp-server": {
      "args": [
        "mdev-postgresql-mcp-server"
      ],
      "command": "uvx"
    }
  }
}

[mcp_servers.postgresql-mcp-server]
command = "uvx"
args = ["mdev-postgresql-mcp-server"]

{
  "mcpServers": {
    "postgresql-mcp-server": {
      "args": [
        "mdev-postgresql-mcp-server"
      ],
      "command": "uvx"
    }
  }
}

{
  "mcpServers": {
    "postgresql-mcp-server": {
      "args": [
        "mdev-postgresql-mcp-server"
      ],
      "command": "uvx"
    }
  }
}

This one needs environment variables set before it will start: POSTGRES_HOST (PostgreSQL host), POSTGRES_PORT (PostgreSQL port), POSTGRES_USER (PostgreSQL username), POSTGRES_PASSWORD (PostgreSQL password), POSTGRES_DB (PostgreSQL database name), POSTGRES_READ_QUERY_LIMIT (Maximum rows returned by read queries). The author declared them in the registry entry; get the values from the project itself.