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.
Aún no hay reseñas. ¡Sé el primero en reseñar!
Inicia sesión para unirte a la conversación
Highlight AIExecute SHOW/COUNT queries to read metadata from the database. Input: query_sql (string): The SHOW/COUNT SQL query to execute. Supported query types include SHOW DATABASES, SHOW TIMESERIES, COUNT TIMESERIES, etc. 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, format (string): Export format, either 'csv' or 'excel', 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 using TABLE dialect. Input: query_sql (string): The SELECT SQL query to execute. 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', filename (string): Optional filename for the exported file. Returns: Information about the exported file and a preview of the data (max 10 rows).