An MCP server implementation providing database interaction and business intelligence capabilities through IoTDB, enabling SQL queries with Tree and Table Model dialects.
Execute SHOW/COUNT queries to read metadata from the database.
Execute SELECT queries to read data from the database.
Execute a query and export the results to a CSV or Excel file.
Execute SELECT queries to read data from the database.
Get a list of all tables in the database.
View schema information for a specific table.
Execute a query and export the results to a CSV or Excel file.
{
"mcpServers": {
"iotdb": {
"command": "uv",
"args": [
"--directory",
"/Users/your_username/iotdb-mcp-server/src/iotdb_mcp_server",
"run",
"server.py"
],
"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": "/path/to/export/folder"
}
}
}
}