office-365-mcp-server-by-cdata

office-365-mcp-server-by-cdata

3.3

If you are the rightful owner of office-365-mcp-server-by-cdata and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.

CData's Model Context Protocol (MCP) Server for Office 365 is a read-only server designed to allow LLMs to query live Office 365 data using natural language.

The CData MCP Server for Office 365 is a specialized server that facilitates the interaction between large language models (LLMs) and Office 365 data. By leveraging the CData JDBC Driver for Office 365, this server exposes Office 365 data as relational SQL models, enabling LLMs to access and query live data without the need for SQL knowledge. This server is particularly useful for applications like Claude Desktop, where users can ask natural language questions to retrieve information from Office 365. The server is read-only, meaning it allows data retrieval but not modification. For users seeking full CRUD capabilities, CData offers a beta version of the MCP Server with extended functionalities.

Features

  • Read-only access to Office 365 data through a simple MCP interface.
  • Integration with CData JDBC Driver for Office 365 to expose data as relational SQL models.
  • Enables LLMs to query live data using natural language, eliminating the need for SQL.
  • Compatible with applications like Claude Desktop for seamless data retrieval.
  • Simplified setup process with detailed configuration instructions.

Tools

  1. office_365_get_tables

    Retrieves a list of tables available in the data source.

  2. office_365_get_columns

    Retrieves a list of columns for a specified table.

  3. office_365_run_query

    Executes a SQL SELECT query on the data source.