Iotdb MCP Server
IoTDB database queries and schema exploration for your AI-powered data analysis.
Data last scanned today · Reviewed today
Overview
The Iotdb MCP Server provides a bridge between AI models and IoTDB, enabling direct execution of SQL queries against database instances. By configuring the IOTDB_SQL_DIALECT environment variable, users can toggle between the Tree Model and the Table Model to suit their specific database architecture. The server includes dedicated tools for metadata retrieval and data extraction. Users can run SHOW and COUNT queries to inspect database structure, perform SELECT operations with standard aggregate functions, and export query results directly into CSV or Excel formats for further analysis.
Our verdict
With a security score of 43/100, this server is currently classified as high risk. Because the authentication method and read-only mode have not yet been editorially reviewed, caution is advised when connecting this server to sensitive production databases. It is primarily suitable for development or internal exploration environments where database permissions are tightly scoped.
- Supports both Tree and Table SQL dialects for IoTDB
- Zero direct dependencies reduce the supply-chain attack surface
- Active development with commits occurring within the last 24 hours
- Community-maintained without official vendor oversight
- Authentication mechanisms have not yet been reviewed for safety
- Read-only mode implementation is not yet audited
Tools
| Tool | Description | Risk |
|---|---|---|
| metadata_query | Execute SHOW/COUNT queries to read metadata from the database | low |
| select_query | Execute SELECT queries to read data from the database | low |
| export_query | Execute a query and export the results to a CSV or Excel file | medium |
| read_query | Execute SELECT queries to read data from the database | low |
| list_tables | Get a list of all tables in the database | low |
| describe_table | View schema information for a specific table | low |
| export_table_query | Execute a query and export the results to a CSV or Excel file | medium |
Compatibility
| Client | Local | Docker | Remote | Read-only |
|---|---|---|---|---|
| Claude Desktop | ||||
| Cursor | ||||
| VS Code | ||||
| Windsurf | ||||
| ChatGPT |
Frequently asked questions
›How do I switch between Tree and Table SQL dialects?
You can change the dialect by setting the IOTDB_SQL_DIALECT environment variable or the --sql-dialect configuration option to either 'tree' or 'table'.
›What formats are supported for exporting query results?
The server supports exporting query results to either CSV or Excel formats.
›Are there specific date/time format requirements for queries?
Yes, when executing SELECT queries in either dialect, time values must be provided using the ISO 8601 format, such as 2017-11-01T00:08:00.000.
›Where are exported files stored by default?
Exported files are stored in the directory specified by the IOTDB_EXPORT_PATH variable, which defaults to /tmp.
›What are the prerequisites to run this MCP server?
You need a Python environment, the uv package manager, an existing IoTDB installation, and the required MCP server dependencies.
›How many concurrent sessions does the server support?
The server utilizes an optimized session pool management system that supports up to 100 concurrent sessions.
Alternatives
Badge
Maintain this server? Add the live badge to your README.