QueryPie

The QueryPie MCP Server lets administrators manage QueryPie data sources, assets, access controls, audits, and other governance tasks from a centralized, programmable interface. It enables live dashboards, real-time resource monitoring, anomaly detection, and automated workflow actions to keep your QueryPie environment organized and secure.

How to use

You interact with the MCP server using an MCP client that connects to your MCP endpoint. You can configure connections, register assets, assign access, and automate audits. The server exposes actionable capabilities such as turning query results into dashboards, monitoring system resources in real time, and detecting suspicious activity through access logs.

How to install

Prerequisites: have Docker installed for the standard container-based setup. You may also install a local binary via a provided script for quick starts.

Docker stdio start (recommended for quick setup) Run the server by providing your API key and the QueryPie URL.

Set your API key and target URL, then start the MCP server container.

Docker stdio start example

# Stdio example
export QUERYPIE_API_KEY=your_token
export QUERYPIE_URL=https://your_querypie_url

docker run --rm \
    -e "QUERYPIE_API_KEY=${QUERYPIE_API_KEY}" \
    ghcr.io/querypie/querypie-mcp-server "${QUERYPIE_URL}"

Docker SSE start example

# SSE example
export QUERYPIE_API_KEY=your_token
export QUERYPIE_URL=https://your_querypie_url

docker run --rm \
    -e "QUERYPIE_API_KEY=${QUERYPIE_API_KEY}" \
    ghcr.io/querypie/querypie-mcp-server "${QUERYPIE_URL}" \
    --transport sse \
    --port 8000

Linux/macOS install and run

Install the MCP server binary and run the server using the same environment variables as the Docker examples.

# Install the querypie-mcp-server binary
curl -L https://github.com/querypie/querypie-mcp-server/releases/latest/download/install.sh | sh

# Stdio example
export QUERYPIE_API_KEY=your_token
querypie-mcp-server https://your_querypie_url

# SSE example
export QUERYPIE_API_KEY=your_token
querypie-mcp-server https://your_querypie_url \
    --transport sse \
    --port 8000

Claude Desktop configuration example

{
  "mcpServers": {
    "querypie": {
      "command": "docker",
      "args": [
        "run",
        "--rm",
        "-e",
        "QUERYPIE_API_KEY=${QUERYPIE_API_KEY}",
        "-it",
        "ghcr.io/querypie/querypie-mcp-server",
        "https://your_querypie_url"
      ],
      "env": {
        "QUERYPIE_API_KEY": "your_token"
      }
    }
  }
}

Cursor configuration example

{
  "mcpServers": {
    "querypie": {
      "command": "docker",
      "type": "stdio",
      "args": [
        "run",
        "--rm",
        "-e",
        "QUERYPIE_API_KEY=${QUERYPIE_API_KEY}",
        "-it",
        "ghcr.io/querypie/querypie-mcp-server",
        "https://your_querypie_url"
      ],
      "env": {
        "QUERYPIE_API_KEY": "your_token"
      }
    }
  }
}

Available tools

Dashboard visualization

Turn query results into live charts and dashboards without writing code.

Resource monitoring

Monitor disk and memory usage in real time and identify resource-intensive processes.

Suspicious activity detection

Review access logs to detect abnormal user behavior and unauthorized server activity.

Asset registration

Register assets and manage their lifecycle within QueryPie.

Access management

Control who can access what within the MCP-enabled environment.

Audit automation

Automate audits and governance workflows across QueryPie data sources.