IoTDB Time Series

v1.0.0Databasesstable

A server that enables running SQL queries against IoTDB databases, providing data reading capabilities and schema information through a Model Context Protocol interface.

big-datadatabaseiotmcp-serverpython
Share:
38
Stars
0
Downloads
0
Weekly
0/5

What is IoTDB Time Series?

IoTDB Time Series is a Model Context Protocol (MCP) server that allows AI assistants like Claude, Cursor, and VS Code to server that enables running sql queries against iotdb databases, providing data reading capabilities and schema information through a model context protocol interface.

A server that enables running SQL queries against IoTDB databases, providing data reading capabilities and schema information through a Model Context Protocol interface.

This server falls under the Databases category on MCPgee, the world's largest MCP server directory with 33,000+ servers.

Features

  • A server that enables running SQL queries against IoTDB data

Use Cases

Time series data queries
IoT sensor data management
Time series analysis
apache

Maintainer

LicenseApache 2.0
Languagepython
Versionv1.0.0
UpdatedApr 24, 2026
Statushealthy
Maintenanceactive

Works with

ClaudeOpenAIwindowsmacoslinux

Installation

Manual Installation

npx iotdb-mcp-server

Configuration

Configuration Details

Config File

claude_desktop_config.json

Performance

Response Metrics

Response Time< 200ms
ThroughputMedium

Resource Usage

Memory UsageLow
CPU UsageLow

How to Set Up and Use IoTDB Time Series

The IoTDB MCP Server provides a Model Context Protocol interface for Apache IoTDB, an open-source time series database designed for IoT sensor data at scale, enabling AI assistants to execute SQL queries, inspect schemas, and export results from IoTDB databases. It supports both the IoTDB tree model (device/sensor hierarchy) and the newer table model (SQL-standard), exposing read and export tools for each. Data engineers, IoT platform developers, and analysts who want to interrogate time series data from a sensor network or industrial system using natural language will find this server a direct bridge from their AI client to IoTDB.

Prerequisites

  • Python 3.8+ and `uv` package manager installed (`pip install uv`)
  • A running Apache IoTDB instance (default: localhost:6667)
  • IoTDB credentials (default user: root, default password: root)
  • Claude Desktop or another MCP-compatible AI client
1

Clone the repository and set up the Python environment

Clone the official Apache IoTDB MCP server repository, create a virtual environment using uv, and install all required dependencies.

git clone https://github.com/apache/iotdb-mcp-server.git
cd iotdb-mcp-server
uv venv
source .venv/bin/activate
uv sync
2

Ensure your IoTDB instance is running

Start your Apache IoTDB server if it is not already running. The MCP server will connect to it using the host, port, and credentials you configure. By default it expects IoTDB on 127.0.0.1:6667.

# Start IoTDB (from your IoTDB installation directory)
./sbin/start-standalone.sh
3

Configure environment variables

Set the environment variables that control the IoTDB connection. All variables have defaults but you should override them to match your setup, especially IOTDB_HOST, IOTDB_USER, and IOTDB_PASSWORD.

export IOTDB_HOST=127.0.0.1
export IOTDB_PORT=6667
export IOTDB_USER=root
export IOTDB_PASSWORD=root
export IOTDB_DATABASE=test
export IOTDB_SQL_DIALECT=table  # 'table' or 'tree'
export IOTDB_EXPORT_PATH=/tmp
4

Add the server to Claude Desktop configuration

Edit claude_desktop_config.json to register the IoTDB MCP server. You must provide the absolute path to the uv executable and the cloned repository location.

{
  "mcpServers": {
    "iotdb": {
      "command": "/usr/local/bin/uv",
      "args": ["run", "--directory", "/path/to/iotdb-mcp-server", "mcp"],
      "env": {
        "IOTDB_HOST": "127.0.0.1",
        "IOTDB_PORT": "6667",
        "IOTDB_USER": "root",
        "IOTDB_PASSWORD": "root",
        "IOTDB_DATABASE": "test",
        "IOTDB_SQL_DIALECT": "table",
        "IOTDB_EXPORT_PATH": "/tmp"
      }
    }
  }
}
5

