GreptimeDB MCP Server

MCPOfficialOpen SourceMIT46.0

by GreptimeTeam • Data & Databases

An MCP server that lets AI agents securely list tables, read data, and run SQL against a GreptimeDB instance.

Example Use Cases

1
List available tables and schema information from a GreptimeDB database.
2
Read sample rows or streamed data from tables to inform analysis or generate responses.
3
Execute SQL queries against GreptimeDB and retrieve structured results securely through a controlled MCP interface.

Description

This project implements a Model Context Protocol (MCP) server for GreptimeDB, providing a controlled interface for AI assistants to explore and analyze databases. It supports listing resources (tables), reading table data, executing SQL queries, and exposing prompt/tool metadata. The server is easy to run (pip install) and can be integrated into agents or desktop clients like Claude Desktop, but it is experimental and does not yet address data security and privacy concerns.

Capabilities(17 total)

Tools (10)

execute_sql

Execute SQL query against GreptimeDB. Please use MySQL dialect.

query:string*format:stringlimit:integer

describe_table

Get table schema information including column names, types, and constraints.

table:string*

health_check

Check GreptimeDB connection status and server version.

execute_tql

Execute TQL query for time-series analysis. TQL is PromQL-compatible - use standard PromQL syntax.

query:string*start:string*end:string*step:string*lookback:anyformat:string

query_range

Execute time-window aggregation query using GreptimeDB's RANGE query syntax.

table:string*select:string*align:string*by:anywhere:anyfill:anyorder_by:anyformat:stringlimit:integer

Prompts (7)

metrics_analysis

Comprehensive metrics analysis template for monitoring and analyzing data from GreptimeDB

topicstart_timeend_time

pipeline_creator

Generate GreptimeDB pipeline YAML configuration from log samples.

log_samplepipeline_name

table_operation

Table diagnostics: schema, region health, storage analysis, and query optimization for GreptimeDB.

table

log_pipeline

Log analysis with full-text search and aggregation in GreptimeDB.

tablesearch_term

iot_monitoring

IoT device monitoring with TAG/FIELD semantics and device aggregation.

tabledevice_id

Quick Actions

View on GitHub

Security

Scanned 3 month(s) ago

Risk Level

MODERATE

Can modify files, state, or send data externally

Trust Score

C64/100

11/17 checks passed

Scores are informational only and provided “as is” without warranty. AgentHotspot assumes no liability for actions taken based on these ratings.

Quick Stats

Service TypeMCP

Pricing ModelFree

Capabilities10 Tools / 7 Prompts / 0 Resources

OwnerGreptimeTeam

CategoryData & Databases

DependenciesStandalone

Set Your Username