playbooks

home / mcp / office365 mcp server

Office365 MCP Server

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/).

Installation
Add the following to your MCP client configuration file.

Configuration

View docs
{
  "mcpServers": {
    "cdatasoftware-office-365-mcp-server-by-cdata": {
      "command": "java",
      "args": [
        "-jar",
        "CDataMCP-jar-with-dependencies.jar",
        "PATH\\TO\\office-365.prp"
      ]
    }
  }
}

You can query live Office 365 data with a local, read-only MCP server that wraps the CData JDBC Driver. This server exposes Office 365 data through a simple MCP interface so language models can answer questions about your data without writing SQL.

How to use

You connect an MCP-compatible client to the local MCP server and ask it questions about your Office 365 data. The server presents Tables and Columns derived from Office 365 and supports running SQL-like queries behind the scenes. Use natural language to request information, such as a count of active users, upcoming calendar events, or the status of recent tickets. You don’t need to craft SQL queries yourself; the MCP client translates your questions into tool calls to read data and return results.

How to install

Prerequisites: you need Java and Maven installed on your machine.

# 1. Clone the project
git clone https://github.com/cdatasoftware/office-365-mcp-server-by-cdata.git
cd office-365-mcp-server-by-cdata

# 2. Build the server
mvn clean install
# This creates the JAR file: CDataMCP-jar-with-dependencies.jar

3. Download and install the CData JDBC Driver for Office 365 from the provider. 4. License the CData JDBC Driver by running the license command from the installation’s lib directory and entering your name, email, and a license key. 5. Configure the data-source connection. Use the driver’s Connection String utility to create a connection string and test the connection. Copy the resulting connection string for later use. 6. Create a .prp file (for example office-365.prp) with the following properties to configure the MCP server:<br/>Prefix=office365<br/>ServerName=CDataOffice365<br/>ServerVersion=1.0<br/>DriverPath=PATH\\TO\\cdata.jdbc.office365.jar<br/>DriverClass=cdata.jdbc.office365.Office365Driver<br/>JdbcUrl=jdbc:office365:InitiateOAuth=GETANDREFRESH;<br/>Tables=

Available tools

office365_get_tables

Retrieves a list of available tables in the data source. The output is CSV with a header row describing the columns.

office365_get_columns

Retrieves a list of columns for a specified table. The output is CSV with column headers as the first row.

office365_run_query

Executes a SQL SELECT query against the data source and returns the result set.