Iotdb MCP Server TreeModel

🚀 Tree Structure Model of IoTDB MCP Server

A Model Context Protocol (MCP) server implementation that provides database interaction and business intelligence capabilities, enabling SQL queries via IoTDB.

🚀 Quick Start

This is a Model Context Protocol (MCP) server implementation that offers database interaction and business intelligence features. It enables SQL queries through IoTDB.

✨ Features

Components

Resources

This server does not expose any resources.

Tips

This server does not provide any tips.

Tools

This 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 be executed.
  • Return: The query results as an array of objects.
• select_query
  • Execute SELECT queries to read data from the database.
  • Input:
    • query_sql (string): The SELECT SQL query to be executed.
  • Return: The query results as an array of objects.

Integration with Claude Desktop

Prerequisites

• Python with the uv package manager.
• IoTDB installation.
• MCP server dependencies.

📦 Installation

# Clone the repository
git clone https://github.com/apache/iotdb-mcp-server.git
cd iotdb_mcp_server

# Create a virtual environment
uv venv
source venv/bin/activate  # or `venv\Scripts\activate` on Windows

# Install development dependencies
uv sync

Configuration

Configure the MCP server in the Claude Desktop configuration file:

MacOS

Location: ~/Library/Application Support/Claude/claude_desktop_config.json

Windows

Location: %APPDATA%/Claude/claude_desktop_config.json

⚠️ Important Note

You may need to place the full path of the uv executable in the command field. You can obtain this path by running which uv on MacOS/Linux or where uv on Windows.

{
  "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"
      }
    }
  }
}