IoTDB MCP Server

What is IoTDB MCP Server?

IoTDB MCP Server is a Model Context Protocol (MCP) server that provides database interaction and business intelligence capabilities through Apache IoTDB. It enables AI assistants to run SQL queries and interact with IoTDB using either the Tree Model or Table Model dialect.

How to use IoTDB MCP Server?

Install with uv and configure via environment variables or command-line arguments for host, port, user, password, database, SQL dialect, and export path. Integrate with Claude Desktop by adding the server configuration in claude_desktop_config.json with the proper command, arguments, and environment variables.

Key features of IoTDB MCP Server

• Supports both Tree Model and Table Model SQL dialects
• Tools for metadata queries and data selection per model
• Export query results to CSV or Excel files
• Session pool with up to 100 concurrent connections
• Automatic connection retry and timeout management
• Docker support for containerized deployment

Use cases of IoTDB MCP Server

• Query time‑series metadata and data from IoTDB using natural language
• Export IoTDB query results to CSV/Excel for further analysis
• Explore database schema (tables, devices, timeseries) via AI assistants
• Integrate IoTDB business intelligence into chat‑based workflows

FAQ from IoTDB MCP Server

What SQL dialects are supported?

Two dialects: tree (for timeseries metadata and data) and table (for relational tables). Set the IOTDB_SQL_DIALECT environment variable to tree or table.

How do I configure the connection to IoTDB?

Use environment variables (IOTDB_HOST, IOTDB_PORT, IOTDB_USER, IOTDB_PASSWORD, IOTDB_DATABASE) or command‑line arguments (--host, --port, etc.). Defaults: host 127.0.0.1, port 6667, user/password root, database test.

Can I export query results to a file?

Yes. The Tree Model tool export_query and the Table Model tool export_table_query export to CSV (default) or Excel. A preview of up to 10 rows is returned.

What are the prerequisites for running the server?

A Python environment, the uv package manager, an IoTDB instance, and the MCP server dependencies installed via uv sync.

Does the server support Docker?

Yes. Build the image with docker build -t iotdb-mcp-server . and run with environment variables for the IoTDB connection.