microsoft-teams-mcp-server-by-cdata

What is microsoft-teams-mcp-server-by-cdata?

CData’s Model Context Protocol (MCP) Server for Microsoft Teams is a read-only server that allows LLMs (such as Claude Desktop) to query live Microsoft Teams data using the CData JDBC Driver for Microsoft Teams. It exposes Teams data as relational SQL models through a simple MCP interface, enabling natural‑language questions without SQL.

How to use microsoft-teams-mcp-server-by-cdata?

Clone the repository, build the JAR with mvn clean install, download and license the CData JDBC Driver for Microsoft Teams, create a .prp file with your JDBC connection details, then configure the server in Claude Desktop’s claude_desktop_config.json under mcpServers. Run or restart Claude Desktop to start using the server.

Key features of microsoft-teams-mcp-server-by-cdata

• Read‑only MCP server for Microsoft Teams data
• Wraps CData JDBC Driver for Microsoft Teams
• Exposes Teams data as relational SQL models
• Allows natural‑language queries via AI clients
• Provides get_tables, get_columns, and run_query tools
• Results returned in CSV format

Use cases of microsoft-teams-mcp-server-by-cdata

• Ask Claude Desktop about Teams channels, members, or messages
• Retrieve live calendar events from Microsoft Teams
• Query Teams data without writing SQL or API code
• Integrate Teams data into AI‑powered workflows
• Discover available tables and columns interactively

FAQ from microsoft-teams-mcp-server-by-cdata

Is this server read‑write or read‑only?

This project builds a read‑only MCP server. A separate CData MCP Server for Microsoft Teams (beta) offers full read, write, update, delete, and action capabilities.

What are the runtime requirements?

You need Java installed, the CData JDBC Driver for Microsoft Teams (downloaded, installed, and licensed), and an MCP‑compatible client like Claude Desktop.

How does the server connect to Microsoft Teams?

It uses the CData JDBC Driver for Microsoft Teams, which connects via OAuth. The connection string is configured in a .prp file and tested with the driver’s Connection String utility.

What transport does the server use?

The server uses stdio transport, so it can only be used with clients that run on the same machine as the server.

How do I troubleshoot connection issues?

Verify the connection string with the driver’s utility, ensure the .prp file is correct, and fully quit and restart Claude Desktop. For further help, contact CData Support or the CData Community.