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`.
IoTDB MCP Server
@apache
Basic information
About IoTDB MCP Server
Apache IoTDB MCP Server
IoTDB MCP Server config
Add this server to your MCP-compatible client using the configuration below.
{
"mcpServers": {
"iotdb-mcp-server": {
"command": "uv",
"args": [
"venv"
]
}
}
}IoTDB MCP Server tools
Tool list not available yet
This listing does not currently have a tool list to display. This does not mean the server has no tools; check its documentation for supported capabilities.
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
Frequently asked questions
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.
More Other MCP servers
Klarix Intelligence Engine
KlarixB2B competitive intelligence, live sales battlecards, 5-axis ICP prospect fit scoring, and tech stack teardowns over MCP and REST with cited public-web evidence.
Figs, Relationship Expert
Figs O'Sullivan, LMFTCouples therapist Figs O'Sullivan (LMFT, 17 years, endorsed by Sue Johnson, creator of EFT) inside your AI. Ask relationship questions answered from his clinical writing, name the pattern in a fight, get a three-step rep
P
PickFu MCP
PickFu MCP is a Model Context Protocol (MCP) server that connects AI assistants, developers, marketers, product managers, and AI agents to PickFu's consumer research platform. It enables users to create surveys, conduct
Handl
Handl speaks the Model Context Protocol. Your whole billing operation — projects, invoices, clients, reports, approvals — as tools any AI assistant can call, inside your autonomy rules.
Reactive Resume
amruthpillaiA 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
Comments