Loading...
pip install greptimedb-mcp-server{
"mcpServers": {
"greptimedb": {
"command": "greptimedb-mcp-server",
"args": ["--host", "localhost", "--database", "public"]
}
}
}execute_sqlExecutes SQL queries against the GreptimeDB database.
Can potentially modify data depending on the SQL query and user permissions.
execute_tqlExecutes TQL (PromQL-compatible) queries for time-series data analysis.
Read-only access to time-series data.
query_rangeExecutes time-window aggregation queries with RANGE/ALIGN syntax.
Read-only access to aggregated time-series data.
describe_tableRetrieves the schema of a specified table.
Provides read-only metadata about the table structure.
explain_queryAnalyzes the execution plan of a SQL or TQL query.
Provides read-only analysis of query execution.
health_checkChecks the database connection status and server version.
Provides read-only status information.
list_pipelinesLists all pipelines or gets details of a specific pipeline.
Provides read-only access to pipeline metadata.
create_pipelineCreates a new pipeline with YAML configuration.
Creates a new data pipeline, which can potentially impact data ingestion and processing.
dryrun_pipelineTests a pipeline with sample data without writing to the database.
Tests a pipeline without making any persistent changes.
delete_pipelineDeletes a specific version of a pipeline.
Deletes a pipeline, which can disrupt data ingestion and processing.
The GreptimeDB MCP server provides reasonable security controls, especially when configured with a read-only user and data masking enabled. However, it's crucial to properly configure allowed hosts to prevent DNS rebinding attacks and to be aware of the limitations of pattern-based data masking.