excel-online-mcp-server-by-cdata

excel-online-mcp-server-by-cdata

3.2

If you are the rightful owner of excel-online-mcp-server-by-cdata and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.

CData's Model Context Protocol (MCP) Server for Excel Online is a read-only server that allows LLMs to query live data from Excel Online using natural language.

The CData MCP Server for Excel Online is designed to facilitate the interaction between large language models (LLMs) and Excel Online data. By leveraging the CData JDBC Driver for Excel Online, this server exposes Excel Online data as relational SQL models, enabling LLMs to access and query live data without requiring SQL knowledge. This server is particularly useful for applications like Claude Desktop, where users can ask natural language questions to retrieve data insights. The server is read-only, but a beta version with full CRUD capabilities is available for those needing more comprehensive data manipulation features.

Features

  • Read-only access to Excel Online data through a simple MCP interface.
  • Integration with CData JDBC Driver for Excel Online to expose data as SQL models.
  • Natural language querying capability for LLMs, eliminating the need for SQL knowledge.
  • Support for various data sources through the CData JDBC Driver.
  • Simplified setup process with detailed configuration instructions.

Tools

  1. {servername}_get_tables

    Get a list of available tables in the data source

  2. {servername}_get_columns

    Get column information for the specified table

  3. {servername}_run_query

    Execute SQL SELECT query