Connect

8 clients · secrets stay placeholders

JSON (mcpServers)Claude CodeCodexOpenCodeCursorVS CodeGemini CLIGoose

{
  "mcpServers": {
    "mcp-pinot": {
      "command": "uvx",
      "args": [
        "mcp-pinot-server==5.0.0"
      ],
      "env": {
        "PINOT_CONTROLLER_URL": "http://localhost:9000",
        "PINOT_BROKER_URL": "http://localhost:8000",
        "PINOT_PASSWORD": "${PINOT_PASSWORD}",
        "PINOT_TOKEN": "${PINOT_TOKEN}",
        "PINOT_USE_MSQE": "true",
        "MCP_TRANSPORT": "stdio"
      }
    }
  }
}

claude mcp add mcp-pinot -e "PINOT_CONTROLLER_URL=http://localhost:9000" -e "PINOT_BROKER_URL=http://localhost:8000" -e "PINOT_PASSWORD=${PINOT_PASSWORD}" -e "PINOT_TOKEN=${PINOT_TOKEN}" -e "PINOT_USE_MSQE=true" -e "MCP_TRANSPORT=stdio" -- uvx mcp-pinot-server==5.0.0

[mcp_servers.mcp-pinot]
command = "uvx"
args = ["mcp-pinot-server==5.0.0"]
env = { "PINOT_CONTROLLER_URL" = "http://localhost:9000", "PINOT_BROKER_URL" = "http://localhost:8000", "PINOT_PASSWORD" = "${PINOT_PASSWORD}", "PINOT_TOKEN" = "${PINOT_TOKEN}", "PINOT_USE_MSQE" = "true", "MCP_TRANSPORT" = "stdio" }

{
  "$schema": "https://opencode.ai/config.json",
  "mcp": {
    "mcp-pinot": {
      "type": "local",
      "command": [
        "uvx",
        "mcp-pinot-server==5.0.0"
      ],
      "enabled": true,
      "environment": {
        "PINOT_CONTROLLER_URL": "http://localhost:9000",
        "PINOT_BROKER_URL": "http://localhost:8000",
        "PINOT_PASSWORD": "{env:PINOT_PASSWORD}",
        "PINOT_TOKEN": "{env:PINOT_TOKEN}",
        "PINOT_USE_MSQE": "true",
        "MCP_TRANSPORT": "stdio"
      }
    }
  }
}

{
  "mcpServers": {
    "mcp-pinot": {
      "command": "uvx",
      "args": [
        "mcp-pinot-server==5.0.0"
      ],
      "env": {
        "PINOT_CONTROLLER_URL": "http://localhost:9000",
        "PINOT_BROKER_URL": "http://localhost:8000",
        "PINOT_PASSWORD": "${PINOT_PASSWORD}",
        "PINOT_TOKEN": "${PINOT_TOKEN}",
        "PINOT_USE_MSQE": "true",
        "MCP_TRANSPORT": "stdio"
      }
    }
  },
  "deeplink": "cursor://anysphere.cursor-deeplink/mcp/install?name=mcp-pinot&config=eyJjb21tYW5kIjoidXZ4IiwiYXJncyI6WyJtY3AtcGlub3Qtc2VydmVyPT01LjAuMCJdLCJlbnYiOnsiUElOT1RfQ09OVFJPTExFUl9VUkwiOiJodHRwOi8vbG9jYWxob3N0OjkwMDAiLCJQSU5PVF9CUk9LRVJfVVJMIjoiaHR0cDovL2xvY2FsaG9zdDo4MDAwIiwiUElOT1RfUEFTU1dPUkQiOiIke1BJTk9UX1BBU1NXT1JEfSIsIlBJTk9UX1RPS0VOIjoiJHtQSU5PVF9UT0tFTn0iLCJQSU5PVF9VU0VfTVNRRSI6InRydWUiLCJNQ1BfVFJBTlNQT1JUIjoic3RkaW8ifX0%3D"
}

{
  "servers": {
    "mcp-pinot": {
      "type": "stdio",
      "command": "uvx",
      "args": [
        "mcp-pinot-server==5.0.0"
      ],
      "env": {
        "PINOT_CONTROLLER_URL": "http://localhost:9000",
        "PINOT_BROKER_URL": "http://localhost:8000",
        "PINOT_PASSWORD": "${PINOT_PASSWORD}",
        "PINOT_TOKEN": "${PINOT_TOKEN}",
        "PINOT_USE_MSQE": "true",
        "MCP_TRANSPORT": "stdio"
      }
    }
  }
}

