MCP.so
Sign In

IoTDB MCP Server

@apache

RepositoryHomepage

About IoTDB MCP Server

Apache IoTDB MCP Server

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

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.

Frequently asked questions

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

Basic information

Category

Other

License

Apache-2.0

Transports

stdio

Author

apache

More Other MCP servers

Sequential Thinking

modelcontextprotocol

Model Context Protocol Servers

88.2K

🪟 Windows-MCP

CursorTouch

MCP Server for Computer Use in Windows

6.3K

MCP Toolbox for Databases

googleapis

MCP Toolbox for Databases is an open source MCP server for databases.

15.9K

🚀 Model Context Protocol (MCP) Curriculum for Beginners

microsoft

This open-source curriculum introduces the fundamentals of Model Context Protocol (MCP) through real-world, cross-language examples in .NET, Java, TypeScript, JavaScript, Rust and Python. Designed for developers, it focuses on practical techniques for building modular, scalable,

16.7K

Activepieces

activepieces

AI Agents & MCPs & AI Workflow Automation • (~400 MCP servers for AI agents) • AI Automation / AI Agent with MCPs • AI Workflows & AI Agents • MCPs for AI Agents

23.2K