sharepoint-excel-services-mcp-server-by-cdata

sharepoint-excel-services-mcp-server-by-cdata

3.2

If you are the rightful owner of sharepoint-excel-services-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 SharePoint Excel Services is a read-only server designed to allow LLMs to query live data from SharePoint Excel Services using natural language.

The CData MCP Server for SharePoint Excel Services is a specialized server that facilitates the interaction between large language models (LLMs) and SharePoint Excel Services. By leveraging the CData JDBC Driver, this server exposes SharePoint Excel Services as relational SQL models, enabling LLMs to access and query live data without the need for SQL knowledge. This server is particularly useful for applications like Claude Desktop, where users can ask natural language questions to retrieve data. The server is built to be read-only, providing a secure way to access data without the risk of unintended modifications. The setup involves cloning the repository, building the server, and configuring the connection to the data source. Once configured, the server can be integrated with AI clients to enhance data accessibility and usability.

Features

  • Read-only access to SharePoint Excel Services data.
  • Integration with CData JDBC Driver for seamless data exposure.
  • Natural language querying capability for LLMs.
  • Simple setup and configuration process.
  • Support for multiple data sources through CData's extensive driver library.

Tools

  1. sharepoint_excel_services_get_tables

    Retrieves a list of tables available in the data source.

  2. sharepoint_excel_services_get_columns

    Retrieves a list of columns for a specified table.

  3. sharepoint_excel_services_run_query

    Executes a SQL SELECT query on the data source.