microsoft-onedrive-mcp-server-by-cdata
This project is a read-only MCP Server for Microsoft OneDrive by CData, designed to allow large language models (LLMs) to query and retrieve data through natural language, with no SQL necessary. It integrates with the CData JDBC Driver to expose Microsoft OneDrive data as SQL models while providing simplified setup and use with AI clients.
Microsoft OneDrive MCP Server by CData
Overview
CData's Model Context Protocol (MCP) Server for Microsoft OneDrive enables LLMs to query live data from Microsoft OneDrive using a read-only MCP server. It connects through the CData JDBC Driver for seamless data exposure in a SQL model but allows natural language queries without SQL.
Setup Guide
- Clone the repository and build the server.
- Download and install the CData JDBC Driver.
- License and configure your connection to Microsoft OneDrive.
- Create a configuration file to add the MCP server to AI clients like Claude Desktop.
Usage Details
Once configured, AI clients use built-in tools to manipulate data through natural language queries. Examples include retrieving data correlations, open tickets counts, and calendar events.
Tools & Descriptions
- Get tables: Returns a list of available tables.
- Get columns: Retrieves columns for a table.
- Run query: Executes SQL SELECT queries.
Troubleshooting
- Ensure full exit or quit of Claude Desktop after setting up.
- Verify accurate configuration and connection string setup.
- Contact CData Support for further assistance.