Querypie MCP Server

🚀 QueryPie MCP Server

QueryPie's MCP Server is a console for administrators to manage queries.

🚀 Quick Start

✨ Features

📊 Dashboard and Real-time Charts

Instantly transform query results into charts and visualize data without writing any code.

💽 Monitor Disk and Memory Usage

Track server resource usage, such as disk space and memory, in real-time and quickly identify the most resource-intensive processes.

🕵️♂️ Detect Suspicious Behavior

Review access logs to detect abnormal user behavior, such as dangerous SQL commands or unauthorized server activities.

✨ And This is Just the Beginning...

There are more features waiting for you to explore - register assets, manage access permissions, automate audits, etc. It all depends on how you utilize QueryPie.

📦 Installation

Prepare your QueryPie API key and URL. You can find the API key in the QueryPie web console at General > System > API Token.

Docker

# Standard input example
export QUERYPIE_API_KEY=your_api_key
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}"

# SSE example
export QUERYPIE_API_KEY=your_api_key
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 the querypie-mcp-server binary to ~/.local/bin
curl -L https://github.com/querypie/querypie-mcp-server/releases/latest/download/install.sh | sh

# Standard input example
export QUERYPIE_API_KEY=your_api_key
querypie-mcp-server https://your_querypie_url

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

Claude Desktop

Add the following content to your claude_desktop_config.json file (located at ~/Library/Application Support/Claude on macOS or C:\Users\NAME\AppData\Roaming\Claude on Windows):

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

Cursor

Add the following content to your cursor.config.json file:

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