dynamics-365-mcp-server-by-cdata
If you are the rightful owner of dynamics-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 Dynamics 365 is a read-only server that allows LLMs to query live data from Dynamics 365 using the CData JDBC Driver.
The CData MCP Server for Dynamics 365 is designed to facilitate the interaction between large language models (LLMs) and Dynamics 365 data. By leveraging the CData JDBC Driver, this server exposes Dynamics 365 data as relational SQL models, enabling LLMs to query live data using natural language without the need for SQL knowledge. This server is read-only, but a full-featured version is available in beta. The setup involves cloning the repository, building the server, and configuring the connection to Dynamics 365. Once configured, the server can be used with AI clients like Claude Desktop to retrieve and interact with Dynamics 365 data.
Features
- Read-only access to Dynamics 365 data through MCP interface.
- Integration with CData JDBC Driver for Dynamics 365.
- Natural language querying without SQL knowledge.
- Compatible with AI clients like Claude Desktop.
- JSON-RPC support for scripting requests.
Tools
{servername}_get_tables
Get a list of available tables in the data source
{servername}_get_columns
Get the column list of specified tables
{servername}_run_query
Execute SQL SELECT query