Dynamics 365 MCP Server By Cdata

What is dynamics-365-mcp-server-by-cdata?

dynamics-365-mcp-server-by-cdata is a read-only Model Context Protocol (MCP) server that enables large language models (LLMs) like Claude Desktop to query live data from Microsoft Dynamics 365. It wraps the CData JDBC Driver for Dynamics 365, exposing the CRM data as a relational SQL model so AI clients can retrieve information through natural language questions without writing SQL.

How to use dynamics-365-mcp-server-by-cdata?

Clone the repository, build the JAR with mvn clean install, download and license the CData JDBC Driver for Dynamics 365, then create a .prp configuration file with your JDBC connection string. Finally, add the server to your MCP client’s configuration (e.g., claude_desktop_config.json) pointing to the JAR and the .prp file. The server communicates via stdio, so the client must run on the same machine. Once configured, you can ask the AI questions like “What is the correlation between my closed won opportunities and the account industry?”

Key features of dynamics-365-mcp-server-by-cdata

• Read-only access to Dynamics 365 data via MCP.
• No SQL required: LLMs query data in natural language.
• Built on the CData JDBC Driver for Dynamics 365.
• Exposes three tools: get_tables, get_columns, and run_query.
• Tools return results in CSV format with header rows.
• Supports any MCP client that can run a local server.

Use cases of dynamics-365-mcp-server-by-cdata

• Ask an AI assistant for real-time sales or support ticket summaries.
• Perform cross-table analysis (e.g., correlate opportunities with account industry).
• Retrieve live CRM records without writing or exposing SQL queries.
• Enable natural-language reporting for non-technical team members.