IoTDB MCP Server for Tree Model

by xiangmy21

1 130 downloads Not rated yet Apache-2.0
GitHub

About

An MCP (Model Context Protocol) server implementation that enables database interaction and business intelligence capabilities by running SQL queries against an Apache IoTDB instance.

Details

License
Apache-2.0

Explore

- Executes SHOW and COUNT queries via metadata_query tool
- Executes SELECT queries via select_query tool
- Returns query results as arrays of objects
- Integrates with Claude Desktop through MCP protocol
- No resources or prompts exposed

Setting up with Highlight

This MCP is not yet compatible with Highlight’s one-click setup. However, you can still use it with Highlight by following these steps:

  1. Download and install Highlight from highlightai.com/download
  2. Navigate to the plugins tab and select "Add Custom Plugin"
  3. Configure the plugin with the settings below
    Plugin Name IoTDB MCP Server for Tree Model
    Command (node, npx, python, etc.)

    Please refer to the README for specific instructions on how to obtain API keys or other required environment variables.

  4. Enable "Start Automatically" if you want the plugin to start when Highlight launches

From the repository

- Python with uv package manager
- IoTDB installation
- MCP server dependencies

uv venv
source venv/bin/activate # or venv\Scripts\activate on Windows

uv sync
```

Configure the MCP server in Claude Desktop's configuration file:

Claude Desktop / Cursor

Paste into your MCP client config file to install this server.

{
    "mcpServers": {
        "iotdb mcp server for tree model": {
            "iotdb": {
                "command": "uv",
                "args": [
                    "--directory",
                    "YOUR_REPO_PATH/src/iotdb_mcp_server",
                    "run",
                    "server.py"
                ],
                "env": {
                    "IOTDB_HOST": "127.0.0.1",
                    "IOTDB_PORT": "6667",
                    "IOTDB_USER": "root",
                    "IOTDB_PASSWORD": "root",
                    "IOTDB_DATABASE": "test"
                }
            }
        }
    }
}

McpServers

{
    "iotdb": {
        "command": "uv",
        "args": [
            "--directory",
            "YOUR_REPO_PATH/src/iotdb_mcp_server",
            "run",
            "server.py"
        ],
        "env": {
            "IOTDB_HOST": "127.0.0.1",
            "IOTDB_PORT": "6667",
            "IOTDB_USER": "root",
            "IOTDB_PASSWORD": "root",
            "IOTDB_DATABASE": "test"
        }
    }
}

smithery badge

Overview

A Model Context Protocol (MCP) server implementation that provides database interaction and business intelligence capabilities through IoTDB. This server enables running SQL queries.

Components

Resources

The server doesn't expose any resources.

Prompts

The server doesn't provide any prompts.

Tools

The server offers three core tools:
Query Tools
- metadata_query - Execute SHOW/COUNT queries to read metadata from the database - Input: - query_sql (string): The SHOW/COUNT SQL query to execute - Returns: Query results as array of objects - select_query - Execute SELECT queries to read data from the database - Input: - query_sql (string): The SELECT SQL query to execute - Returns: Query results as array of objects

Claude Desktop Integration

Prerequisites

- Python with uv package manager - IoTDB installation - MCP server dependencies

Development

```

No reviews yet — be the first

Sign in to leave a review

Use Google, GitHub, or an email account so ratings stay tied to real people.

Email sign in

No reviews posted yet.