IoTDB Time Series
A server that enables running SQL queries against IoTDB databases, providing data reading capabilities and schema information through a Model Context Protocol interface.
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
Maintainer
Works with
Installation
Manual Installation
npx iotdb-mcp-serverConfiguration
Configuration Details
claude_desktop_config.json
Performance
Response Metrics
Resource Usage
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
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 syncEnsure 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.shConfigure 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=/tmpAdd 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"
}
}
}
}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.
IoTDB Time Series Alternatives — Similar Databases Servers
Looking for alternatives to IoTDB Time Series? Here are other popular databases servers you can use with Claude, Cursor, and VS Code.
Excelize
★ 20.6kGo language library for reading and writing Microsoft Excel™ (XLAM / XLSM / XLSX / XLTM / XLTX) spreadsheets
MCP Toolbox for Databases
★ 15.3kOpen source MCP server specializing in easy, fast, and secure tools for Databases.
DBHub
★ 2.8kA universal database gateway MCP server that enables AI assistants to connect to and query multiple databases (PostgreSQL, MySQL, MariaDB, SQL Server, SQLite) with support for schema exploration, SQL execution, and secure connections via SSH tunnels.
Tabularis
★ 2.1kA lightweight, cross-platform database client for developers. Supports MySQL, PostgreSQL and SQLite. Hackable with plugins. Built for speed, security, and aesthetics.
Postgres AI Guide
★ 1.7kMCP server and Claude plugin for Postgres skills and documentation. Helps AI coding tools generate better PostgreSQL code.
Anyquery
★ 1.7k🏎️ 🏠 ☁️ - Query more than 40 apps with one binary using SQL. It can also connect to your PostgreSQL, MySQL, or SQLite compatible database. Local-first and private by design.
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.
Set Up IoTDB Time Series in Your Editor
Choose your AI client for step-by-step setup instructions.
Quick Config Preview
Add this to your claude_desktop_config.json or .cursor/mcp.json
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.