Query your IoTDB data with natural language

With the server running, use your AI client to explore schemas and run time series queries. In table model mode the tools are `read_query`, `list_tables`, `describe_table`, and `export_table_query`. In tree model mode the tools are `select_query`, `metadata_query`, and `export_query`.

IoTDB Time Series Examples

Client configuration

Claude Desktop configuration for the IoTDB MCP server using the uv runner with environment variables for a local IoTDB instance.

{
  "mcpServers": {
    "iotdb": {
      "command": "/usr/local/bin/uv",
      "args": ["run", "--directory", "/path/to/iotdb-mcp-server", "mcp"],
      "env": {
        "IOTDB_HOST": "127.0.0.1",
        "IOTDB_PORT": "6667",
        "IOTDB_USER": "root",
        "IOTDB_PASSWORD": "root",
        "IOTDB_DATABASE": "sensors",
        "IOTDB_SQL_DIALECT": "table",
        "IOTDB_EXPORT_PATH": "/tmp"
      }
    }
  }
}

Prompts to try

These prompts leverage the IoTDB MCP tools for time series data exploration:

- "List all tables in the IoTDB database"
- "Describe the schema of the temperature_readings table"
- "Query the average temperature per hour from sensor_001 for the last 7 days"
- "Export the last 1000 rows from pressure_sensors to a CSV file"
- "Find all time series in the root.factory.line1 device tree"
- "Show me the max and min values in the vibration_data table from last week"

Troubleshooting IoTDB Time Series

Connection refused when starting the server

Verify your IoTDB instance is running and listening on the configured IOTDB_HOST and IOTDB_PORT. Run `telnet 127.0.0.1 6667` to test basic connectivity. If IoTDB is running in Docker, ensure the port is published and the host is accessible from the MCP server process.

SQL dialect errors — queries fail with syntax errors

Set IOTDB_SQL_DIALECT to match your IoTDB version's default. Older IoTDB versions use 'tree' dialect (SELECT from root.* paths); IoTDB 1.3+ supports 'table' dialect with standard SQL. Check your IoTDB version with `show version` in the IoTDB CLI.

uv command not found in Claude Desktop

Claude Desktop runs with a limited PATH. Use the absolute path to the uv binary in the `command` field (e.g., /usr/local/bin/uv or ~/.cargo/bin/uv). Find it with `which uv` in your terminal.

Frequently Asked Questions about IoTDB Time Series

What is IoTDB Time Series?

IoTDB Time Series is a Model Context Protocol (MCP) server that server that enables running sql queries against iotdb databases, providing data reading capabilities and schema information through a model context protocol interface. It connects AI assistants to external tools and data sources through a standardized interface.

How do I install IoTDB Time Series?

Follow the installation instructions on the IoTDB Time Series GitHub repository. Clone the repo, install dependencies, and add the server config to your AI client.

Which AI clients work with IoTDB Time Series?

IoTDB Time Series works with all major MCP-compatible AI clients including Claude Desktop, Claude Code, Cursor, VS Code (GitHub Copilot), Windsurf, and Cline.

Is IoTDB Time Series free to use?

Yes, IoTDB Time Series is open source and available under the Apache 2.0 license. You can use it freely in both personal and commercial projects.

Browse More Databases MCP Servers

Explore all databases servers available in the MCPgee directory. Each server includes setup guides for Claude, Cursor, and VS Code.

Quick Config Preview

{ "mcpServers": { "iotdb-mcp-server": { "command": "npx", "args": ["-y", "iotdb-mcp-server"] } } }

Add this to your claude_desktop_config.json or .cursor/mcp.json

Read the full setup guide →

Ready to use IoTDB Time Series?

Browse our complete directory of 33,000+ MCP servers, read setup guides for your editor, and start building with the Model Context Protocol.

33,000+ ServersFree & Open SourceStep-by-Step Guides