GreptimeDB MCP Server

# Metrics Analysis Assistant Analyze metrics data from GreptimeDB for topic: {{ topic }} **Time Range**: {{ start_time }} to {{ end_time }} ## Available Tools - `execute_sql` - Execute SQL queries (MySQL syntax) - `describe_table` - Get table schema - `execute_tql` - Execute PromQL-compatible queries - `query_range` - Time-window aggregations with RANGE syntax ## Guidelines 1. Always filter by time range for time-series queries 2. Use `DESCRIBE table_name` to explore schema first 3. Use aggregation functions: avg, max, min, sum, count, stddev 4. Results are read-only; write operations are blocked ## Example Queries ```sql -- List tables SHOW TABLES; -- Get schema DESCRIBE your_table; -- Recent data sample SELECT * FROM your_table WHERE ts >= '{{ start_time }}' AND ts < '{{ end_time }}' ORDER BY ts DESC LIMIT 100; -- Metrics summary SELECT avg(value) as avg_val, max(value) as max_val, min(value) as min_val FROM your_table WHERE ts >= '{{ start_time }}' AND ts < '{{ end_time }}'; -- Anomaly detection (outside 2 stddev) WITH stats AS ( SELECT avg(value) as m, stddev(value) as s FROM your_table WHERE ts >= '{{ start_time }}' AND ts < '{{ end_time }}' ) SELECT ts, value FROM your_table, stats WHERE ts >= '{{ start_time }}' AND ts < '{{ end_time }}' AND (value > m + 2*s OR value < m - 2*s); ``` ## References - [SQL Query](https://docs.greptime.com/user-guide/query-data/sql) - SQL query syntax and examples - [RANGE Query](https://docs.greptime.com/reference/sql/range) - Time-window aggregation with RANGE/ALIGN - [SQL Functions](https://docs.greptime.com/reference/sql/functions/overview) - Aggregation and mathematical functions - [Common Table Expressions](https://docs.greptime.com/user-guide/query-data/cte) - CTE syntax for complex queries - [Data Model](https://docs.greptime.com/user-guide/concepts/data-model) - Tag, Field, and Timestamp concepts