Connect

8 clients · secrets stay placeholders

JSON (mcpServers)Claude CodeCodexOpenCodeCursorVS CodeGemini CLIGoose

{
  "mcpServers": {
    "postgresql-mcp-server": {
      "command": "uvx",
      "args": [
        "mdev-postgresql-mcp-server==0.1.2"
      ],
      "env": {
        "POSTGRES_HOST": "localhost",
        "POSTGRES_PORT": "5432",
        "POSTGRES_USER": "${POSTGRES_USER}",
        "POSTGRES_PASSWORD": "${POSTGRES_PASSWORD}",
        "POSTGRES_DB": "${POSTGRES_DB}",
        "POSTGRES_READ_QUERY_LIMIT": "1000"
      }
    }
  }
}

claude mcp add postgresql-mcp-server -e "POSTGRES_HOST=localhost" -e "POSTGRES_PORT=5432" -e "POSTGRES_USER=${POSTGRES_USER}" -e "POSTGRES_PASSWORD=${POSTGRES_PASSWORD}" -e "POSTGRES_DB=${POSTGRES_DB}" -e "POSTGRES_READ_QUERY_LIMIT=1000" -- uvx mdev-postgresql-mcp-server==0.1.2

[mcp_servers.postgresql-mcp-server]
command = "uvx"
args = ["mdev-postgresql-mcp-server==0.1.2"]
env = { "POSTGRES_HOST" = "localhost", "POSTGRES_PORT" = "5432", "POSTGRES_USER" = "${POSTGRES_USER}", "POSTGRES_PASSWORD" = "${POSTGRES_PASSWORD}", "POSTGRES_DB" = "${POSTGRES_DB}", "POSTGRES_READ_QUERY_LIMIT" = "1000" }

{
  "$schema": "https://opencode.ai/config.json",
  "mcp": {
    "postgresql-mcp-server": {
      "type": "local",
      "command": [
        "uvx",
        "mdev-postgresql-mcp-server==0.1.2"
      ],
      "enabled": true,
      "environment": {
        "POSTGRES_HOST": "localhost",
        "POSTGRES_PORT": "5432",
        "POSTGRES_USER": "{env:POSTGRES_USER}",
        "POSTGRES_PASSWORD": "{env:POSTGRES_PASSWORD}",
        "POSTGRES_DB": "{env:POSTGRES_DB}",
        "POSTGRES_READ_QUERY_LIMIT": "1000"
      }
    }
  }
}

{
  "mcpServers": {
    "postgresql-mcp-server": {
      "command": "uvx",
      "args": [
        "mdev-postgresql-mcp-server==0.1.2"
      ],
      "env": {
        "POSTGRES_HOST": "localhost",
        "POSTGRES_PORT": "5432",
        "POSTGRES_USER": "${POSTGRES_USER}",
        "POSTGRES_PASSWORD": "${POSTGRES_PASSWORD}",
        "POSTGRES_DB": "${POSTGRES_DB}",
        "POSTGRES_READ_QUERY_LIMIT": "1000"
      }
    }
  },
  "deeplink": "cursor://anysphere.cursor-deeplink/mcp/install?name=postgresql-mcp-server&config=eyJjb21tYW5kIjoidXZ4IiwiYXJncyI6WyJtZGV2LXBvc3RncmVzcWwtbWNwLXNlcnZlcj09MC4xLjIiXSwiZW52Ijp7IlBPU1RHUkVTX0hPU1QiOiJsb2NhbGhvc3QiLCJQT1NUR1JFU19QT1JUIjoiNTQzMiIsIlBPU1RHUkVTX1VTRVIiOiIke1BPU1RHUkVTX1VTRVJ9IiwiUE9TVEdSRVNfUEFTU1dPUkQiOiIke1BPU1RHUkVTX1BBU1NXT1JEfSIsIlBPU1RHUkVTX0RCIjoiJHtQT1NUR1JFU19EQn0iLCJQT1NUR1JFU19SRUFEX1FVRVJZX0xJTUlUIjoiMTAwMCJ9fQ%3D%3D"
}

{
  "servers": {
    "postgresql-mcp-server": {
      "type": "stdio",
      "command": "uvx",
      "args": [
        "mdev-postgresql-mcp-server==0.1.2"
      ],
      "env": {
        "POSTGRES_HOST": "localhost",
        "POSTGRES_PORT": "5432",
        "POSTGRES_USER": "${POSTGRES_USER}",
        "POSTGRES_PASSWORD": "${POSTGRES_PASSWORD}",
        "POSTGRES_DB": "${POSTGRES_DB}",
        "POSTGRES_READ_QUERY_LIMIT": "1000"
      }
    }
  }
}

{
  "mcpServers": {
    "postgresql-mcp-server": {
      "command": "uvx",
      "args": [
        "mdev-postgresql-mcp-server==0.1.2"
      ],
      "env": {
        "POSTGRES_HOST": "localhost",
        "POSTGRES_PORT": "5432",
        "POSTGRES_USER": "${POSTGRES_USER}",
        "POSTGRES_PASSWORD": "${POSTGRES_PASSWORD}",
        "POSTGRES_DB": "${POSTGRES_DB}",
        "POSTGRES_READ_QUERY_LIMIT": "1000"
      }
    }
  }
}

