microsoft-exchange -by-cdata

This MCP server exposes Microsoft Exchange data via a read-only MCP interface built on top of the CData JDBC Driver. It wraps the JDBC driver and presents tables and a SQL-like surface that clients (such as Claude Desktop or other MCP clients) can query using the built-in tools. The server is designed for local, read-only access so you can ask natural language questions about Exchange data without writing SQL. Available tools include getting the list of tables, listing columns for a table, and running read-only queries against the data source. Use the provided JSON-RPC tool names in your client (for example, microsoft_exchange_get_tables, microsoft_exchange_get_columns, and microsoft_exchange_run_query) to discover schema and retrieve data.

To use it from Claude Desktop or similar clients, configure the MCP server entry to point to the Java runtime and the CDataMCP JAR with the path to your microsoft-exchange.prp configuration. Once loaded, you can simply prompt the AI to answer questions about your Exchange data, such as calendar events, emails metadata, or mailbox information, provided the underlying JDBC driver exposes those views via the MCP surface.

Prerequisites:

• Java Runtime Environment (JRE) or JDK installed and available in your PATH
• Maven installed to build the MCP JAR
• CData JDBC Driver for Microsoft Exchange installed and licensed (as per the project requirements)
• Access to the Microsoft Exchange environment and a properly created .prp file describing your connection

Install steps:

1. Clone the repository and navigate to it:

git clone https://github.com/cdatasoftware/microsoft-exchange-mcp-server-by-cdata.git
cd microsoft-exchange-mcp-server-by-cdata

2. Build the MCP server JAR with dependencies:

mvn clean install

This generates a file similar to CDataMCP-jar-with-dependencies.jar. 3) Download and install the CData JDBC Driver for Microsoft Exchange from: https://www.cdata.com/drivers/exchange/download/jdbc 4) License the JDBC driver as required by the driver instructions (usually via a jar command in the lib folder). 5) Create the JDBC connection properties file (example microsoft-exchange.prp) with the required fields:

Prefix=exchange
ServerName=CDataExchange
ServerVersion=1.0
DriverPath=PATH\TO\cdata.jdbc.exchange.jar
DriverClass=cdata.jdbc.exchange.ExchangeDriver
JdbcUrl=jdbc:exchange:InitiateOAuth=GETANDREFRESH;
Tables=

6. Run the MCP server using the JAR and the PRP file:

java -jar /PATH/TO/CDataMCP-jar-with-dependencies.jar /PATH/TO/microsoft-exchange.prp

Note: The server uses stdio, so it is typically intended to run on the same machine as your MCP client.

Tips and considerations:

• The server provided by this repository is read-only. It supports querying Exchange data via the MCP interface, not modifying it.
• The MCP server runs via Java and expects a .prp configuration file that points to the JDBC driver and connection details.
• If Claude Desktop (or another client) cannot see the MCP server, ensure you have fully restarted the client after adding or updating the config, and verify that the server process is running and reachable on the local machine.
• The provided JSON-RPC examples show how to call the available tools: microsoft_exchange_get_tables, microsoft_exchange_get_columns, and microsoft_exchange_run_query. Adjust the table and SQL queries to your schema.
• The connection string and driver setup may require OAuth or additional authentication steps depending on your Exchange environment. Ensure you complete any browser-based authentications during driver setup if prompted.