querypie-mcp-server
If you are the rightful owner of querypie-mcp-server and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.
The MCP server for QueryPie allows administrators to manage and monitor their QueryPie environment effectively.
QueryPie MCP
The MCP server for QueryPie for administrators to manage it.
Key Usage Demo
📊 Dashboard with Instant Charts
Visualize your data instantly by turning query results into live charts and dashboards—without writing a single line of code.
💽 Monitor Disk & Memory Usage
Track server resource usage like disk space and memory in real time, and identify the most resource-intensive processes at a glance.
🕵️♂️ Detect Suspicious Behavior
Review access logs and detect abnormal user behavior, such as risky SQL commands or unauthorized server activity.
✨ And That’s Just the Beginning...
There’s so much more you can do—register assets, manage access, automate audits, and more.
It all depends on how you use QueryPie. Start exploring and make it yours.
Installation
Prepare your QueryPie API key and URL.
You can find the API key on General > System > API Token in the QueryPie web console.
Docker
# 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}"
# 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 the querypie-mcp-server binary to ~/.local/bin
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
Add this into your claude_desktop_config.json (either 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}",
"-it",
"ghcr.io/querypie/querypie-mcp-server",
"https://your_querypie_url"
],
"env": {
"QUERYPIE_API_KEY": "your_token"
}
}
}
}
Cursor
Add this into your ~/cursor/mcp.json
{
"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"
}
}
}
}
