Korean | 한국어

개요

IoTDB를 통해 데이터베이스 상호 작용 및 비즈니스 인텔리전스 기능을 제공하는 모델 콘텍스 프로토콜 (MCP) 서버 구현. 이 서버는 SQL queries를 실행하고 다른 SQL 방언 (Tree Model and Table Model)을 사용하여 IoTDB와 상호 작용할 수 있습니다.

부품

자원

서버는 어떤 리소스를 노출하지 않습니다.

# # # Prompts를

서버는 어떤 프롬프트를 제공하지 않습니다.

권한 모델

IoTDB MCP 권한은 기본적으로 자문입니다. 서버가 요청한 보고서 SQL 작업에 대한 권한, 위험 수준 및 확인 매개 변수, 동안 Host Agent 시스템은 사용자 승인을 소유합니다. 사용 inspect_sql_permission 전 도구가 사용할 때 DDL/DML 또는 destructive SQL을 실행합니다.

Long-running 호스팅 에이전트는 전체 권한 기본을 제공 할 수 있습니다. IOTDB_SQL_DRIVER_MODE=full와 같은 환경 변수 및 TIMESEEK_MCP_PERMISSION_ENFORCEMENT=advisory. 설치하기 TIMESEEK_MCP_PERMISSION_ENFORCEMENT=strict MCP 서버 자체만 차단을 해제한다.

세션 정책 변경은 배포 정책에 의해 공개 시작 (공정 환경 > MCP 구성 > 기본).

IoTDB MCP Server

English | 中文

Overview

A Model Context Protocol (MCP) server implementation that provides database interaction and business intelligence capabilities through IoTDB. This server enables running SQL queries and interacting with IoTDB using different SQL dialects (Tree Model and Table Model).

Components

Resources

The server doesn’t expose any resources.

Prompts

The server doesn’t provide any prompts.

Permission Model

IoTDB MCP permissions are advisory by default. The server reports the required permission, risk level, and confirmation parameter for SQL actions, while the host agent system owns user approval. Use inspect_sql_permission before executing DDL/DML or destructive SQL when the tool is available.

Long-running hosted agents can provide full-permission defaults with environment variables such as IOTDB_SQL_DRIVER_MODE=full and TIMESEEK_MCP_PERMISSION_ENFORCEMENT=advisory. Set TIMESEEK_MCP_PERMISSION_ENFORCEMENT=strict only when the MCP server itself should hard-block disallowed operations.

Session policy changes are bounded by a deployment policy frozen at startup (process environment > MCP configuration > defaults). Narrowing applies immediately; widening within that ceiling requires out-of-band administrator approval by default. IOTDB_SESSION_POLICY_APPROVAL_MODE=allow explicitly permits in-ceiling widening without approval. Neither setting allows tools to change enforcement switches, SQL classification prefixes, or the deployment ceiling. Reset and replace follow the same rules. See session policy administration for configuration, approval commands, and the required host isolation.

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

Dialect-specific identifier semantics:

• Tree dialect:
  • FROM targets use explicit root... paths.
  • Projection expressions should usually use measurement names instead of full root... paths.
  • IOTDB_DATABASE is only a connection/session hint; tree SQL still needs explicit root paths.
• Table dialect:
  • FROM targets use table names in the current database.
  • Projection expressions use column names.

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
  • Supported query types:
    • SHOW DATABASES [path]
    • SHOW TIMESERIES [path]
    • SHOW CHILD PATHS [path]
    • SHOW CHILD NODES [path]
    • SHOW DEVICES [path]
    • COUNT TIMESERIES [path]
    • COUNT NODES [path]
    • COUNT DEVICES [path]
  • Returns: Query results as array of objects
• select_query
  • Execute SELECT queries to read data from the database
  • Input: