About IoTDB MCP Server for Tree Model
IoTDB MCP Server for Tree Model lets users query IoTDB data through SQL-oriented MCP tools. It separates metadata queries from SELECT queries and returns results as arrays of objects.
Key features
- 01Run SHOW and COUNT metadata queries
- 02Run SELECT data queries
- 03Return query results as object arrays
Use cases
- 01Inspect IoTDB metadata with SHOW or COUNT statements
- 02Retrieve database records with SELECT statements
MCP support
Exposes metadata_query and select_query tools to MCP clients. It provides no resources or prompts.
Configuration
Local server config is the same for every client. Copy it into your client’s MCP config file.
We haven’t collected a package or remote endpoint for this server. Follow the instructions in the project README.
Tools
Local servers expose tools only once running on your machine, and the maintainer has not provided a tool list.
Details
From the project READMEIoTDB MCP Server for Tree Model
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
uvpackage manager - IoTDB installation
- MCP server dependencies
Development
# Clone the repository
git clone https://github.com/apache/iotdb-mcp-server.git
cd iotdb_mcp_server
# Create virtual environment
uv venv
source venv/bin/activate # or `venv\Scripts\activate` on Windows
# Install development dependencies
uv sync
Configure the MCP server in Claude Desktop's configuration file:
MacOS
Location: ~/Library/Application Support/Claude/claude_desktop_config.json
Windows
Location: %APPDATA%/Claude/claude_desktop_config.json
You may need to put the full path to the uv executable in the command field. You can get this 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"
}
}
}
}
Comments
New to MCP?
From what the protocol is to installing your first server, these answers cover most first questions.
An open protocol that defines how AI applications connect to external tools and data in a uniform way. Clients talk to the model; MCP servers provide tools, resources and prompt templates. They exchange standard messages, so one server can be reused by many clients.