office-365 -by-cdata
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/).
claude mcp add --transport stdio cdatasoftware-office-365-mcp-server-by-cdata java -jar /PATH/TO/CDataMCP-jar-with-dependencies.jar /PATH/TO/office-365.prp
How to use
This MCP server provides a read-only interface to Office 365 data via the CData MCP bridge. It exposes tools to list tables and columns and to run SQL queries against Office 365 data. To use it, configure your MCP client (for example Claude Desktop) to launch the Java process with the provided .prp file, which contains the JDBC connection details. The server reads from standard input/output, so it is intended to run on the same machine as the client. The available tools include office_365_get_tables, office_365_get_columns, and office_365_run_query (the exact names depend on the configured server prefix), which map to listing tables, listing columns, and executing SQL SELECT queries respectively.
Once configured, you can query live Office 365 data by issuing JSON-RPC requests to the server, for example to retrieve tables, columns, or to execute a query against the data source.
How to install
Prerequisites:
- Java JDK 8+ installed on your machine
- Maven (optional if building from source)
- The CData JDBC Driver for Office 365 (download and license as per the driver docs)
Installation steps:
- Clone the repository and navigate into it: git clone https://github.com/cdatasoftware/office-365-mcp-server-by-cdata.git cd office-365-mcp-server-by-cdata
- Build the MCP server: mvn clean install This produces the JAR file at target/CDataMCP-jar-with-dependencies.jar
- Download and install the CData JDBC Driver for Office 365 and license it as described in the README (via the driver’s license utility).
- Create the JDBC connection properties file (office-365.prp) with the required properties: Prefix, ServerName, ServerVersion, DriverPath, DriverClass, JdbcUrl, Tables. See the README example for the exact file format.
- Run the MCP server: java -jar target/CDataMCP-jar-with-dependencies.jar /path/to/office-365.prp
Additional notes
Tips and notes:
- The server is designed to be read-only by default; ensure your .prp and driver configuration reflect your desired access level.
- The MCP server uses stdio, so it should be run on the same host as the client that will consume it.
- If Claude Desktop (or your MCP client) doesn’t detect the server, completely restart the client after starting the Java process, and verify that the .prp path and JDBC driver path are correct.
- Keep your login credentials and license information secure, especially in shared environments.