{
  "mcpServers": {
    "mcp-pinot": {
      "command": "uvx",
      "args": [
        "mcp-pinot-server==5.0.0"
      ],
      "env": {
        "PINOT_CONTROLLER_URL": "http://localhost:9000",
        "PINOT_BROKER_URL": "http://localhost:8000",
        "PINOT_PASSWORD": "${PINOT_PASSWORD}",
        "PINOT_TOKEN": "${PINOT_TOKEN}",
        "PINOT_USE_MSQE": "true",
        "MCP_TRANSPORT": "stdio"
      }
    }
  }
}

extensions:
  "mcp-pinot":
    enabled: true
    name: "mcp-pinot"
    type: stdio
    cmd: "uvx"
    args:
      - "mcp-pinot-server==5.0.0"
    envs:
      "PINOT_CONTROLLER_URL": "http://localhost:9000"
      "PINOT_BROKER_URL": "http://localhost:8000"
      "PINOT_PASSWORD": "${PINOT_PASSWORD}"
      "PINOT_TOKEN": "${PINOT_TOKEN}"
      "PINOT_USE_MSQE": "true"
      "MCP_TRANSPORT": "stdio"
    timeout: 300

Placeholders to fill from your own secret store: ${PINOT_PASSWORD}, ${PINOT_TOKEN}. 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 83 resolved packages
pass
deps.mcp_sdk_versionmcp 2.3.0, no known advisory
pass
deps.resolvable[email protected] resolved: 83 packages

Tool list unknown · checked 2026-10-20 14:21 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 94 / 100

provenance90

livenessn/a

freshness100

hygiene95

+repository +namespace-matches-repo +website ~liveness-unmeasured +updated-9d-ago -unpinned-packages(1)

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

Dependencies

[email protected] PyPI82 dependencies, resolved · MCP SDK mcp 2.3.0 · advisories checked 2026-10-19

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
`mcp-pinot-server`	pypi	5.0.0	–	`PINOT_PASSWORD`, `PINOT_TOKEN`
`ghcr.io/startreedata/mcp-pinot:5.0.0`	oci	unpinned	–

Tools (0)

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

Schemas: list_tools.

Similar MCP servers

Official server.json

{
  "name": "io.github.startreedata/mcp-pinot",
  "title": "Apache Pinot MCP Server",
  "$schema": "https://static.modelcontextprotocol.io/schemas/2025-12-11/server.schema.json",
  "version": "5.0.0",
  "packages": [
    {
      "version": "5.0.0",
      "transport": {
        "type": "stdio"
      },
      "identifier": "mcp-pinot-server",
      "registryType": "pypi",
      "registryBaseUrl": "https://pypi.org",
      "environmentVariables": [
        {
          "name": "PINOT_CONTROLLER_URL",
          "format": "string",
          "default": "http://localhost:9000",
          "description": "HTTP(S) endpoint of the Pinot Controller."
        },
        {
          "name": "PINOT_BROKER_URL",
          "format": "string",
          "default": "http://localhost:8000",
          "description": "HTTP(S) endpoint of the Pinot Broker."
        },
        {
          "name": "PINOT_USERNAME",
          "format": "string",
          "description": "Optional Pinot basic-auth username."
        },
        {
          "name": "PINOT_PASSWORD",
          "format": "string",
          "isSecret": true,
          "description": "Optional Pinot basic-auth password."
        },
        {
          "name": "PINOT_TOKEN",
          "format": "string",
          "isSecret": true,
          "description": "Optional Pinot bearer token. Overrides username and password when set."
        },
        {
          "name": "PINOT_USE_MSQE",
          "format": "boolean",
          "default": "true",
          "description": "Whether to enable Pinot multi-stage query engine support."
        },
        {
          "name": "MCP_TRANSPORT",
          "format": "string",
          "default": "stdio",
          "description": "Transport mode: 'stdio' (default, for desktop clients) or 'http'."
        },
        {
          "name": "AUTH_PROVIDER",
          "format": "string",
          "description": "Inbound auth provider for HTTP transport (e.g. 'oauth'); required to bind a non-loopback host."
        }
      ]
    },
    {
      "transport": {
        "type": "stdio"
      },
      "identifier": "ghcr.io/startreedata/mcp-pinot:5.0.0",
      "registryType": "oci"
    }
  ],
  "repository": {
    "url": "https://github.com/startreedata/mcp-pinot",
    "source": "github"
  },
  "websiteUrl": "https://startreedata.github.io/mcp-pinot/",
  "description": "Query and manage Apache Pinot through MCP with typed tools and preview-first safety."
}