This read-only MCP Server allows you to connect to Excel Online data from Claude Desktop through CData JDBC Drivers. For full CRUD support, check out the first managed MCP platform: CData Connect AI (https://www.cdata.com/ai/).
Config is the same across clients — only the file and path differ.
{
"mcpServers": {
"excel-online-mcp-server-by-cdata": {
"command": "<see-readme>",
"args": []
}
}
}Are you the author?
Add this badge to your README to show your security score and help users find safe servers.
CData's Model Context Protocol (MCP) Server for Excel Online
No automated test available for this server. Check the GitHub README for setup instructions.
Five weighted categories — click any category to see the underlying evidence.
No known CVEs.
No package registry to scan.
Click any tool to inspect its schema.
Be the first to review
Have you used this server?
Share your experience — it helps other developers decide.
Sign in to write a review.
Others in productivity
Dynamic problem-solving through sequential thought chains
Persistent memory using a knowledge graph
mini cli search engine for your docs, knowledge bases, meeting notes, whatever. Tracking current sota approaches while being all local
Local-first AI memory with knowledge graphs and hybrid search. 17+ AI tools via MCP. Free.
MCP Security Weekly
Get CVE alerts and security updates for Excel Online Mcp Server By Cdata and similar servers.
Start a conversation
Ask a question, share a tip, or report an issue.
Sign in to join the discussion.
CData's Model Context Protocol (MCP) Server for Excel Online
:heavy_exclamation_mark: This project builds a local, read-only MCP server. For fully remote MCP access, check out the first managed MCP platform: CData Connect AI. For locally hosted, full read, write, update, delete, and action capabilities and a simplified setup, check out our CData MCP Server for Excel Online.
We created this read-only MCP Server to allow LLMs (like Claude Desktop) to query live data Excel Online supported by the CData JDBC Driver for Excel Online.
CData JDBC Driver connects to Excel Online by exposing them as relational SQL models.
This server wraps that driver and makes Excel Online data available through a simple MCP interface, so LLMs can retrieve live information by asking natural language questions — no SQL required.
git clone https://github.com/cdatasoftware/excel-online-mcp-server-by-cdata.git
cd excel-online-mcp-server-by-cdata
mvn clean install
This creates the JAR file: CDataMCP-jar-with-dependencies.jarlib folder in the installation directory, typically:
C:\Program Files\CData\CData JDBC Driver for Excel Online\/Applications/CData JDBC Driver for Excel Online/java -jar cdata.jdbc.excelonline.jar --licenseRun the command java -jar cdata.jdbc.excelonline.jar to open the Connection String utility.
Configure the connection string and click "Test Connection"
Note: If the data sources uses OAuth, you will need to authenticate in your browser.
Once successful, copy the connection string for use later.
.prp file for your JDBC connection (e.g. excel-online.prp) using the following properties and format:
Prefix=excelonline
ServerName=CDataExcelOnline
ServerVersion=1.0
DriverPath=PATH\TO\cdata.jdbc.excelonline.jar
DriverClass=cdata.jdbc.excelonline.ExcelOnlineDriver
JdbcUrl=jdbc:excelonline:InitiateOAuth=GETANDREFRESH;
Tables=
Create the config file for Claude Desktop ( claude_desktop_config.json) to add the new MCP server, using the format below. If the file already exists, add the entry to the mcpServers in the config file.
Windows
{
"mcpServers": {
"{classname_dash}": {
"command": "PATH\\TO\\java.exe",
"args": [
"-jar",
"PATH\\TO\\CDataMCP-jar-with-dependencies.jar",