This read-only MCP Server allows you to connect to Office 365 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": {
"office-365-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 Office 365
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
Official Notion MCP Server
MCP Security Weekly
Get CVE alerts and security updates for Office 365 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 Office 365
: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 Office 365.
We created this read-only MCP Server to allow LLMs (like Claude Desktop) to query live data Office 365 supported by the CData JDBC Driver for Office 365.
CData JDBC Driver connects to Office 365 by exposing them as relational SQL models.
This server wraps that driver and makes Office 365 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/office-365-mcp-server-by-cdata.git
cd office-365-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 Office 365\/Applications/CData JDBC Driver for Office 365/java -jar cdata.jdbc.office365.jar --licenseRun the command java -jar cdata.jdbc.office365.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. office-365.prp) using the following properties and format:
Prefix=office365
ServerName=CDataOffice365
ServerVersion=1.0
DriverPath=PATH\TO\cdata.jdbc.office365.jar
DriverClass=cdata.jdbc.office365.Office365Driver
JdbcUrl=jdbc:office365: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",
"PATH\\TO\\office-365.prp"
]