Microsoft OneDrive MCP Server by CData

@CDataSoftware

代码仓库

基本信息

分类

文件与存储

传输方式

stdio

作者

CDataSoftware

提交者

Cameron Leblanc

关于 Microsoft OneDrive MCP Server by CData

This project builds a read-only MCP server. For full read, write, update, delete, and action capabilities and a simplified setup, check out our free [CData MCP Server for Microsoft OneDrive (beta)](https://www.cdata.com/download/download.aspx?sku=UOZK-V&type=beta).

#onedrive #mcp-server #data-access

Microsoft OneDrive MCP Server by CData 配置

使用下面的配置,将此服务器添加到你的 MCP 客户端。

{
  "mcpServers": {
    "{classname_dash}": {
      "command": "PATH\\TO\\java.exe",
      "args": [
        "-jar",
        "PATH\\TO\\CDataMCP-jar-with-dependencies.jar",
        "PATH\\TO\\microsoft-onedrive.prp"
      ]
    }
  }
}

Microsoft OneDrive MCP Server by CData 工具

工具列表暂未提供

当前收录暂时没有可展示的工具列表，不代表服务没有工具。请查阅项目文档了解支持的能力。

工具是从 README 中自动提取的。维护者可以在 ## Tools 标题下列出工具,即可填充这部分内容。

概览

What is Microsoft OneDrive MCP Server by CData?

Microsoft OneDrive MCP Server by CData is a read-only MCP server that lets LLMs query live Microsoft OneDrive data through the CData JDBC Driver for Microsoft OneDrive. The driver exposes OneDrive data as relational SQL models, and the server wraps it into a simple MCP interface so you can ask natural language questions without writing SQL.

How to use Microsoft OneDrive MCP Server by CData?

Clone the repository, build with mvn clean install, then install and license the CData JDBC Driver for Microsoft OneDrive. Create a .prp file with connection details (Prefix, ServerName, DriverPath, DriverClass, JdbcUrl). Configure Claude Desktop (or another MCP client) by adding the server to claude_desktop_config.json with the path to java and the compiled JAR and .prp file. The server runs over stdio and must be on the same machine as the client.

Key features of Microsoft OneDrive MCP Server by CData

Read-only access to Microsoft OneDrive data via MCP tools
Uses CData JDBC Driver for Microsoft OneDrive
Natural language queries – no SQL required
Supports listing tables, columns, and running SELECT queries
OAuth-based authentication for Microsoft OneDrive

Use cases of Microsoft OneDrive MCP Server by CData

Query live OneDrive files and metadata using conversational AI
Enable LLMs to answer questions about OneDrive content
Integrate OneDrive data into AI workflows without a separate sync

常见问题

Is this server read-only?

Yes. The README explicitly states that this project builds a read-only MCP server. For full read/write/update/delete capabilities, CData offers a separate free beta MCP Server.

How do I authenticate to Microsoft OneDrive?

Authentication uses OAuth via the CData JDBC Driver. When you configure the connection string (e.g., `jdbc:onedrive:InitiateOAuth=GETANDREFRESH;`), the driver will launch a browser for you to log in and grant access.

What transport does the server use?

The server uses `stdio` as its transport, meaning it runs as a local process and communicates over standard input/output. It can only be used with MCP clients that run on the same machine.

Do I need a license for the CData JDBC Driver?

Yes. You must download and install the CData JDBC Driver for Microsoft OneDrive and license it (either with a trial key or a purchased license) before the server can connect.

What tools are available?

The server exposes three main tools: `{servername}_get_tables` (list all tables), `{servername}_get_columns` (list columns for a given table), and `{servername}_run_query` (execute a SQL SELECT query). Output is returned in CSV format.