Office 365 MCP Server by CData
@CDataSoftware
About Office 365 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 Office 365 (beta): https://www.cdata.com/download/download.aspx?sku=CXZK-V&type=beta
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\\office-365.prp"
]
}
}
}Tools
No tools detected
We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.
Overview
What is Office 365 MCP Server by CData?
This read-only MCP server enables LLMs like Claude Desktop to query live Office 365 data using natural language. It wraps the CData JDBC Driver for Office 365, exposing Office 365 as relational SQL models that AI clients can read without requiring SQL.
How to use Office 365 MCP Server by CData?
Clone the repository, build with mvn clean install, download and license the CData JDBC Driver for Office 365, configure a connection string using the driver’s utility, create a .prp file with driver path and JDBC URL, then add the server to your client’s config (e.g., claude_desktop_config.json). Run the server with java -jar CDataMCP-jar-with-dependencies.jar PATH/TO/office-365.prp. The server uses stdio transport, so it must run on the same machine as the client.
Key features of Office 365 MCP Server by CData
- Read-only access to Office 365 live data
- Powered by the CData JDBC Driver for Office 365
- Exposes tools:
{servername}_get_tables,{servername}_get_columns,{servername}_run_query - Query data via natural language – no SQL needed
- MIT licensed – free to use, modify, and distribute
Use cases of Office 365 MCP Server by CData
- Ask “What calendar events do I have today?” without writing SQL
- Analyze correlations between closed won opportunities and account industry
- Retrieve live ticket counts from a SUPPORT project
- Explore available tables and columns in Office 365 data
FAQ from Office 365 MCP Server by CData
What is the difference between this server and the CData MCP Server for Office 365 (beta)?
This server is read-only. The beta version supports full read, write, update, delete, and action capabilities with a simplified setup.
What are the system requirements?
You need Java, Maven, and the CData JDBC Driver for Office 365 (installed and licensed). The server runs on Windows, Mac, or Linux.
Does this server support write operations?
No. It is explicitly a read-only server.
What transport does it use?
The server uses stdio, so it can only be used with clients running on the same machine.
How can I get help if I have issues?
Contact the CData Support Team at their support page or join the CData Community for troubleshooting and feedback.
Frequently asked questions
What is the difference between this server and the CData MCP Server for Office 365 (beta)?
This server is read-only. The beta version supports full read, write, update, delete, and action capabilities with a simplified setup.
What are the system requirements?
You need Java, Maven, and the CData JDBC Driver for Office 365 (installed and licensed). The server runs on Windows, Mac, or Linux.
Does this server support write operations?
No. It is explicitly a read-only server.
What transport does it use?
The server uses `stdio`, so it can only be used with clients running on the same machine.
How can I get help if I have issues?
Contact the CData Support Team at their support page or join the CData Community for troubleshooting and feedback.
Basic information
More Other MCP servers
EverArt
modelcontextprotocolModel Context Protocol Servers
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.
Glasswarp
GlasswarpSee and control a real Windows PC you own — from any MCP client, locally or remotely. Observe (UIA + screenshots), click/type/drag/scroll, launch apps, owner Live View. BYOH: your machine, your key.
MCP Toolbox for Databases
googleapisMCP Toolbox for Databases is an open source MCP server for databases.
YOUB
Connect your AI assistant to your own YOUB endurance training account. Read recorded activities with full analysis, planned sessions, race goals, wellness (HRV, sleep, resting HR) and your athletic profile. Create or mov
Comments