Skip to main content
Glama
Sign In
deenesjakoruzh

IoTDB MCP Server

Official
by apache
GitHub
Python
Apache 2.0
17
  • Apple
OverviewInspectNewSchemaRelated ServersReviewsScore
Need Help?View Source CodeReport Issue

Integrations

  • Provides database interaction with Apache IoTDB, enabling execution of SQL queries to read data, list tables, and describe table schemas.

IoTDB MCP Server

Overview

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

Components

Resources

The server doesn't expose any resources.

Prompts

The server doesn't provide any prompts.

Tools

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".

Tree Model
  • 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
Table Model
Query Tools
  • 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
Schema Tools
  • 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

Claude Desktop Integration

Prerequisites

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

Development

# 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:

MacOS

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

Windows

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" } } } }

This server cannot be installed

-
security - not tested
A
license - permissive license
-
quality - not tested

hybrid server

The server is able to function both locally and remotely, depending on the configuration or use case.

A server that enables running SQL queries against IoTDB databases, providing data reading capabilities and schema information through a Model Context Protocol interface.

  1. Overview
    1. Components
      1. Resources
      2. Prompts
      3. Tools
    2. Claude Desktop Integration
      1. Prerequisites
        1. Development
          1. MacOS
          2. Windows

        Related MCP Servers

        • MySQL-MCP

          zajTools
          -
          security
          F
          license
          -
          quality
          A Model Context Protocol server that enables SQL query execution, database management, and business intelligence capabilities through MySQL connections.
          Last updated -
          JavaScript

        • Database MCP Server

          georgi-terziyski
          -
          security
          -
          license
          -
          quality
          A Model Context Protocol server that provides tools for connecting to and interacting with various database systems (SQLite, PostgreSQL, MySQL/MariaDB, SQL Server) through a unified interface.
          Last updated -
          Python

        • MSSQL MCP Server

          knight0zh
          -
          security
          A
          license
          -
          quality
          A Model Context Protocol server that enables executing SQL queries and managing connections with Microsoft SQL Server databases.
          Last updated -
          3
          TypeScript
          MIT License

        • IoTDB MCP Server

          JackieTien97
          -
          security
          F
          license
          -
          quality
          A Model Context Protocol server that enables AI assistants to securely interact with Apache IoTDB databases through a controlled interface for listing tables, reading data, and executing SQL queries.
          Last updated -
          Python
          • Apple

        View all related MCP servers

        New MCP Servers

        ID: xy5u3egaw0