Office 365 MCP Server by CData

Name: Office 365 MCP Server by CData
Author: CDataSoftware

@CDataSoftware

Office 365 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 Office 365 (beta): https://www.cdata.com/download/download.aspx?sku=CXZK-V&type=beta

#office-365 #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\\office-365.prp"
      ]
    }
  }
}

ツール

ツールは検出されませんでした

ツールは README から自動的に抽出されます。メンテナーは ## Tools という見出しの下に記載することで、このタブに反映できます。

概要

What is Office 365 MCP Server by CData?

This read-only MCP server enables LLMs like Claude Desktop to query live Office 365 data using natural language. It wraps the CData JDBC Driver for Office 365, exposing Office 365 as relational SQL models that AI clients can read without requiring SQL.

How to use Office 365 MCP Server by CData?

Clone the repository, build with mvn clean install, download and license the CData JDBC Driver for Office 365, configure a connection string using the driver’s utility, create a .prp file with driver path and JDBC URL, then add the server to your client’s config (e.g., claude_desktop_config.json). Run the server with java -jar CDataMCP-jar-with-dependencies.jar PATH/TO/office-365.prp. The server uses stdio transport, so it must run on the same machine as the client.

Key features of Office 365 MCP Server by CData

Read-only access to Office 365 live data
Powered by the CData JDBC Driver for Office 365
Exposes tools: {servername}_get_tables, {servername}_get_columns, {servername}_run_query
Query data via natural language – no SQL needed
MIT licensed – free to use, modify, and distribute

Use cases of Office 365 MCP Server by CData

Ask “What calendar events do I have today?” without writing SQL
Analyze correlations between closed won opportunities and account industry
Retrieve live ticket counts from a SUPPORT project
Explore available tables and columns in Office 365 data

FAQ from Office 365 MCP Server by CData

What is the difference between this server and the CData MCP Server for Office 365 (beta)?

This server is read-only. The beta version supports full read, write, update, delete, and action capabilities with a simplified setup.

What are the system requirements?

You need Java, Maven, and the CData JDBC Driver for Office 365 (installed and licensed). The server runs on Windows, Mac, or Linux.

Does this server support write operations?

No. It is explicitly a read-only server.

What transport does it use?

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

How can I get help if I have issues?

Contact the CData Support Team at their support page or join the CData Community for troubleshooting and feedback.

「その他」の他のコンテンツ

FastMCP v2 🚀

jlowin

🚀 The fast, Pythonic way to build MCP servers and clients.

26.0K

Codelf

unbug

A search tool helps dev to solve the naming things problem.

14.2K

Activepieces

activepieces

AI Agents & MCPs & AI Workflow Automation • (~400 MCP servers for AI agents) • AI Automation / AI Agent with MCPs • AI Workflows & AI Agents • MCPs for AI Agents

23.2K