greptimedb-mcp-server
mcpkey · packageio.github.GreptimeTeam/greptimedb-mcp-server · v0.6.0
Query GreptimeDB metrics, logs and traces with SQL, TQL and RANGE. Manage pipelines and dashboards.
run it
on your own machines, one way per deploy methodgenerated from the record, not tested yet
# once, as root:
# as_mcp DIR COMMAND...: runs COMMAND as the mcp user in DIR, its home, sandboxed as the
# units are: a package's install scripts can write to DIR only, as the server later can
as_mcp() {
local dir="$1"; shift
systemd-run --quiet --wait --pipe --collect --uid=mcp --gid=mcp \
-p WorkingDirectory="$dir" -p Environment=HOME="$dir" -p ReadWritePaths="$dir" \
-p NoNewPrivileges=true -p ProtectSystem=strict -p ProtectHome=true -p PrivateTmp=true \
-- "$@" </dev/null
}
install -d -m 0750 -o mcp -g mcp /var/lib/mcp/greptimedb
# greptimedb: its packages, installed whole before its unit starts (no session installs)
systemctl stop mcp-my-agent-greptimedb.service 2>/dev/null || true
as_mcp /var/lib/mcp/greptimedb uv tool install greptimedb-mcp-server==0.6.0
as_mcp /var/lib/mcp/greptimedb uv tool install mcp-proxy
#!/usr/bin/env bash
# greptimedb (io.github.GreptimeTeam/greptimedb-mcp-server), recipe baremetal (generated).
# Generated by Hub for toolset "my-agent"; started by mcp-my-agent-greptimedb.service.
set -euo pipefail
export HOST=127.0.0.1 PORT=8101
exec uvx mcp-proxy --host 127.0.0.1 --port 8101 --pass-environment -- uvx greptimedb-mcp-server==0.6.0
[Unit]
Description=MCP server greptimedb (toolset my-agent), generated by Hub
After=network-online.target
Wants=network-online.target
[Service]
Type=simple
User=mcp
Group=mcp
EnvironmentFile=/etc/mcp/my-agent.env
Environment=HOME=/var/lib/mcp/greptimedb
WorkingDirectory=/var/lib/mcp/greptimedb
ExecStart=/opt/mcp/my-agent/bin/greptimedb.sh
Restart=on-failure
RestartSec=5
NoNewPrivileges=true
ProtectSystem=strict
ProtectHome=true
PrivateTmp=true
ReadWritePaths=/var/lib/mcp/greptimedb
[Install]
WantedBy=multi-user.target
generated from the record, not tested yet
docker run --rm -p 127.0.0.1:8101:8000 -e GREPTIMEDB_HOST -e GREPTIMEDB_PORT -e GREPTIMEDB_USER -e GREPTIMEDB_PASSWORD -e GREPTIMEDB_DATABASE -e GREPTIMEDB_TIMEZONE -e GREPTIMEDB_POOL_SIZE -e GREPTIMEDB_HTTP_PORT -e GREPTIMEDB_HTTP_PROTOCOL -e GREPTIMEDB_MASK_ENABLED -e GREPTIMEDB_MASK_PATTERNS -e GREPTIMEDB_AUDIT_ENABLED -e GREPTIMEDB_ALLOW_WRITE ghcr.io/astral-sh/uv:python3.12-bookworm-slim sh -c 'uvx mcp-proxy --host 0.0.0.0 --port 8000 --pass-environment -- uvx greptimedb-mcp-server==0.6.0'
generated from the record, not tested yet
# Generated by Hub for toolset "my-agent" (2026-10-18T22:47:37+00:00).
# Each package server runs behind a stdio->HTTP bridge and listens on localhost only.
# cp .env.example .env # fill the ${VAR}s
# docker compose up -d && bash smoke.sh
# Remote servers are not here: clients reach them directly (see clients/).
name: mcp-my-agent
services:
greptimedb:
image: ghcr.io/astral-sh/uv:python3.12-bookworm-slim
command:
- sh
- -c
- uvx mcp-proxy --host 0.0.0.0 --port 8000 --pass-environment -- uvx greptimedb-mcp-server==0.6.0
ports:
- 127.0.0.1:8101:8000
volumes:
- uv-cache:/root/.cache/uv
healthcheck:
test:
- CMD
- python3
- -c
- import urllib.request; urllib.request.urlopen('http://127.0.0.1:8000/status')
interval: 30s
timeout: 5s
retries: 5
start_period: 2m
restart: unless-stopped
environment:
GREPTIMEDB_HOST: ${GREPTIMEDB_HOST}
GREPTIMEDB_PORT: ${GREPTIMEDB_PORT}
GREPTIMEDB_USER: ${GREPTIMEDB_USER}
GREPTIMEDB_PASSWORD: ${GREPTIMEDB_PASSWORD}
GREPTIMEDB_DATABASE: ${GREPTIMEDB_DATABASE}
GREPTIMEDB_TIMEZONE: ${GREPTIMEDB_TIMEZONE}
GREPTIMEDB_POOL_SIZE: ${GREPTIMEDB_POOL_SIZE}
GREPTIMEDB_HTTP_PORT: ${GREPTIMEDB_HTTP_PORT}
GREPTIMEDB_HTTP_PROTOCOL: ${GREPTIMEDB_HTTP_PROTOCOL}
GREPTIMEDB_MASK_ENABLED: ${GREPTIMEDB_MASK_ENABLED}
GREPTIMEDB_MASK_PATTERNS: ${GREPTIMEDB_MASK_PATTERNS}
GREPTIMEDB_AUDIT_ENABLED: ${GREPTIMEDB_AUDIT_ENABLED}
GREPTIMEDB_ALLOW_WRITE: ${GREPTIMEDB_ALLOW_WRITE}
volumes:
npm-cache: {}
uv-cache: {}
generated from the record, not tested yet
# Generated by Hub for toolset "my-agent" (2026-10-18T22:47:37+00:00).
# kubectl create namespace mcp
# kubectl -n mcp create secret generic mcp-credentials --from-env-file=.env
# kubectl apply -f kubernetes.yaml
# Services are cluster-internal: <name>.mcp.svc.cluster.local:8000/mcp. Put an ingress
# with auth in front before exposing any of them.
apiVersion: v1
kind: Namespace
metadata:
name: mcp
---
apiVersion: apps/v1
kind: Deployment
metadata:
name: greptimedb
namespace: mcp
labels: &id001
app: greptimedb
spec:
replicas: 1
selector:
matchLabels: *id001
template:
metadata:
labels: *id001
spec:
containers:
- name: greptimedb
image: ghcr.io/astral-sh/uv:python3.12-bookworm-slim
ports:
- containerPort: 8000
name: http
env:
- name: GREPTIMEDB_HOST
valueFrom:
secretKeyRef:
name: mcp-credentials
key: GREPTIMEDB_HOST
- name: GREPTIMEDB_PORT
valueFrom:
secretKeyRef:
name: mcp-credentials
key: GREPTIMEDB_PORT
- name: GREPTIMEDB_USER
valueFrom:
secretKeyRef:
name: mcp-credentials
key: GREPTIMEDB_USER
- name: GREPTIMEDB_PASSWORD
valueFrom:
secretKeyRef:
name: mcp-credentials
key: GREPTIMEDB_PASSWORD
- name: GREPTIMEDB_DATABASE
valueFrom:
secretKeyRef:
name: mcp-credentials
key: GREPTIMEDB_DATABASE
- name: GREPTIMEDB_TIMEZONE
valueFrom:
secretKeyRef:
name: mcp-credentials
key: GREPTIMEDB_TIMEZONE
- name: GREPTIMEDB_POOL_SIZE
valueFrom:
secretKeyRef:
name: mcp-credentials
key: GREPTIMEDB_POOL_SIZE
- name: GREPTIMEDB_HTTP_PORT
valueFrom:
secretKeyRef:
name: mcp-credentials
key: GREPTIMEDB_HTTP_PORT
- name: GREPTIMEDB_HTTP_PROTOCOL
valueFrom:
secretKeyRef:
name: mcp-credentials
key: GREPTIMEDB_HTTP_PROTOCOL
- name: GREPTIMEDB_MASK_ENABLED
valueFrom:
secretKeyRef:
name: mcp-credentials
key: GREPTIMEDB_MASK_ENABLED
- name: GREPTIMEDB_MASK_PATTERNS
valueFrom:
secretKeyRef:
name: mcp-credentials
key: GREPTIMEDB_MASK_PATTERNS
- name: GREPTIMEDB_AUDIT_ENABLED
valueFrom:
secretKeyRef:
name: mcp-credentials
key: GREPTIMEDB_AUDIT_ENABLED
- name: GREPTIMEDB_ALLOW_WRITE
valueFrom:
secretKeyRef:
name: mcp-credentials
key: GREPTIMEDB_ALLOW_WRITE
args:
- sh
- -c
- uvx mcp-proxy --host 0.0.0.0 --port 8000 --pass-environment -- uvx greptimedb-mcp-server==0.6.0
readinessProbe:
httpGet:
path: /status
port: http
initialDelaySeconds: 10
---
apiVersion: v1
kind: Service
metadata:
name: greptimedb
namespace: mcp
spec:
selector:
app: greptimedb
ports:
- port: 8000
targetPort: http
name: http
generated from the record, not tested yet
# Generated by Hub for toolset "my-agent" (2026-10-18T22:47:37+00:00).
# Credentials come from the Secret 'mcp-credentials' (kubectl create secret generic ... --from-env-file=.env).
# Each server under `servers` is one Deployment + Service; the keys after it configure
# upstream charts a worker verified.
servers:
greptimedb:
enabled: true
replicas: 1
port: 8000
path: /mcp
container:
name: greptimedb
image: ghcr.io/astral-sh/uv:python3.12-bookworm-slim
ports:
- containerPort: 8000
name: http
env:
- name: GREPTIMEDB_HOST
valueFrom:
secretKeyRef:
name: mcp-credentials
key: GREPTIMEDB_HOST
- name: GREPTIMEDB_PORT
valueFrom:
secretKeyRef:
name: mcp-credentials
key: GREPTIMEDB_PORT
- name: GREPTIMEDB_USER
valueFrom:
secretKeyRef:
name: mcp-credentials
key: GREPTIMEDB_USER
- name: GREPTIMEDB_PASSWORD
valueFrom:
secretKeyRef:
name: mcp-credentials
key: GREPTIMEDB_PASSWORD
- name: GREPTIMEDB_DATABASE
valueFrom:
secretKeyRef:
name: mcp-credentials
key: GREPTIMEDB_DATABASE
- name: GREPTIMEDB_TIMEZONE
valueFrom:
secretKeyRef:
name: mcp-credentials
key: GREPTIMEDB_TIMEZONE
- name: GREPTIMEDB_POOL_SIZE
valueFrom:
secretKeyRef:
name: mcp-credentials
key: GREPTIMEDB_POOL_SIZE
- name: GREPTIMEDB_HTTP_PORT
valueFrom:
secretKeyRef:
name: mcp-credentials
key: GREPTIMEDB_HTTP_PORT
- name: GREPTIMEDB_HTTP_PROTOCOL
valueFrom:
secretKeyRef:
name: mcp-credentials
key: GREPTIMEDB_HTTP_PROTOCOL
- name: GREPTIMEDB_MASK_ENABLED
valueFrom:
secretKeyRef:
name: mcp-credentials
key: GREPTIMEDB_MASK_ENABLED
- name: GREPTIMEDB_MASK_PATTERNS
valueFrom:
secretKeyRef:
name: mcp-credentials
key: GREPTIMEDB_MASK_PATTERNS
- name: GREPTIMEDB_AUDIT_ENABLED
valueFrom:
secretKeyRef:
name: mcp-credentials
key: GREPTIMEDB_AUDIT_ENABLED
- name: GREPTIMEDB_ALLOW_WRITE
valueFrom:
secretKeyRef:
name: mcp-credentials
key: GREPTIMEDB_ALLOW_WRITE
args:
- sh
- -c
- uvx mcp-proxy --host 0.0.0.0 --port 8000 --pass-environment -- uvx greptimedb-mcp-server==0.6.0
readinessProbe:
httpGet:
path: /status
port: http
initialDelaySeconds: 10
# helm install my-agent helm/my-agent -n mcp
in the cloud
one click: the provider's deploy form opens filled in, in your own account- koyeb
-
The form opens with CHANGE_ME for each value you supply: GREPTIMEDB_HOST, GREPTIMEDB_PORT, GREPTIMEDB_USER, GREPTIMEDB_PASSWORD, GREPTIMEDB_DATABASE, GREPTIMEDB_TIMEZONE, GREPTIMEDB_POOL_SIZE, GREPTIMEDB_HTTP_PORT, GREPTIMEDB_HTTP_PROTOCOL, GREPTIMEDB_MASK_ENABLED, GREPTIMEDB_MASK_PATTERNS, GREPTIMEDB_AUDIT_ENABLED, GREPTIMEDB_ALLOW_WRITE. Fill them in before you deploy.
Clients connect to the service's https://…koyeb.app address plus /mcp.
- azure
-
A Container Apps environment with one app per server, each with HTTPS ingress and one replica. The portal asks for each value you supply as a secure parameter; the deployment's outputs list the endpoints.
connect to it
copy what your client needsuvx greptimedb-mcp-server==0.6.0 # env: GREPTIMEDB_HOST, GREPTIMEDB_PORT, GREPTIMEDB_USER, GREPTIMEDB_PASSWORD, GREPTIMEDB_DATABASE, GREPTIMEDB_TIMEZONE, GREPTIMEDB_POOL_SIZE, GREPTIMEDB_HTTP_PORT, GREPTIMEDB_HTTP_PROTOCOL, GREPTIMEDB_MASK_ENABLED, GREPTIMEDB_MASK_PATTERNS, GREPTIMEDB_AUDIT_ENABLED, GREPTIMEDB_ALLOW_WRITE
{
"mcpServers": {
"greptimedb": {
"command": "uvx",
"args": [
"greptimedb-mcp-server==0.6.0"
],
"env": {
"GREPTIMEDB_HOST": "${GREPTIMEDB_HOST}",
"GREPTIMEDB_PORT": "${GREPTIMEDB_PORT}",
"GREPTIMEDB_USER": "${GREPTIMEDB_USER}",
"GREPTIMEDB_PASSWORD": "${GREPTIMEDB_PASSWORD}",
"GREPTIMEDB_DATABASE": "${GREPTIMEDB_DATABASE}",
"GREPTIMEDB_TIMEZONE": "${GREPTIMEDB_TIMEZONE}",
"GREPTIMEDB_POOL_SIZE": "${GREPTIMEDB_POOL_SIZE}",
"GREPTIMEDB_HTTP_PORT": "${GREPTIMEDB_HTTP_PORT}",
"GREPTIMEDB_HTTP_PROTOCOL": "${GREPTIMEDB_HTTP_PROTOCOL}",
"GREPTIMEDB_MASK_ENABLED": "${GREPTIMEDB_MASK_ENABLED}",
"GREPTIMEDB_MASK_PATTERNS": "${GREPTIMEDB_MASK_PATTERNS}",
"GREPTIMEDB_AUDIT_ENABLED": "${GREPTIMEDB_AUDIT_ENABLED}",
"GREPTIMEDB_ALLOW_WRITE": "${GREPTIMEDB_ALLOW_WRITE}"
}
}
}
}
#!/usr/bin/env bash
# Registers every server with Claude Code (run once; `claude mcp list` to check).
set -euo pipefail
set -a; [ -f .env ] && source .env; set +a
claude mcp add greptimedb -e "GREPTIMEDB_HOST=${GREPTIMEDB_HOST}" -e "GREPTIMEDB_PORT=${GREPTIMEDB_PORT}" -e "GREPTIMEDB_USER=${GREPTIMEDB_USER}" -e "GREPTIMEDB_PASSWORD=${GREPTIMEDB_PASSWORD}" -e "GREPTIMEDB_DATABASE=${GREPTIMEDB_DATABASE}" -e "GREPTIMEDB_TIMEZONE=${GREPTIMEDB_TIMEZONE}" -e "GREPTIMEDB_POOL_SIZE=${GREPTIMEDB_POOL_SIZE}" -e "GREPTIMEDB_HTTP_PORT=${GREPTIMEDB_HTTP_PORT}" -e "GREPTIMEDB_HTTP_PROTOCOL=${GREPTIMEDB_HTTP_PROTOCOL}" -e "GREPTIMEDB_MASK_ENABLED=${GREPTIMEDB_MASK_ENABLED}" -e "GREPTIMEDB_MASK_PATTERNS=${GREPTIMEDB_MASK_PATTERNS}" -e "GREPTIMEDB_AUDIT_ENABLED=${GREPTIMEDB_AUDIT_ENABLED}" -e "GREPTIMEDB_ALLOW_WRITE=${GREPTIMEDB_ALLOW_WRITE}" -- uvx greptimedb-mcp-server==0.6.0
{
"mcpServers": {
"greptimedb": {
"command": "uvx",
"args": [
"greptimedb-mcp-server==0.6.0"
],
"env": {
"GREPTIMEDB_HOST": "${GREPTIMEDB_HOST}",
"GREPTIMEDB_PORT": "${GREPTIMEDB_PORT}",
"GREPTIMEDB_USER": "${GREPTIMEDB_USER}",
"GREPTIMEDB_PASSWORD": "${GREPTIMEDB_PASSWORD}",
"GREPTIMEDB_DATABASE": "${GREPTIMEDB_DATABASE}",
"GREPTIMEDB_TIMEZONE": "${GREPTIMEDB_TIMEZONE}",
"GREPTIMEDB_POOL_SIZE": "${GREPTIMEDB_POOL_SIZE}",
"GREPTIMEDB_HTTP_PORT": "${GREPTIMEDB_HTTP_PORT}",
"GREPTIMEDB_HTTP_PROTOCOL": "${GREPTIMEDB_HTTP_PROTOCOL}",
"GREPTIMEDB_MASK_ENABLED": "${GREPTIMEDB_MASK_ENABLED}",
"GREPTIMEDB_MASK_PATTERNS": "${GREPTIMEDB_MASK_PATTERNS}",
"GREPTIMEDB_AUDIT_ENABLED": "${GREPTIMEDB_AUDIT_ENABLED}",
"GREPTIMEDB_ALLOW_WRITE": "${GREPTIMEDB_ALLOW_WRITE}"
}
}
}
}
{
"servers": {
"greptimedb": {
"type": "stdio",
"command": "uvx",
"args": [
"greptimedb-mcp-server==0.6.0"
],
"env": {
"GREPTIMEDB_HOST": "${GREPTIMEDB_HOST}",
"GREPTIMEDB_PORT": "${GREPTIMEDB_PORT}",
"GREPTIMEDB_USER": "${GREPTIMEDB_USER}",
"GREPTIMEDB_PASSWORD": "${GREPTIMEDB_PASSWORD}",
"GREPTIMEDB_DATABASE": "${GREPTIMEDB_DATABASE}",
"GREPTIMEDB_TIMEZONE": "${GREPTIMEDB_TIMEZONE}",
"GREPTIMEDB_POOL_SIZE": "${GREPTIMEDB_POOL_SIZE}",
"GREPTIMEDB_HTTP_PORT": "${GREPTIMEDB_HTTP_PORT}",
"GREPTIMEDB_HTTP_PROTOCOL": "${GREPTIMEDB_HTTP_PROTOCOL}",
"GREPTIMEDB_MASK_ENABLED": "${GREPTIMEDB_MASK_ENABLED}",
"GREPTIMEDB_MASK_PATTERNS": "${GREPTIMEDB_MASK_PATTERNS}",
"GREPTIMEDB_AUDIT_ENABLED": "${GREPTIMEDB_AUDIT_ENABLED}",
"GREPTIMEDB_ALLOW_WRITE": "${GREPTIMEDB_ALLOW_WRITE}"
}
}
}
}
name: my-agent target: local servers: - hub: io.github.GreptimeTeam/greptimedb-mcp-server
- not probed yet: tools unpinned, ingest lists them
tools
Probe result: faileddocker: the container exited: ^ | File "<path>", line 306, in send_request | raise McpError(response_or_error.error) | mcp.shared.exceptions.McpError: Connection closed +------------------------------------; baremetal: MCPError: Connection closed; server stderr: …in main server.main() File "<path>", line 1642, in main _config = Config.from_env_arguments() ^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "<path>", line 159, in from_env_arguments default=int(os.getenv("GREPTIMEDB_POOL_SIZE", "5")), ^^^^^^^^^^^^^…
runs · 1
the latest tests of this entry by the hub and its workers, newest first| date | worker | method | status | sandbox | reason |
|---|---|---|---|---|---|
| 2026-10-17 11:58 | local-mac-vm | docker | failed | gvisor | docker: the container exited: ^ | File "<path>", line 306, in send_request | raise McpError(response_or_error.error) | mcp.shared.exceptions.McpError: Connectio… |