extensions:
  "postgresql-mcp-server":
    enabled: true
    name: "postgresql-mcp-server"
    type: stdio
    cmd: "uvx"
    args:
      - "mdev-postgresql-mcp-server==0.1.2"
    envs:
      "POSTGRES_HOST": "localhost"
      "POSTGRES_PORT": "5432"
      "POSTGRES_USER": "${POSTGRES_USER}"
      "POSTGRES_PASSWORD": "${POSTGRES_PASSWORD}"
      "POSTGRES_DB": "${POSTGRES_DB}"
      "POSTGRES_READ_QUERY_LIMIT": "1000"
    timeout: 300

Placeholders to fill from your own secret store: ${POSTGRES_PASSWORD}. The registry never accepts secret values.

This is a local package: the command runs on your machine.

Quality – / 100not scored

Not scored: fewer than three checks apply, usually because no remote answered a credential-free probe or the server is a local package.

protocoln/a · weight 25

n/a
protocol.modern, protocol.stateless, protocol.transport, protocol.list_ttlno remote answered a protocol handshake (not probed yet, unreachable, or local-only)

authorizationn/a · weight 15

n/a
auth.prm, auth.as_metadata, auth.cimdno remote uses OAuth
n/a
auth.secret_in_urlno templated URL

tool hygienen/a · weight 30

n/a
tools.descriptions, tools.description_length, tools.schemas, tools.annotations, tools.directory_hints, tools.token_cost, tools.api_dumptool list unknown (behind auth, not probed, or empty)

stabilityn/a · weight 15

n/a
stability.changes, stability.rug_pulltool list unknown

dependencies100 · weight 15

pass
deps.known_vulnsno known advisory in 31 resolved packages
pass
deps.mcp_sdk_versionmcp 2.2.0, no known advisory
pass
deps.resolvable[email protected] resolved: 31 packages

Tool list unknown · checked 2026-10-09 23:53 UTC

Tool changes

No tool definition changes recorded. A server's first observation is its baseline; later probes record what changes.

Checks run on what our credential-free, read-only probes observe; tools are never called and no code audit is performed. How it is computed.

Trust 81 / 100

provenance80

livenessn/a

freshness65

hygiene100

+repository +namespace-matches-repo ~liveness-unmeasured ~updated-140d-ago

Derived from observable signals (official registry feed and our own credential-free probes); no code audit performed. How it is computed.

Dependencies

[email protected] PyPI30 dependencies, resolved · MCP SDK mcp 2.2.0 · advisories checked 2026-10-09

No known advisory affects this dependency graph.

Dependency graphs from deps.dev; advisories from OSV.dev, including the GitHub Advisory Database and the PyPI Advisory Database; all CC BY 4.0. The graph is what a clean install of this version resolves today; nothing was installed or run. How it is checked.

Endpoints

package	registry	version	runtime	secrets
`mdev-postgresql-mcp-server`	pypi	0.1.2	uvx	`POSTGRES_PASSWORD`

Tools (0)

No tools observed. Local packages are never executed by the registry.

Schemas: list_tools.

Official server.json

{
  "name": "io.github.musaddiq-dev/postgresql-mcp-server",
  "title": "PostgreSQL MCP Server",
  "$schema": "https://static.modelcontextprotocol.io/schemas/2025-12-11/server.schema.json",
  "version": "0.1.2",
  "packages": [
    {
      "version": "0.1.2",
      "transport": {
        "type": "stdio"
      },
      "identifier": "mdev-postgresql-mcp-server",
      "runtimeHint": "uvx",
      "registryType": "pypi",
      "registryBaseUrl": "https://pypi.org",
      "environmentVariables": [
        {
          "name": "POSTGRES_HOST",
          "default": "localhost",
          "isRequired": true,
          "description": "PostgreSQL host"
        },
        {
          "name": "POSTGRES_PORT",
          "default": "5432",
          "isRequired": true,
          "description": "PostgreSQL port"
        },
        {
          "name": "POSTGRES_USER",
          "isRequired": true,
          "description": "PostgreSQL username"
        },
        {
          "name": "POSTGRES_PASSWORD",
          "isSecret": true,
          "description": "PostgreSQL password"
        },
        {
          "name": "POSTGRES_DB",
          "isRequired": true,
          "description": "PostgreSQL database name"
        },
        {
          "name": "POSTGRES_READ_QUERY_LIMIT",
          "default": "1000",
          "description": "Maximum rows returned by read queries"
        }
      ]
    }
  ],
  "repository": {
    "url": "https://github.com/musaddiq-dev/postgresql-mcp-server",
    "source": "github"
  },
  "description": "Python MCP server for PostgreSQL database inspection and querying"
}