dynamics-365-mcp-server-by-cdata

dynamics-365-mcp-server-by-cdata

0
databasesai_chatbotdeveloper_tools

CData's MCP Server for Dynamics 365 provides a read-only interface for LLMs to query live Dynamics 365 data through a JDBC driver using natural language. It simplifies data interaction by eliminating the need for SQL knowledge, enabling live data retrieval from Dynamics 365 applications.

CData MCP Server for Dynamics 365

Overview

CData's Model Context Protocol (MCP) Server for Dynamics 365 allows LLMs (like Claude Desktop) to query live data supported by the CData JDBC Driver for Dynamics 365. It is a read-only MCP server that wraps the Dynamics 365 JDBC Driver, exposing data through an MCP interface.

Features

  • Enables retrieval of live Dynamics 365 data using natural language queries leveraged by LLMs.
  • Connects Dynamics 365 to relational SQL models without requiring SQL.

Setup

  1. Clone the repository.
  2. Build the server using Maven to create the necessary JAR.
  3. License and configure the CData JDBC Driver for Dynamics 365.

Usage

  • Configure a .prp file for JDBC connections to access data.
  • Use the server with Claude Desktop for seamless data retrieval from Dynamics 365.
  • Define queries to interact with Dynamics 365 without direct SQL.
  • Run the server locally to ensure connectivity.

Tools & Descriptions

  • {servername}_get_tables: Retrieves available tables.
  • {servername}_get_columns: Retrieves columns for a table.
  • {servername}_run_query: Executes SQL SELECT queries.

Troubleshooting

Ensure full configuration and that Claude Desktop is properly restarted to update the MCP Server visibility.