IoTDB MCP Server for Tree Model

What is IoTDB MCP Server for Tree Model?

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

How to use IoTDB MCP Server for Tree Model?

Install the server with Python and uv, then configure it in Claude Desktop’s configuration file (claude_desktop_config.json) by specifying the uv command, the path to the server’s server.py, and the required environment variables (IOTDB_HOST, IOTDB_PORT, IOTDB_USER, IOTDB_PASSWORD, IOTDB_DATABASE).

Key features of IoTDB MCP Server for Tree Model

• 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

Use cases of IoTDB MCP Server for Tree Model

• Querying IoTDB metadata (schemas, database info) using SHOW/COUNT SQL
• Retrieving time-series data from IoTDB using SELECT statements
• Building AI-assisted business intelligence workflows on top of IoTDB

FAQ from IoTDB MCP Server for Tree Model

What runtime or dependencies are required?

Python with the uv package manager, an IoTDB installation, and the MCP server dependencies (installed via uv sync).

How do I configure the server for my environment?

Set environment variables IOTDB_HOST, IOTDB_PORT, IOTDB_USER, IOTDB_PASSWORD, and IOTDB_DATABASE in the Claude Desktop configuration file.

What SQL queries are supported?

The server supports SHOW/COUNT queries (via metadata_query) and SELECT queries (via select_query). It does not support INSERT, UPDATE, DELETE, or other DDL/DML statements.

Where are the credentials and connection details stored?

They are provided as environment variables in the Claude Desktop configuration file, not in the server code itself.

What transport does the server use?

The server uses the standard MCP protocol (stdio transport, as configured for Claude Desktop). No explicit authentication is mentioned beyond the database credentials.