MCP Server MCP

PostgreSQL MCP Server

By github 👁 1 views ▲ 0 votes

Python MCP server for PostgreSQL database inspection and querying

Homepage Verified source GitHub

Install

uvx mdev-postgresql-mcp-server

Configuration Example

{
  "remotes": [],
  "packages": [
    {
      "registryType": "pypi",
      "registryBaseUrl": "https://pypi.org",
      "identifier": "mdev-postgresql-mcp-server",
      "version": "0.1.2",
      "runtimeHint": "uvx",
      "transport": {
        "type": "stdio"
      },
      "environmentVariables": [
        {
          "description": "PostgreSQL host",
          "isRequired": true,
          "default": "localhost",
          "name": "POSTGRES_HOST"
        },
        {
          "description": "PostgreSQL port",
          "isRequired": true,
          "default": "5432",
          "name": "POSTGRES_PORT"
        },
        {
          "description": "PostgreSQL username",
          "isRequired": true,
          "name": "POSTGRES_USER"
        },
        {
          "description": "PostgreSQL password",
          "isSecret": true,
          "name": "POSTGRES_PASSWORD"
        },
        {
          "description": "PostgreSQL database name",
          "isRequired": true,
          "name": "POSTGRES_DB"
        },
        {
          "description": "Maximum rows returned by read queries",
          "default": "1000",
          "name": "POSTGRES_READ_QUERY_LIMIT"
        }
      ]
    }
  ]
}

mcp model-context-protocol pypi