IoTDB MCP Server

Name: IoTDB MCP Server
Author: apache

@apache

Repository Homepage

About IoTDB MCP Server

Apache IoTDB MCP Server

#python #iot #database #big-data #timeseries #tsdb #mcp-server

Basic information

Config

Add this server to your MCP-compatible client using the configuration below.

{
  "mcpServers": {
    "iotdb-mcp-server": {
      "command": "uv",
      "args": [
        "venv"
      ]
    }
  }
}

Tools

No tools detected

We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.

Overview

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.

Comments

More Other MCP servers

Reactive Resume

amruthpillai

A one-of-a-kind resume builder that keeps your privacy in mind. Completely secure, customizable, portable, open-source and free forever. Try it out today!

39.5K