greptimedb-mcp-server
Verified Safeby GreptimeTeam
Overview
Enables AI assistants to query and analyze GreptimeDB, an open-source, cloud-native, unified observability database, using SQL, TQL, and RANGE queries, with built-in security and data masking.
Installation
greptimedb-mcp-server --host localhost --database publicEnvironment Variables
- GREPTIMEDB_HOST
- GREPTIMEDB_PORT
- GREPTIMEDB_USER
- GREPTIMEDB_PASSWORD
- GREPTIMEDB_DATABASE
- GREPTIMEDB_TIMEZONE
- GREPTIMEDB_HTTP_PORT
- GREPTIMEDB_HTTP_PROTOCOL
- GREPTIMEDB_POOL_SIZE
- GREPTIMEDB_MASK_ENABLED
- GREPTIMEDB_MASK_PATTERNS
- GREPTIMEDB_AUDIT_ENABLED
- GREPTIMEDB_TRANSPORT
- GREPTIMEDB_LISTEN_HOST
- GREPTIMEDB_LISTEN_PORT
- GREPTIMEDB_ALLOWED_HOSTS
- GREPTIMEDB_ALLOWED_ORIGINS
Security Notes
The server implements a robust `security_gate` to block dangerous SQL operations (DDL, DML, dynamic SQL, file system access, encoded content) and enforces read-only access for core query tools. Sensitive data masking is applied based on configurable column name patterns. Input validation functions are used for all tool parameters to prevent injection. HTTP API calls for pipeline management (create, dryrun, delete) require authentication. While `exec()` is used for dynamic prompt registration, it's highly controlled, constructing a fixed function template and only performing string replacement for variables, which mitigates typical `exec()` risks. DNS rebinding protection and audit logging are configurable.
Similar Servers
mcp-server-starrocks
Acts as a bridge between AI assistants and StarRocks databases for direct SQL execution, database exploration, and data visualization.
teslamate-mcp
Connects a TeslaMate PostgreSQL database to AI assistants, enabling natural language queries about Tesla vehicle data and analytics.
DBchat
Transforms a database into an intelligent conversational partner, enabling natural language queries, instant answers, and data visualizations via MCP clients.
tiger-docs-mcp-server
An MCP server and Claude plugin providing AI assistants with advanced PostgreSQL knowledge through semantic documentation search and curated best practice skills.