GreptimeDB MCP Server
Officialgreptimedb-mcp-сервер
Реализация сервера Model Context Protocol (MCP) для GreptimeDB .
Этот сервер предоставляет помощникам ИИ безопасный и структурированный способ исследования и анализа баз данных. Он позволяет им перечислять таблицы, читать данные и выполнять SQL-запросы через контролируемый интерфейс, обеспечивая ответственный доступ к базе данных.
Статус проекта
Это экспериментальный проект, который все еще находится в стадии разработки. Вопросы безопасности данных и конфиденциальности не были специально рассмотрены, поэтому используйте его с осторожностью.
Возможности
list_resourcesдля вывода списка таблицread_resourceдля чтения данных таблицыlist_toolsдля вывода списка инструментовcall_toolдля выполнения SQLlist_promptsдля вывода списка подсказокget_promptдля получения приглашения по имени
Установка
pip install greptimedb-mcp-serverКонфигурация
Установите следующие переменные среды:
GREPTIMEDB_HOST=localhost # Database host
GREPTIMEDB_PORT=4002 # Optional: Database MySQL port (defaults to 4002 if not specified)
GREPTIMEDB_USER=root
GREPTIMEDB_PASSWORD=
GREPTIMEDB_DATABASE=publicИли через аргументы командной строки:
--hostхост базы данных, по умолчаниюlocalhost,--portпорт базы данных, должен быть портом протокола MySQL, по умолчанию4002,--userимя пользователя базы данных, по умолчанию пусто,--passwordпароль базы данных, по умолчанию пустой,--databaseимя базы данных, по умолчаниюpublic.
Использование
Интеграция рабочего стола Клода
Настройте сервер MCP в файле конфигурации Claude Desktop:
MacOS
Расположение: ~/Library/Application Support/Claude/claude_desktop_config.json
Окна
Расположение: %APPDATA%/Claude/claude_desktop_config.json
{
"mcpServers": {
"greptimedb": {
"command": "uv",
"args": [
"--directory",
"/path/to/greptimedb-mcp-server",
"run",
"-m",
"greptimedb_mcp_server.server"
],
"env": {
"GREPTIMEDB_HOST": "localhost",
"GREPTIMEDB_PORT": "4002",
"GREPTIMEDB_USER": "root",
"GREPTIMEDB_PASSWORD": "",
"GREPTIMEDB_DATABASE": "public"
}
}
}
}Лицензия
Лицензия MIT — подробности см. в файле LICENSE.md.
Способствовать
Related MCP server: SQLite MCP Server
Предпосылки
Python с менеджером пакетов
uvУстановка GreptimeDB
Зависимости сервера MCP
Разработка
# Clone the repository
git clone https://github.com/GreptimeTeam/greptimedb-mcp-server.git
cd greptimedb-mcp-server
# Create virtual environment
uv venv
source venv/bin/activate # or `venv\Scripts\activate` on Windows
# Install development dependencies
uv sync
# Run tests
pytestИспользуйте MCP Inspector для отладки:
npx @modelcontextprotocol/inspector uv \
--directory \
/path/to/greptimedb-mcp-server \
run \
-m \
greptimedb_mcp_server.serverПризнание
Реализация этой библиотеки была вдохновлена следующими двумя репозиториями и включает их код, за что мы выражаем нашу благодарность:
Спасибо!
Available Tools
15 toolscreate_dashboardC
Create or update a Perses dashboard definition in GreptimeDB.
Inputs: name (required), definition (required). Returns: result
create_pipelineC
Create a new pipeline in GreptimeDB.
Inputs: name (required), pipeline (required). Returns: result
delete_dashboardC
Delete a Perses dashboard definition from GreptimeDB.
Inputs: name (required). Returns: result
delete_pipelineB
Delete a specific version of a pipeline from GreptimeDB.
Inputs: name (required), version (required). Returns: result
describe_tableA
Get a table profile: schema, semantic metadata, sample rows, and guidance.
Use it when deciding how to query an unfamiliar table. When the right table
is not known yet, search_table_semantics first; describing candidates one
by one is slower than querying the data.
The semantic profile says what the table means, not what its data says.
signal_type is metric, log, trace, or event; source and source_version name
the ingestion protocol; pipeline names the schema that shaped the rows;
semantic_options carries signal-specific facts such as metric type and
unit. metadata_quality describes how the metric type was obtained --
`declared` by the protocol or `inferred` from the name -- and says nothing
about telemetry quality. entity_declarations lists the entities the table
contributes to the semantic graph. A null or missing semantic field means
unknown, not the opposite fact.
Inputs: table (required), sample_limit, include_samples, include_semantics. Returns: result
dryrun_pipelineA
Test a pipeline with sample data without writing to the database.
You can test a pipeline in two ways:
- Provide 'pipeline' with inline YAML configuration
- Provide 'pipeline_name' to test a previously saved pipeline
Args:
pipeline: Pipeline YAML configuration (inline)
pipeline_name: Name of saved pipeline (mutually exclusive with pipeline)
data: Test data in JSON/NDJSON format
data_type: Optional content type (e.g., 'application/x-ndjson')
Inputs: data, pipeline, data_type, pipeline_name. Returns: result
execute_sqlA
Execute SQL query against GreptimeDB. Please use MySQL dialect.
Read-only by default. When the server runs with write mode enabled
(--allow-write / GREPTIMEDB_ALLOW_WRITE), destructive SQL (DDL/DML) is
also permitted.
Inputs: query (required), limit, format. Returns: result
execute_tqlC
Execute TQL query for time-series analysis. TQL is PromQL-compatible - use standard PromQL syntax.
Inputs: end (required), step (required), query (required), start (required), +2 more. Returns: result
explain_queryC
Analyze SQL or TQL query execution plan.
Inputs: query (required), analyze, verbose. Returns: result
health_checkA
Check GreptimeDB connection status and server version.
Inputs: no named parameters. Returns: result
list_dashboardsA
List all Perses dashboard definitions stored in GreptimeDB.
Inputs: no named parameters. Returns: result
list_pipelinesC
List all pipelines or get details of a specific pipeline.
Inputs: name. Returns: result
query_rangeC
Execute time-window aggregation query using GreptimeDB's RANGE query syntax.
Inputs: align (required), table (required), select (required), by, +5 more. Returns: result
query_semantic_graphA
Query the semantic graph: which entities exist and which are related.
Use view=summary when the entity and relationship types in this graph are
not known yet; it reports them with the endpoint type pairs each
relationship connects. With a type or an id already in hand, query
entities or relationships directly.
The window is required and half-open, [start_time, end_time), over
observed_at -- the 60-second bucket an observation was recorded in. Rows
are aggregated across the buckets in the window, and the result echoes the
window and the limit it used.
relationships returns one row per edge per confidence. The database reports
confidence 1.0 for a bucket whose client and server spans paired and 0.5
for one where only the client was seen, and it switches request_count,
error_count and the durations to whichever population that bucket
describes: paired requests timed by the server span, or unmatched clients
timed by their own. An edge observed both ways therefore comes back as two
rows. unmatched_count reports client spans with no paired server span.
Durations are in seconds.
entities returns one row per distinct set of attributes, so an entity whose
descriptive attributes changed inside the window appears more than once;
item_count counts rows, not entities. first_seen and last_seen bound where
the row was observed inside this window, not when the entity first existed.
Ordering is by type and endpoint. Only `calls` edges carry request, error
and duration counts, so pass rel_type=calls to order by error and request
count instead. When complete is false, more rows matched than the limit and
later types may be absent entirely rather than merely cut short.
A missing edge is not evidence that two entities are unrelated: it can also
mean the call was not instrumented, was sampled out, or fell outside this
window. Entities are not deduplicated across identity schemes, so one
process can appear under two ids if two sources named it differently.
entity_id_attrs names the attributes an id was assembled from and
source_tables names the telemetry tables that witnessed it. Identifiers
from alerts and other tools are not graph ids unless a query here returned
that exact string.
When masking is on, a returned field is hidden if its own name matches a
sensitive pattern, and an attribute map is also masked by the names inside
it. entities additionally hides entity_id when a masked attribute helped
build it; relationships cannot do the same, because its view does not carry
attribute names, so such a value can still appear there as src_id or
dst_id.
Inputs: view (required), end_time (required), start_time (required), limit, +9 more. Returns: result
search_table_semanticsA
Find tables by observability concept when the right table name is unknown.
Searches table names, semantic options, and entity declarations, and ranks
tables by how many query terms they matched. Use it before describe_table
when the schema is wide or table names do not say what they hold.
It searches schema metadata only, never telemetry row values, so it can say
which table holds Redis memory usage but not which row belongs to
`Redis02`. It ranks on the values in that metadata, not on the schema's own
key names, so search for `gauge` or `bytes` rather than `metric type`. Once
it returns candidates, query their data or describe one of them; do not
describe every candidate in turn.
It covers only the database this server is connected to, unlike
describe_table, which accepts a schema-qualified name.
Only tables carrying a `greptime.semantic.*` option, or one a built-in
convention derives a declaration for, are visible here. A table absent from
the results may still exist and hold the data, so fall back to SHOW TABLES
rather than concluding it is not there.
Inputs: query (required), limit, signal_type. Returns: result
Tool Schema Changelog
Recent tool additions, removals, and schema changes observed during successful MCP inspections.
Loading tool schema changelog…
TDQS
Scored across 15 tools
Each tool targets a distinct resource and action: health, table/semantic metadata, query execution, pipeline lifecycle, and dashboard lifecycle. Even overlapping tools like search_table_semantics and describe_table are explicitly differentiated in their descriptions.
Most names follow a consistent verb_noun snake_case pattern such as execute_sql, list_pipelines, and create_dashboard. health_check is a minor outlier since it is a noun compound rather than check_health, but it does not create real confusion.
At 15 tools, the server sits at the upper edge of the ideal range but remains well-scoped. Each tool supports a distinct workflow covering health, metadata discovery, multiple query modes, pipeline management, and dashboards.
The core workflows are well covered: health checks, table discovery, semantic graph queries, SQL/TQL/range querying with explain support, pipeline lifecycle operations, and dashboard CRUD. The main gap is the lack of an explicit pipeline update/edit tool, though create_pipeline and versioned deletion may partially cover this.
Maintenance
Related MCP Connectors
A comprehensive Model Context Protocol (MCP) server that enables AI assistants to interact with yo…
Model Context Protocol server for the Apideck Unified API. Connect any MCP-compatible agent framework to 100+ accounting systems, HRIS platforms, file storage providers, and more through one integration. More information https://www.apideck.com/mcp-server
Text-to-SQL MCP server: read-only queries on PostgreSQL, MySQL and SQL Server with your real schema
A Model Context Protocol server for Wix AI tools
Related MCP Servers
- AlicenseBqualityDmaintenanceA Model Context Protocol server that enables AI assistants to securely interact with ClickHouse databases, supporting table exploration and SQL query execution through a controlled interface.18Apache 2.0
- AlicenseNot gradedqualityDmaintenanceA Model Context Protocol server implementation that enables AI assistants to execute SQL queries and interact with SQLite databases through a structured interface.7MIT
- AlicenseBqualityCmaintenanceA Model Context Protocol (MCP) server that provides read-only TDengine database queries for AI assistants, allowing users to execute queries, explore database structures, and investigate data directly from AI-powered tools.611MIT
- AlicenseNot gradedqualityDmaintenanceA Model Context Protocol server that provides AI assistants with comprehensive access to SQL databases, enabling schema inspection, query execution, and database operations with enterprise-grade security.62 npm9MIT