SharePoint Excel Services MCP Server by CData

Created By

CDataSoftware6 months ago

This project builds a read-only MCP server. For full read, write, update, delete, and action capabilities and a simplified setup, check out our free CData MCP Server for SharePoint Excel Services (beta): https://www.cdata.com/download/download.aspx?sku=DTZK-V&type=beta

# sharepoint

# excel

Overview Content Tools Comments

Overview

What is SharePoint Excel Services MCP Server?

The SharePoint Excel Services MCP Server by CData is a read-only server that allows large language models (LLMs) to query live data from SharePoint Excel Services using natural language, without the need for SQL.

How to use the SharePoint Excel Services MCP Server?

To use the server, clone the repository, build the server, install the CData JDBC Driver, configure your connection, and create a configuration file for your AI client (e.g., Claude Desktop).

Key features of the SharePoint Excel Services MCP Server?

Provides a read-only interface to SharePoint Excel Services data.
Allows querying of live data using natural language.
Simplifies data access for LLMs without requiring SQL.

Use cases of the SharePoint Excel Services MCP Server?

Querying live data from SharePoint Excel Services for reporting.
Integrating with AI clients to provide data insights.
Enabling natural language queries for business intelligence applications.

FAQ from SharePoint Excel Services MCP Server?

Can I write data using this server?

No, this server is read-only. For write capabilities, consider the full CData MCP Server.

Is there a trial version available?

Yes, a trial version of the CData MCP Server for SharePoint Excel Services is available for download.

What kind of data sources can I connect to?

The server supports various data sources, including Salesforce, Excel, and many more.

Server Config

{
  "mcpServers": {
    "{classname_dash}": {
      "command": "PATH\\TO\\java.exe",
      "args": [
        "-jar",
        "PATH\\TO\\CDataMCP-jar-with-dependencies.jar",
        "PATH\\TO\\sharepoint-excel-services.prp"
      ]
    }
  }
}

Recommend Servers

TraeBuild with Free GPT-4.1 & Claude 3.7. Fully MCP-Ready.

Context7Context7 MCP Server -- Up-to-date code documentation for LLMs and AI code editors

ChatWiseThe second fastest AI chatbot™

MiniMax MCPOfficial MiniMax Model Context Protocol (MCP) server that enables interaction with powerful Text to Speech, image generation and video generation APIs.

DeepChatYour AI Partner on Desktop

Jina AI MCP ToolsA Model Context Protocol (MCP) server that integrates with Jina AI Search Foundation APIs.

Visual Studio Code - Open Source ("Code - OSS")Visual Studio Code

Playwright McpPlaywright MCP server

Tavily Mcp

Zhipu Web SearchZhipu Web Search MCP Server is a search engine specifically designed for large models. It integrates four search engines, allowing users to flexibly compare and switch between them. Building upon the web crawling and ranking capabilities of traditional search engines, it enhances intent recognition capabilities, returning results more suitable for large model processing (such as webpage titles, URLs, summaries, site names, site icons, etc.). This helps AI applications achieve "dynamic knowledge acquisition" and "precise scenario adaptation" capabilities.

MCP AdvisorMCP Advisor & Installation - Use the right MCP server for your needs