home / mcp / excel services mcp server

Excel Services MCP Server

This read-only MCP Server allows you to connect to SharePoint Excel Services data from Claude Desktop through CData JDBC Drivers. For full CRUD support, check out our MCP Server for SharePoint Excel Services (https://www.cdata.com/drivers/excelservices/download/mcp).

Installation

Add the following to your MCP client configuration file.

Configuration

View docs

{
  "mcpServers": {
    "cdatasoftware-sharepoint-excel-services-mcp-server-by-cdata": {
      "command": "java",
      "args": [
        "-jar",
        "/PATH/TO/CDataMCP-jar-with-dependencies.jar",
        "/PATH/TO/sharepoint-excel-services.prp"
      ]
    }
  }
}

You can query live SharePoint Excel Services data through a read-only MCP server that wraps the CData JDBC Driver. This server exposes your SharePoint Excel data as relational models and lets you ask natural-language questions to retrieve up-to-date information without writing SQL.

How to use

After you have the MCP server running, you interact with it via an MCP client. You will use the server to read data from SharePoint Excel Services and ask questions like “What is the total revenue by region this quarter?” or “Show me open calendar events for today.” The server provides three built-in endpoints you can leverage implicitly through your client: listing available tables, listing columns for a table, and executing a read query. You don’t need to call these endpoints directly unless you are scripting your own integration.

How to install

Prerequisites: Java runtime installed on your machine. You will also need the CData JDBC Driver for SharePoint Excel Services and a valid license.

1. Build the MCP server jar from source.

mvn clean install

2. Obtain and license the CData JDBC Driver for SharePoint Excel Services.

3. Configure your JDBC connection to SharePoint Excel Services using the Driver’s Connection String utility and save the resulting connection string.

4. Create a .prp file (for example sharepoint-excel-services.prp) with the JDBC connection details. Include your Prefix, ServerName, ServerVersion, DriverPath, DriverClass, and JdbcUrl. Leave Tables blank to access all data or list explicit tables if desired.

env
Prefix=excelservices
ServerName=CDataExcelServices
ServerVersion=1.0
DriverPath=PATH\TO\cdata.jdbc.excelservices.jar
DriverClass=cdata.jdbc.excelservices.ExcelServicesDriver
JdbcUrl=jdbc:excelservices:InitiateOAuth=GETANDREFRESH;
Tables=

Running the server

Start the MCP server by running the MCP jar with the prepared .prp file. The server uses stdio and runs on the local machine so clients on the same host can communicate with it.

java -jar /PATH/TO/CDataMCP-jar-with-dependencies.jar /PATH/TO/sharepoint-excel-services.prp

Available tools

excel_services_get_tables

Retrieves a list of available tables in the data source. Output is provided in CSV, with the first line containing column headers.

excel_services_get_columns

Retrieves a list of columns for a specified table. Output is provided in CSV, with the first line containing column headers.

excel_services_run_query

Executes a SQL SELECT query against the exposed data.