timesfm
TimesFM (Time Series Foundation Model) is a pretrained time-series foundation model developed by Google Research for time-series forecasting.
Query GreptimeDB metrics, logs and traces with SQL, TQL and RANGE. Manage pipelines and dashboards.
Skills that teach the AI this kind of work; they work alongside this one
TimesFM (Time Series Foundation Model) is a pretrained time-series foundation model developed by Google Research for time-series forecasting.
Open-source intelligence for the global theater. Track everything from the corporate/private jets of the wealthy, and spy satellites, to seismic events in one unified interface. Hook an AI agent up to have it parse through data and find previously unseen correlations. The knowledge is available to…
scrape data from Google Maps. Extracts data such as the name, address, phone number, website URL, rating, reviews number, latitude and longitude, reviews,email and more for each place
Lists are ordered by a usage score (out of 100) built from these parts
| Popularity | 18/80 | GitHub stars or weekly downloads: the larger counts 60, the smaller 20 |
|---|---|---|
| Freshness | 12/12 | Full marks for a release or code change within 30 days |
| Still answering | 0/8 | The cloud endpoint answered at the last check |
| Usage score | 30/100 |
Quality: Passed 3/3 basic checks (shown, not used for ordering) · Momentum: No data yet (Used only on the Trending tab)
Pick the AI app you use, then copy the settings.
Let your AI install it with one sentence
Please install Greptimedb MCP Server. Follow https://mcp.popnx.com/i/greptimeteam-greptimedb-mcp-server.md, show me the commands and wait for my OK before running them.Paste it into an AI that can work on your computer (such as Claude Code or Cursor). It reads our steps, shows you the commands and waits for your OK. No key, no sign-up. · See the full text your AI reads
Passed 3/3 checks · Runs on your computer · ✓ Commands checked Nov 14, 2026
First: which AI do you use?
Pick your app and the steps appear below.
Copy this message into a Claude chat. The AI checks your computer, tells you which file it will change, and waits for your OK every time.
Please install the MCP server Greptimedb MCP Server for Claude on this computer, in this order: 1) Check uv with uv --version. If it is missing, tell me to install it from https://docs.astral.sh/uv/getting-started/installation/; do not install it yourself. 2) Use only this config (already checked by PopNx MCP): { "mcpServers": { "greptimedb": { "command": "uvx", "args": [ "greptimedb-mcp-server" ], "env": { "GREPTIMEDB_PASSWORD": "your-value" } } } } 3) Tell me the full path of the file you will change, or the command you will run, and wait for my OK. 4) For GREPTIMEDB_PASSWORD, leave "your-value" in place and tell me to paste the real value myself into the file or the app’s field. Never ask me to type a key in chat. 5) Do what we agreed, then check that the Greptimedb MCP Server tools really show up.This message has no key in it. If a key is needed, the AI will ask you to paste it yourself into the file or the app’s field.
Already installed? Check first · Open Terminal, type this command and press Enter
uv --versionMac: press ⌘ + Space, type Terminal, press Enter
Windows: open Start, type Windows PowerShell, then Open
Not installed: uv has no click-through installer. Copy the one-line command for your system (macOS or Windows) from uv’s official page into Terminal · no separate Python install needed; uv downloads it when required
When it’s done, close Terminal, open it again and run the same command. You should see a version number: uv --version
Install once; it works for everything that needs uv
Open the maker’s site, sign up and create an API key for the next step. Check the maker’s site for pricing and free plans.
How to get a key is in the maker’s README below
SettingsDeveloperEdit Config
{
"mcpServers": {
"greptimedb": {
"command": "uvx",
"args": [
"greptimedb-mcp-server"
],
"env": {
"GREPTIMEDB_PASSWORD": "your-value"
}
}
}
}Paste the key only into the app’s field, never into a chat or to anyone
Use Greptimedb MCP Server and tell me what you can do for me, then show me one thing✓ If Claude says it is using Greptimedb MCP Server or shows a Greptimedb MCP Server tool in the answer, you are connected
The command above works without these. Add them only if you want to change something, following the maker’s description.
GREPTIMEDB_HOST GreptimeDB host addressGREPTIMEDB_PORT GreptimeDB MySQL protocol port (default: 4002)GREPTIMEDB_USER Database usernameGREPTIMEDB_DATABASE Database name to connect toGREPTIMEDB_TIMEZONE Session timezone (default: UTC)GREPTIMEDB_POOL_SIZE Connection pool size (default: 5)GREPTIMEDB_HTTP_PORT HTTP API port for pipeline/dashboard management (default: 4000)GREPTIMEDB_HTTP_PROTOCOL HTTP protocol for pipeline/dashboard API: http or https (default: http)GREPTIMEDB_MASK_ENABLED Enable sensitive data masking (default: true)GREPTIMEDB_MASK_PATTERNS Additional column name patterns for data masking (comma-separated)GREPTIMEDB_AUDIT_ENABLED Enable audit logging for tool invocations (default: true)GREPTIMEDB_ALLOW_WRITE Allow write/destructive SQL (DDL/DML) via execute_sql by skipping the security gate. DANGEROUS: only use on local or test instances (default: false)Descriptions are as written by the maker.
Menu names checked against Anthropic’s help page on Nov 11, 2026 · your screen may differ slightly by app version
ChatGPT cannot connect Greptimedb MCP Server yet
Greptimedb MCP Server runs on your computer, but ChatGPT can only connect servers that run on the web
A · Use an app that can connect Greptimedb MCP Server
B · Others in Databases & datasets that work with ChatGPT
Picked from the most used in the same category, only ones that connect by address with no key
Works with Claude Code, with some setup first
You need a Greptimedb MCP Server key (create it on the maker’s site) · Install Python (uv) on your computer first (one time)
Copy this message into a Claude Code chat. The AI checks your computer, tells you which file it will change, and waits for your OK every time.
Please install the MCP server Greptimedb MCP Server for Claude Code on this computer, in this order: 1) Check uv with uv --version. If it is missing, tell me to install it from https://docs.astral.sh/uv/getting-started/installation/; do not install it yourself. 2) Use only this config (already checked by PopNx MCP): claude mcp add --scope user greptimedb --env GREPTIMEDB_PASSWORD=your-value -- uvx greptimedb-mcp-server 3) Tell me the full path of the file you will change, or the command you will run, and wait for my OK. 4) For GREPTIMEDB_PASSWORD, leave "your-value" in place and tell me to paste the real value myself into the file or the app’s field. Never ask me to type a key in chat. 5) Do what we agreed, then check that the Greptimedb MCP Server tools really show up.This message has no key in it. If a key is needed, the AI will ask you to paste it yourself into the file or the app’s field.
Already installed? Check first · Open Terminal, type this command and press Enter
uv --versionMac: press ⌘ + Space, type Terminal, press Enter
Windows: open Start, type Windows PowerShell, then Open
Not installed: uv has no click-through installer. Copy the one-line command for your system (macOS or Windows) from uv’s official page into Terminal · no separate Python install needed; uv downloads it when required
When it’s done, close Terminal, open it again and run the same command. You should see a version number: uv --version
Install once; it works for everything that needs uv
Open the maker’s site, sign up and create an API key for the next step. Check the maker’s site for pricing and free plans.
How to get a key is in the maker’s README below
Mac: press Command+Space and type Terminal · Windows: open PowerShell
claude mcp add --scope user greptimedb --env GREPTIMEDB_PASSWORD=your-value -- uvx greptimedb-mcp-serverReplace “your-value” with your key before pressing Enter
Paste the key only into the app’s field, never into a chat or to anyone
You should see Greptimedb MCP Server listed as connected
Use Greptimedb MCP Server and tell me what you can do for me, then show me one thing✓ If Claude Code says it is using Greptimedb MCP Server or shows a Greptimedb MCP Server tool in the answer, you are connected
The command above works without these. Add them only if you want to change something, following the maker’s description.
GREPTIMEDB_HOST GreptimeDB host addressGREPTIMEDB_PORT GreptimeDB MySQL protocol port (default: 4002)GREPTIMEDB_USER Database usernameGREPTIMEDB_DATABASE Database name to connect toGREPTIMEDB_TIMEZONE Session timezone (default: UTC)GREPTIMEDB_POOL_SIZE Connection pool size (default: 5)GREPTIMEDB_HTTP_PORT HTTP API port for pipeline/dashboard management (default: 4000)GREPTIMEDB_HTTP_PROTOCOL HTTP protocol for pipeline/dashboard API: http or https (default: http)GREPTIMEDB_MASK_ENABLED Enable sensitive data masking (default: true)GREPTIMEDB_MASK_PATTERNS Additional column name patterns for data masking (comma-separated)GREPTIMEDB_AUDIT_ENABLED Enable audit logging for tool invocations (default: true)GREPTIMEDB_ALLOW_WRITE Allow write/destructive SQL (DDL/DML) via execute_sql by skipping the security gate. DANGEROUS: only use on local or test instances (default: false)Descriptions are as written by the maker.
Menu names checked against Anthropic’s help page on Nov 11, 2026 · your screen may differ slightly by app version
Works with Cursor, with some setup first
You need a Greptimedb MCP Server key (create it on the maker’s site) · Install Python (uv) on your computer first (one time)
Copy this message into a Cursor chat. The AI checks your computer, tells you which file it will change, and waits for your OK every time.
Please install the MCP server Greptimedb MCP Server for Cursor on this computer, in this order: 1) Check uv with uv --version. If it is missing, tell me to install it from https://docs.astral.sh/uv/getting-started/installation/; do not install it yourself. 2) Use only this config (already checked by PopNx MCP): { "mcpServers": { "greptimedb": { "command": "uvx", "args": [ "greptimedb-mcp-server" ], "env": { "GREPTIMEDB_PASSWORD": "your-value" } } } } 3) Tell me the full path of the file you will change, or the command you will run, and wait for my OK. 4) For GREPTIMEDB_PASSWORD, leave "your-value" in place and tell me to paste the real value myself into the file or the app’s field. Never ask me to type a key in chat. 5) Do what we agreed, then check that the Greptimedb MCP Server tools really show up.This message has no key in it. If a key is needed, the AI will ask you to paste it yourself into the file or the app’s field.
Already installed? Check first · Open Terminal, type this command and press Enter
uv --versionMac: press ⌘ + Space, type Terminal, press Enter
Windows: open Start, type Windows PowerShell, then Open
Not installed: uv has no click-through installer. Copy the one-line command for your system (macOS or Windows) from uv’s official page into Terminal · no separate Python install needed; uv downloads it when required
When it’s done, close Terminal, open it again and run the same command. You should see a version number: uv --version
Install once; it works for everything that needs uv
Open the maker’s site, sign up and create an API key for the next step. Check the maker’s site for pricing and free plans.
How to get a key is in the maker’s README below
In the Greptimedb MCP Server settings, GREPTIMEDB_PASSWORD is empty; add your key and save
Paste the key only into the app’s field, never into a chat or to anyone
Use Greptimedb MCP Server and tell me what you can do for me, then show me one thing✓ If Cursor says it is using Greptimedb MCP Server or shows a Greptimedb MCP Server tool in the answer, you are connected
The command above works without these. Add them only if you want to change something, following the maker’s description.
GREPTIMEDB_HOST GreptimeDB host addressGREPTIMEDB_PORT GreptimeDB MySQL protocol port (default: 4002)GREPTIMEDB_USER Database usernameGREPTIMEDB_DATABASE Database name to connect toGREPTIMEDB_TIMEZONE Session timezone (default: UTC)GREPTIMEDB_POOL_SIZE Connection pool size (default: 5)GREPTIMEDB_HTTP_PORT HTTP API port for pipeline/dashboard management (default: 4000)GREPTIMEDB_HTTP_PROTOCOL HTTP protocol for pipeline/dashboard API: http or https (default: http)GREPTIMEDB_MASK_ENABLED Enable sensitive data masking (default: true)GREPTIMEDB_MASK_PATTERNS Additional column name patterns for data masking (comma-separated)GREPTIMEDB_AUDIT_ENABLED Enable audit logging for tool invocations (default: true)GREPTIMEDB_ALLOW_WRITE Allow write/destructive SQL (DDL/DML) via execute_sql by skipping the security gate. DANGEROUS: only use on local or test instances (default: false)Descriptions are as written by the maker.
Menu names checked against Cursor’s help page on Nov 11, 2026 · your screen may differ slightly by app version
Works with VS Code, with some setup first
You need a Greptimedb MCP Server key (create it on the maker’s site) · Install Python (uv) on your computer first (one time)
Copy this message into a VS Code chat. The AI checks your computer, tells you which file it will change, and waits for your OK every time.
Please install the MCP server Greptimedb MCP Server for VS Code on this computer, in this order: 1) Check uv with uv --version. If it is missing, tell me to install it from https://docs.astral.sh/uv/getting-started/installation/; do not install it yourself. 2) Use only this config (already checked by PopNx MCP): { "servers": { "greptimedb": { "type": "stdio", "command": "uvx", "args": [ "greptimedb-mcp-server" ], "env": { "GREPTIMEDB_PASSWORD": "your-value" } } } } 3) Tell me the full path of the file you will change, or the command you will run, and wait for my OK. 4) For GREPTIMEDB_PASSWORD, leave "your-value" in place and tell me to paste the real value myself into the file or the app’s field. Never ask me to type a key in chat. 5) Do what we agreed, then check that the Greptimedb MCP Server tools really show up.This message has no key in it. If a key is needed, the AI will ask you to paste it yourself into the file or the app’s field.
Already installed? Check first · Open Terminal, type this command and press Enter
uv --versionMac: press ⌘ + Space, type Terminal, press Enter
Windows: open Start, type Windows PowerShell, then Open
Not installed: uv has no click-through installer. Copy the one-line command for your system (macOS or Windows) from uv’s official page into Terminal · no separate Python install needed; uv downloads it when required
When it’s done, close Terminal, open it again and run the same command. You should see a version number: uv --version
Install once; it works for everything that needs uv
Open the maker’s site, sign up and create an API key for the next step. Check the maker’s site for pricing and free plans.
How to get a key is in the maker’s README below
In the Greptimedb MCP Server settings, GREPTIMEDB_PASSWORD is empty; add your key and save
Paste the key only into the app’s field, never into a chat or to anyone
Use Greptimedb MCP Server and tell me what you can do for me, then show me one thing✓ If VS Code says it is using Greptimedb MCP Server or shows a Greptimedb MCP Server tool in the answer, you are connected
The command above works without these. Add them only if you want to change something, following the maker’s description.
GREPTIMEDB_HOST GreptimeDB host addressGREPTIMEDB_PORT GreptimeDB MySQL protocol port (default: 4002)GREPTIMEDB_USER Database usernameGREPTIMEDB_DATABASE Database name to connect toGREPTIMEDB_TIMEZONE Session timezone (default: UTC)GREPTIMEDB_POOL_SIZE Connection pool size (default: 5)GREPTIMEDB_HTTP_PORT HTTP API port for pipeline/dashboard management (default: 4000)GREPTIMEDB_HTTP_PROTOCOL HTTP protocol for pipeline/dashboard API: http or https (default: http)GREPTIMEDB_MASK_ENABLED Enable sensitive data masking (default: true)GREPTIMEDB_MASK_PATTERNS Additional column name patterns for data masking (comma-separated)GREPTIMEDB_AUDIT_ENABLED Enable audit logging for tool invocations (default: true)GREPTIMEDB_ALLOW_WRITE Allow write/destructive SQL (DDL/DML) via execute_sql by skipping the security gate. DANGEROUS: only use on local or test instances (default: false)Descriptions are as written by the maker.
Menu names checked against VS Code’s help page on Nov 11, 2026 · your screen may differ slightly by app version
Other apps that use MCP, such as Windsurf, Zed or Gemini CLI, each add servers differently. See how in the app list.
JSON settings are under “For developers” below
Claude Code
claude mcp add --scope user greptimedb --env GREPTIMEDB_PASSWORD=your-value -- uvx greptimedb-mcp-serverClaude Desktop (claude_desktop_config.json)
{
"mcpServers": {
"greptimedb": {
"command": "uvx",
"args": [
"greptimedb-mcp-server"
],
"env": {
"GREPTIMEDB_PASSWORD": "your-value"
}
}
}
}Cursor (~/.cursor/mcp.json)
{
"mcpServers": {
"greptimedb": {
"command": "uvx",
"args": [
"greptimedb-mcp-server"
],
"env": {
"GREPTIMEDB_PASSWORD": "your-value"
}
}
}
}VS Code (mcp.json)
{
"servers": {
"greptimedb": {
"type": "stdio",
"command": "uvx",
"args": [
"greptimedb-mcp-server"
],
"env": {
"GREPTIMEDB_PASSWORD": "your-value"
}
}
}
}GREPTIMEDB_HOST envGREPTIMEDB_PORT envGREPTIMEDB_USER envGREPTIMEDB_PASSWORD secret required envGREPTIMEDB_DATABASE envGREPTIMEDB_TIMEZONE envGREPTIMEDB_POOL_SIZE envGREPTIMEDB_HTTP_PORT envGREPTIMEDB_HTTP_PROTOCOL envGREPTIMEDB_MASK_ENABLED envGREPTIMEDB_MASK_PATTERNS envGREPTIMEDB_AUDIT_ENABLED envGREPTIMEDB_ALLOW_WRITE envDescriptions are as written by the maker.
These settings are generated from the maker’s registry entry. If the README says otherwise, follow the README.
Based on how this server connects and on each app’s own docs, checked Nov 10, 2026.
Run on your computer in
ClaudeGooseLM StudioMsty StudioCherry StudioCursorVS Code + GitHub CopilotVisual StudioWindsurf (Devin Desktop)ZedKiroClineContinueJetBrains AI AssistantClaude CodeCodex CLIGemini CLIOpenCodenodecodeWarpLibreChatRaycast
Runs on your computer; the tool list appears in your AI app after you install it.
We check information anyone can see; we have not read the code. Checks that do not apply are left out of the count. · Checked Nov 18, 2026
The registry name was verified with the GitHub account GreptimeTeam, which owns the repo
Code last changed yesterday
Uses MIT
This one runs on your computer; there is no internet endpoint
Runs on your computer and uses local settings instead
Runs on your computer; we can only read tool lists from internet endpoints
No entries on OSV.dev for greptimedb-mcp-server@0.6.0
Checks only this package version, not every dependency · checked Nov 15, 2026
If you made this, paste this code into your README. The badge links back to this page.
[](https://mcp.popnx.com/en/servers/greptimeteam-greptimedb-mcp-server)Ask, share a tip or report that it does not work. Sorted by what people marked helpful.
No posts yet. Be the first to ask or share.
Posts here are written by users, not the PopNx team.
No reviews yet
Compared with every active server in this category in the registry. Stars count only when the publisher owns the repo.
It passed 3 of 3 applicable basic checks. We have not read the code. Before adding a key or token, see what access the server asks for and use a key with only the permissions you need.
You need to fill in: GREPTIMEDB_PASSWORD
It runs on your computer. Your AI app starts it when needed, and data does not pass through the maker’s servers (unless it calls an online service itself).
The GitHub repo last changed yesterday, and the latest version (0.6.0) reached the registry 2 months ago.
Apps that support MCP, such as Claude Desktop, Claude Code, Cursor and VS Code. You also need Python (uv) on your computer.
In the same category: QueryWeaver, Supabase, Neon, DBCode, Keboola MCP
Same category, other makers, commands already checked. Official ones first, then by stars.
Reading a card:↓ Downloads per weeki★ GitHub starsiThree pillars: reviews · checks · usageiUpdated = latest version published to the registryi
An MCP server for Text2SQL: transforms natural language into SQL using graph schema understanding.
Supabase’s official server lets AI create tables, query data and review project settings in your Supabase database.
Official Neon MCP server for managing Neon projects and Lakebase Postgres databases.
Query and explore 100+ databases through your DBCode connections.
Connect your AI assistants to Keboola and expose your data, transformations, SQL queries, ...
| This one Greptimedb MCP Server | QueryWeaver | Supabase | Neon | DBCode | Keboola MCP | |
|---|---|---|---|---|---|---|
| Runs where | Installs on your computer | Installs on your computer | Cloud or install on your computer | Runs in the cloud, nothing to install | Installs on your computer | Cloud or install on your computer |
| Needs a key | Yes | No | Yes | No | No | No |
| Add with + in Claude | No | No | Yes | Yes | No | No |
| Basic checks | 3/3 | 3/3 | 5/5 | 5/5 | 2/3 | 5/5 |
| License | MIT | AGPL-3.0 | Apache-2.0 | MIT | NOASSERTION | MIT |
| Price | No cost listed in the registry | No cost listed in the registry | No cost listed in the registry | No cost listed in the registry | No cost listed in the registry | No cost listed in the registry |
Copied from the maker’s repo as written. PopNx MCP has not reviewed or endorsed it. HTML, images and scripts are removed. Links lead off this site.
A Model Context Protocol (MCP) server for GreptimeDB — an open-source observability database that handles metrics, logs, and traces in one engine.
Enables AI assistants to query and analyze GreptimeDB using SQL, TQL (PromQL-compatible), and RANGE queries, with built-in security features like read-only enforcement and data masking.
# Install
pip install greptimedb-mcp-server
greptimedb-mcp-server --host localhost --database public
For Claude Desktop, add this to your config (~/Library/Application Support/Claude/claude_desktop_config.json on macOS):
{
"mcpServers": { "greptimedb": { "command": "greptimedb-mcp-server", "args": ["--host", "localhost", "--database", "public"] } } }
| Tool | Description |
|---|---|
execute_sql | Execute SQL queries with format (csv/json/markdown) and limit options |
execute_tql | Execute TQL (PromQL-compatible) queries for time-series analysis |
query_range | Execute time-window aggregation queries with RANGE/ALIGN syntax |
search_table_semantics | Find tables by observability concept, ranked by matched terms; searches table names, semantic options, and entity declarations. schema selects the database to search |
query_semantic_graph | Query the semantic graph: summary (what it contains), entities (nodes), relationships (edges) over a required time window |
describe_table | Inspect a table profile: schema, semantic metadata, latest sample rows, and query guidance |
explain_query | Analyze SQL or TQL query execution plans (analyze=true for runtime stats; add verbose=true alongside analyze=true for per-partition scan metrics and index-pruning counters) |
health_check | Check database connection status and server version |
search_table_semantics and the semantic metadata in describe_table read information_schema.table_semantics. A table appears there when it carries a greptime.semantic.* option or a built-in convention derives an entity declaration for it; other tables are absent. The server reads the view's column list once per process and selects only the columns it exposes. entity_declarations requires GreptimeDB 1.3; on earlier versions it is reported as a missing column rather than as an empty declaration set.
Tool results are bounded by GREPTIMEDB_MAX_RESULT_BYTES (default 1048576, or 1 MiB). A query result over the budget returns fewer rows and reports it in truncated and truncation_reason; a result with no rows to shed is cut with a notice at the end. The budget is a backstop against a result too large to be consumed, so lower it if your MCP client rejects results before it is reached.
The server connects to one database, but reads are not restricted to it:
| Tool | How to reach another database |
|---|---|
execute_sql, query_range, describe_table | Qualify the table as schema.table |
execute_tql | metric{__schema__="other_db"}, which accepts = only |
search_table_semantics | Pass schema |
query_semantic_graph | Catalog-wide already; no scoping needed |
The connected account needs read permission on the target database. Use SHOW DATABASES to list them.
query_semantic_graph reads greptime_private.semantic_entities and greptime_private.semantic_relationships, which require GreptimeDB 1.3. At startup the server checks that both views exist, carry the columns it reads, and are readable by the connected account; when they are not, the tool is not offered and the reason is logged. Its time window is required and half-open, [start_time, end_time) over observed_at, and rows are aggregated across the 60-second observation buckets in that window.
| Tool | Description |
|---|---|
list_pipelines | List all pipelines or get details of a specific pipeline |
create_pipeline | Create a new pipeline with YAML configuration |
dryrun_pipeline | Test a pipeline with sample data without writing to database |
delete_pipeline | Delete a specific version of a pipeline |
| Tool | Description |
|---|---|
list_dashboards | List all Perses dashboard definitions |
create_dashboard | Create or update a Perses dashboard definition |
delete_dashboard | Delete a dashboard definition |
greptime:// /data URIspipeline_creator, log_pipeline, metrics_analysis, promql_analysis, trace_analysis, table_operation, schema_design_advisor, observability_correlation, ingestion_troubleshooting, query_performance_tuningFor LLM integration and prompt usage, see docs/llm-instructions.md.
These tools cover querying and managing data in an existing GreptimeDB. For deployment, server configuration, write protocols, pipeline syntax, schema design, and performance diagnosis, point the assistant at the GreptimeDB skills index at https://docs.greptime.com/SKILL.md.
GREPTIMEDB_HOST=localhost # Database host
GREPTIMEDB_PORT=4002 # MySQL protocol port (default: 4002) GREPTIMEDB_USER=root # Database user GREPTIMEDB_PASSWORD= # Database password GREPTIMEDB_DATABASE=public # Database name GREPTIMEDB_TIMEZONE=UTC # Session timezone
GREPTIMEDB_HTTP_PORT=4000 # HTTP API port for pipeline/dashboard management GREPTIMEDB_HTTP_PROTOCOL=http # HTTP protocol (http/https) GREPTIMEDB_POOL_SIZE=5 # Connection pool size GREPTIMEDB_MASK_ENABLED=true # Enable sensitive data masking GREPTIMEDB_MASK_PATTERNS= # Additional patterns (comma-separated) GREPTIMEDB_AUDIT_ENABLED=true # Enable audit logging GREPTIMEDB_ALLOW_WRITE=false # Allow writes: DDL/DML plus pipeline and dashboard changes (DANGEROUS, local/test only) GREPTIMEDB_MAX_RESULT_BYTES=1048576 # Byte budget for a single tool result (1 MiB)
GREPTIMEDB_TRANSPORT=stdio # stdio, sse, or streamable-http GREPTIMEDB_LISTEN_HOST=0.0.0.0 # HTTP server bind host GREPTIMEDB_LISTEN_PORT=8080 # HTTP server bind port GREPTIMEDB_ALLOWED_HOSTS= # DNS rebinding protection (comma-separated) GREPTIMEDB_ALLOWED_ORIGINS= # CORS allowed origins (comma-separated)
greptimedb-mcp-server \
--host localhost \ --port 4002 \ --database public \ --user root \ --password "" \ --timezone UTC \ --pool-size 5 \ --mask-enabled true \ --allow-write false \ --transport stdio
For containerized or Kubernetes deployments:
# Streamable HTTP (recommended for production)
greptimedb-mcp-server --transport streamable-http --listen-port 8080
greptimedb-mcp-server --transport sse --listen-port 3000
By default, DNS rebinding protection is disabled for compatibility with proxies, gateways, and Kubernetes services. To enable it, use --allowed-hosts:
# Enable DNS rebinding protection with allowed hosts
greptimedb-mcp-server --transport streamable-http \ --allowed-hosts "localhost:*,127.0.0.1:*,my-service.namespace:*"
greptimedb-mcp-server --transport streamable-http \ --allowed-hosts "my-service.namespace:*" \ --allowed-origins "http://localhost:*,https://my-app.example.com"
GREPTIMEDB_ALLOWED_HOSTS="localhost:*,my-service.namespace:*" \ GREPTIMEDB_ALLOWED_ORIGINS="http://localhost:*" \ greptimedb-mcp-server --transport streamable-http
If you encounter 421 Invalid Host Header errors, either disable protection (default) or add your host to the allowed list.
Create a read-only user in GreptimeDB using static user provider:
mcp_readonly:readonly=your_secure_password
All queries go through a security gate that:
The server is read-only by default. Write mode enables every operation that changes stored state:
CREATE, DROP, ALTER, INSERT, UPDATE, DELETE) through execute_sqlcreate_pipeline, delete_pipeline, create_dashboard, delete_dashboard# Environment variable
GREPTIMEDB_ALLOW_WRITE=true greptimedb-mcp-server
greptimedb-mcp-server --allow-write true
When enabled, the security gate is bypassed for execute_sql, and the server logs a warning on startup. With write mode off, those four tools return an error without contacting the server; list_pipelines, list_dashboards and dryrun_pipeline are read-only and stay available.
⚠️ Danger: This lets an AI assistant run destructive statements against your
database. Never enable it against production data. Combine with a read-only
database user if you only need read access.
Sensitive columns are automatically masked (******) based on column name patterns:
password, secret, token, api_key, credentialcredit_card, cvv, bank_accountssn, id_card, passportConfigure with --mask-patterns phone,email to add custom patterns.
All tool invocations are logged:
2025-12-10 10:30:45 - greptimedb_mcp_server.audit - INFO - [AUDIT] execute_sql | query="SELECT * FROM cpu LIMIT 10" | success=True | duration_ms=45.2
Disable with --audit-enabled false.
# Clone and setup
git clone https://github.com/GreptimeTeam/greptimedb-mcp-server.git cd greptimedb-mcp-server uv venv && source .venv/bin/activate uv sync
pytest
uv run black . uv run flake8 src
npx @modelcontextprotocol/inspector uv --directory . run -m greptimedb_mcp_server.server
MIT License - see LICENSE.md.
Inspired by: