microsoft-onedrive -by-cdata

This MCP server presents Microsoft OneDrive data as read-only tables via the MCP interface. It wraps the CData JDBC Driver for Microsoft OneDrive to expose live OneDrive data as relational-like sources that you can query without writing SQL. After starting the server and wiring it into your Claude Desktop (or any compatible MCP client), you can use the built-in tools to inspect available data and run read queries. The available tools are named after the server and follow the pattern: {servername}_get_tables, {servername}_get_columns, and {servername}_run_query. For this OneDrive server, you will typically use microsoft_onedrive_get_tables to list accessible tables, microsoft_onedrive_get_columns to enumerate columns for a specific table, and microsoft_onedrive_run_query to execute a SELECT query against the data model. You can invoke these tools through JSON-RPC payloads or via your MCP client. For example, to list tables you would call microsoft_onedrive_get_tables, and to query data you would issue microsoft_onedrive_run_query with a SQL SELECT statement. The server runs via stdio, so the client and server must reside on the same machine or adapt through your MCP client’s bridging features.

Prerequisites:

• Java (JDK 8+)
• Maven
• Optional: a Windows/macOS/Linux environment to install the CData JDBC Driver for Microsoft OneDrive if you plan to exercise the JDBC driver locally

Step-by-step:

1. Clone the repository: git clone https://github.com/cdatasoftware/microsoft-onedrive-mcp-server-by-cdata.git cd microsoft-onedrive-mcp-server-by-cdata

2. Build the MCP server: mvn clean install This will produce the JAR file named CDataMCP-jar-with-dependencies.jar in the target directory.

3. Install the CData JDBC Driver for Microsoft OneDrive (required for data access):

   • Download from https://www.cdata.com/drivers/onedrive/download/jdbc
   • Install following the platform-specific instructions

4. License the CData JDBC Driver (example for Windows/Mac/Linux):

   • Navigate to the lib directory inside the driver installation.
   • Run: java -jar cdata.jdbc.onedrive.jar --license
   • Enter your name, email, and a valid license (or TRIAL) as prompted.

5. Configure a JDBC connection (example steps):

   • Run: java -jar cdata.jdbc.onedrive.jar to open the Connection String utility
   • Configure your connection string for OneDrive and test the connection
   • Copy the connection string and save it in a .prp file for the MCP server (e.g., microsoft-onedrive.prp) with properties such as Prefix, ServerName, ServerVersion, DriverPath, DriverClass, JdbcUrl, Tables

6. Run the MCP server (on its own): java -jar /PATH/TO/CDataMCP-jar-with-dependencies.jar /PATH/TO/microsoft-onedrive.prp

Notes:

• The MCP server uses standard output/input (stdio), so it’s intended for use with clients running on the same machine, unless you bridge connections via your MCP client.
• For Claude Desktop specifically, create or update claude_desktop_config.json with a server entry pointing to the above JAR and PRP file paths.

Tips and common issues:

• The server is read-only by design in this package; full read/write/update/delete capabilities are available in the commercial MCP Server variant.
• Ensure the JDBC driver license is valid and the DriverPath in your .prp file correctly points to the cdata.jdbc.onedrive.jar location.
• If Claude Desktop cannot discover the MCP server, fully quit and re-launch Claude Desktop, then verify that the claude_desktop_config.json contains the correct path mappings for java, the MCP JAR, and the .prp file.
• When configuring the connection string, OAuth may require browser-based authentication; complete authentication in the browser and paste any needed tokens/strings back into the .prp file.
• The server exposes a small set of tools by design; you typically use get_tables, get_columns, and run_query to explore and read data. The output format for get_tables/get_columns is CSV, with the first line containing headers.
• If you move your installation to a new path, update the mcpServers entries accordingly in your Claude Desktop config.