The IoTDB MCP Server provides a secure interface for AI assistants to interact with Apache IoTDB time-series databases. Developed by the Apache Software Foundation, this Python-based implementation enables three core database operations: executing SELECT queries, listing available tables, and describing table schemas. The server connects to IoTDB instances using a session pool for efficient connection management and returns query results in a structured text format. It's particularly valuable for data analysts and IoT applications that need AI-assisted exploration and analysis of time-series data stored in IoTDB without requiring direct database access.
暂无评论. 成为第一个评论的人！
登录以参与讨论
Highlight AIExecute 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.
Execute SELECT queries to read data from the database. Input: query_sql (string): The SELECT SQL query to execute (using TREE dialect). Returns: Query results as array of objects.
Execute a query and export the results to a CSV or Excel file. Input: query_sql (string): The SQL query to execute (using TREE dialect), format (string): Export format, either 'csv' or 'excel' (default: 'csv'), filename (string): Optional filename for the exported file. Returns: Information about the exported file and a preview of the data (max 10 rows).
Execute SELECT queries to read data from the database. Input: query_sql (string): The SELECT SQL query to execute (using TABLE dialect). Returns: Query results as array of objects.
Get a list of all tables in the database. No input required. Returns: Array of table names.
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.
Execute a query and export the results to a CSV or Excel file. Input: query_sql (string): The SQL query to execute (using TABLE dialect), format (string): Export format, either 'csv' or 'excel' (default: 'csv'), filename (string): Optional filename for the exported file. Returns: Information about the exported file and a preview of the data (max 10 rows).
