iotdb-mcp-server

A Model Context Protocol (MCP) server implementation that provides database interaction and business intelligence capabilities through IoTDB. This server enables running SQL queries.

The server doesn't expose any resources.

The server doesn't provide any prompts.

The server offers different tools for IoTDB Tree Model and Table Model. You can choose between them by setting the "IOTDB_SQL_DIALECT" configuration to either "tree" or "table".

• metadata_query
  • Execute SHOW/COUNT queries to read metadata from the database
  • Input:
    • query_sql (string): The SHOW/COUNT SQL query to execute
  • Returns: Query results as array of objects
• select_query
  • Execute SELECT queries to read data from the database
  • Input:
    • query_sql (string): The SELECT SQL query to execute
  • Returns: Query results as array of objects

• read_query
  • Execute SELECT queries to read data from the database
  • Input:
    • query (string): The SELECT SQL query to execute
  • Returns: Query results as array of objects

• list_tables

  • Get a list of all tables in the database
  • No input required
  • Returns: Array of table names

• describe-table

  • View schema information for a specific table
  • Input:
    • table_name (string): Name of table to describe
  • Returns: Array of column definitions with names and types

• Python with uv package manager
• IoTDB installation
• MCP server dependencies

# Clone the repository
git clone https://github.com/apache/iotdb-mcp-server.git
cd iotdb_mcp_server

# Create virtual environment
uv venv
source venv/bin/activate  # or `venv\Scripts\activate` on Windows

# Install development dependencies
uv sync

Configure the MCP server in Claude Desktop's configuration file:

Location: ~/Library/Application Support/Claude/claude_desktop_config.json

Location: %APPDATA%/Claude/claude_desktop_config.json

You may need to put the full path to the uv executable in the command field. You can get this by running which uv on MacOS/Linux or where uv on Windows.

{
  "mcpServers": {
    "iotdb": {
      "command": "uv",
      "args": [
        "--directory",
        "YOUR_REPO_PATH/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"
      }
    }
  }
}