@GreptimeTeam
基本情報
A Model Context Protocol (MCP) server for GreptimeDB
以下の設定を使って、このサーバーを MCP 対応クライアントに追加してください。
{
"mcpServers": {
"greptimedb-mcp-server": {
"command": "uv",
"args": [
"venv",
"&&",
"source",
".venv/bin/activate"
]
}
}
}Execute SQL queries with format (csv/json/markdown) and limit options
Execute TQL (PromQL-compatible) queries for time-series analysis
Execute time-window aggregation queries with RANGE/ALIGN syntax
Inspect a table profile: schema, semantic metadata, latest sample rows, and query guidance
Analyze SQL or TQL query execution plans (`analyze=true` for runtime stats; add `verbose=true` alongside `analyze=true` for per-partition scan metrics and index-pruning counters)
Check database connection status and server version
It is a Model Context Protocol (MCP) server for GreptimeDB, an open-source observability database that handles metrics, logs, and traces. It enables AI assistants to query and analyze GreptimeDB using SQL, TQL (PromQL-compatible), and RANGE queries, with built-in security features like read-only enforcement and data masking.
Install via pip install greptimedb-mcp-server, then run greptimedb-mcp-server --host localhost --database public. For Claude Desktop, add the MCP server configuration to your claude_desktop_config.json. The server can also be started in HTTP server mode for containerized deployments.
Yes. All queries pass through a security gate that blocks DROP, DELETE, TRUNCATE, UPDATE, INSERT, ALTER, CREATE, GRANT, REVOKE, EXEC, LOAD, COPY, and encoded bypass attempts. Only SELECT, SHOW, DESCRIBE, TQL, EXPLAIN, and UNION are allowed.
Set the environment variable `GREPTIMEDB_ALLOW_WRITE=true` or use the CLI argument `--allow-write true`. This bypasses the security gate for `execute_sql` and is intended only for local development or testing, never for production.
The server supports stdio (default), SSE (legacy), and streamable-http (recommended for production). Transport is set via the `--transport` CLI argument or `GREPTIMEDB_TRANSPORT` environment variable.
A running GreptimeDB instance accessible via MySQL protocol (default port 4002) and optionally via HTTP (port 4000) for pipeline and dashboard management. Python with the installed package is required.
Yes. Data masking is enabled by default for known sensitive column names. You can add custom patterns via `--mask-patterns phone,email` or the `GREPTIMEDB_MASK_PATTERNS` environment variable.
MCP Toolbox for Databases is an open source MCP server for databases.
PickFu MCP is a Model Context Protocol (MCP) server that connects AI assistants, developers, marketers, product managers, and AI agents to PickFu's consumer research platform. It enables users to create surveys, conduct
Request dedicated senior developers to work on your project, write job descriptions, and prep technical interviews — all without leaving your Claude chat. Just describe what you need, and Lemon.io MCP does the rest. 1–3
Hindsight: Agent Memory That Learns
Handl speaks the Model Context Protocol. Your whole billing operation — projects, invoices, clients, reports, approvals — as tools any AI assistant can call, inside your autonomy rules.
コメント