Advertise
MCP.so
Sign In
S

SharePoint Excel Services MCP Server by CData

@CDataSoftware

Repository

Basic information

Category

Other

Transports

stdio

Author

CDataSoftware

Submitted by

Cameron Leblanc

About SharePoint Excel Services MCP Server by CData

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#mcp-server#cdata

SharePoint Excel Services MCP Server by CData config

Add this server to your MCP-compatible client using the configuration below.

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

SharePoint Excel Services MCP Server by CData tools

Tool list not available yet

This listing does not currently have a tool list to display. This does not mean the server has no tools; check its documentation for supported capabilities.

We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.

Overview

What is SharePoint Excel Services MCP Server by CData?

SharePoint Excel Services MCP Server by CData is a read-only MCP server that allows LLMs like Claude Desktop to query live SharePoint Excel Services data using natural language. It wraps the CData JDBC Driver for SharePoint Excel Services, exposing the data as relational SQL models.

How to use SharePoint Excel Services MCP Server by CData?

Clone the repository, build with mvn clean install, install and license the CData JDBC Driver for SharePoint Excel Services, configure a connection string using the driver’s utility, create a .prp file with JDBC details, then add the server to your Claude Desktop config file (claude_desktop_config.json) and restart Claude.

Key features of SharePoint Excel Services MCP Server by CData

  • Read-only querying of SharePoint Excel Services via MCP.
  • Natural language questions – no SQL required.
  • Built on the CData JDBC Driver for SharePoint Excel Services.
  • Exposes tables, columns, and SELECT queries as tools.
  • Supports OAuth and other JDBC connection options.
  • Works with Claude Desktop over stdio transport.

Use cases of SharePoint Excel Services MCP Server by CData

  • Ask an LLM for live totals, averages, or trends from Excel Services.
  • Retrieve specific rows or columns from SharePoint-hosted Excel workbooks.
  • Get data summaries without writing SQL or leaving the chat interface.

Frequently asked questions

1

Is this server read-only?

Yes. This MCP server supports only SELECT queries. For full read, write, update, delete, and action capabilities, CData offers a separate free beta MCP Server for SharePoint Excel Services.

2

What runtime dependencies are required?

You need Java to run the server and the CData JDBC Driver for SharePoint Excel Services (install and license separately).

3

Where does the data live?

Data stays in your SharePoint Excel Services instance. The server queries it live via the JDBC driver; no data is copied.

4

What transport does the server use?

The server uses `stdio` transport, so it can only be used with clients running on the same machine.

5

How is authentication handled?

Authentication is configured in the JDBC connection string (e.g., OAuth, username/password). You test and copy the string from the driver’s Connection String utility into your `.prp` file.

Comments

More Other MCP servers

P

PickFu MCP

PickFu MCP is a Model Context Protocol (MCP) server that connects AI assistants, developers, marketers, product managers, and AI agents to PickFu's consumer research platform. It enables users to create surveys, conduct

Activepieces

activepieces

AI Agents & MCPs & AI Workflow Automation • (~400 MCP servers for AI agents) • AI Automation / AI Agent with MCPs • AI Workflows & AI Agents • MCPs for AI Agents

23.2K

Senso MCP for Joomla

sensomedia

Senso MCP turns a Joomla 5 or 6 site into a remote MCP server. It runs inside Joomla itself (no extra server, no Node.js bridge) and is secured with OAuth 2.1 and Joomla's own ACL. The free pack lets an AI assistant crea

EverArt

modelcontextprotocol

Model Context Protocol Servers

88.1K

DeepMark

DeepMark helps teachers deliver rapid, consistent marking with meaningful feedback for every student — in a fraction of the time. What once took a week, now takes one free period.

Advertise