What is an MCP Server?

An MCP (Model Context Protocol) Server acts as a bridge, allowing AI models to access and interact with external data sources and tools. It standardizes how applications provide context to LLMs.

What is the CData MCP Server for SharePoint Excel Services?

It’s a server that allows LLMs like Claude Desktop to query live data from SharePoint Excel Services by leveraging CData JDBC Drivers, exposing data as relational SQL models.

Is the MCP Server read-only?

This specific project builds a read-only MCP server. However, CData offers a free (beta) version with read/write capabilities available at https://www.cdata.com/solutions/mcp

How do I set up the CData MCP Server?

The setup involves cloning the repository, building the server with Maven, downloading and licensing the CData JDBC Driver, configuring the connection, creating a .prp file with connection details, and configuring Claude Desktop.

What is a .prp file?

It’s a configuration file that contains the connection details for the JDBC driver, including the JDBC URL, driver class, and table names.

How do I run the MCP Server?

You can run the server from the command line using the java -jar command, ensuring it runs on the same machine as the AI client.

What kind of queries can I run?

You can use natural language to ask questions, and the AI client will translate them into SQL queries to retrieve the data. You can also execute custom SQL queries using the appropriate tool.

What if I can’t see my CData MCP Server in Claude Desktop?

Ensure that you have fully quit Claude Desktop (using Task Manager on Windows or Activity Monitor on Mac) and re-opened it.

What if Claude Desktop is unable to retrieve data?

Verify that you have configured your connection properly, using the Connection String builder to create the connection string and copying it into the property (.prp) file.

Where can I get help if I have trouble connecting to my data source?

Contact the CData Support Team at https://www.cdata.com/support/submit.aspx.

Where can I get help if I’m having trouble using the MCP server?

Join the CData Community for assistance.

Under what license is the MCP server licensed?

The MCP server is licensed under the MIT License.

Can I connect this MCP Server to the UBOS platform?

Yes, seamless integration with the UBOS platform will enable you to orchestrate complex AI agent workflows and build custom AI solutions.