Sharepoint MCP Server by CData

Name: Sharepoint MCP Server by CData
Author: CDataSoftware

@CDataSoftware

关于 Sharepoint 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 SharePoint (beta)](https://www.cdata.com/download/download.aspx?sku=RSZK-V &type=beta).

#sharepoint #mcp-server #cdata

基本信息

分类

其他

传输方式

stdio

发布者

CDataSoftware

提交者

Cameron Leblanc

配置

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

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

工具

未检测到工具

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

概览

What is Sharepoint MCP Server by CData?

Sharepoint MCP Server by CData is a read-only MCP (Model Context Protocol) server that allows large language models like Claude Desktop to query live SharePoint data using natural language questions. It wraps the CData JDBC Driver for SharePoint, exposing SharePoint data as relational SQL models so no SQL knowledge is required from the user.

How to use Sharepoint MCP Server by CData?

Clone the repository, build the server with Maven (mvn clean install), download and license the CData JDBC Driver for SharePoint, use the connection string utility to configure a JDBC connection, and create a .prp properties file for your connection. Then add the server to your client's MCP configuration (e.g., claude_desktop_config.json). The server runs via stdio and must be on the same machine as the client.

Key features of Sharepoint MCP Server by CData

Read-only access to live SharePoint data
Powered by the CData JDBC Driver for SharePoint
Exposes SharePoint as relational SQL models
Three built-in MCP tools: get_tables, get_columns, run_query
Natural language querying via AI clients like Claude Desktop
Requires Java and Maven build environment

Use cases of Sharepoint MCP Server by CData

Ask natural language questions about your SharePoint data
Retrieve live SharePoint records for analysis via AI chat
Correlate SharePoint data without writing SQL manually
Integrate SharePoint data into Claude Desktop workflows
Explore available SharePoint tables and columns through AI conversation

FAQ from Sharepoint MCP Server by CData

Is this server read-only?

Yes, this project builds a read-only MCP server. For full read, write, update, and delete capabilities, the README suggests the separate CData MCP Server for SharePoint (beta).

What dependencies are required to run the server?

Java and Maven are needed to build and run the server. You must also install and license the CData JDBC Driver for SharePoint.

How does the server connect to SharePoint?

The server connects via a JDBC connection string configured using the CData JDBC Driver's connection string builder utility. The connection details are stored in a .prp properties file.

What transport does the server use to communicate with clients?

The server communicates over stdio, so it can only be used with clients running on the same machine as the server.

What tools does the server expose to AI clients?

The server exposes three tools: get_tables (list available tables), get_columns (list columns for a specific table), and run_query (execute a SQL SELECT query).