MCP.so
Sign In
D

Dynamics CRM MCP Server by CData

@CDataSoftware

Basic information

Category

Data & Analytics

Transports

stdio

Author

CDataSoftware

Submitted by

Cameron Leblanc

About Dynamics CRM MCP Server by CData

This project builds a read-only MCP server. For full read, write, update, delete, and action capabilities and a simplified setup, check out our free [CData MCP Server for Dynamics CRM (beta)](https://www.cdata.com/download/download.aspx?sku=RMZK-V&type=beta).

#dynamics-crm#mcp-server#cdata

Dynamics CRM MCP Server by CData config

Add this server to your MCP-compatible client using the configuration below.

{
  "mcpServers": {
    "{classname_dash}": {
      "command": "PATH\\TO\\java.exe",
      "args": [
        "-jar",
        "PATH\\TO\\CDataMCP-jar-with-dependencies.jar",
        "PATH\\TO\\dynamics-crm.prp"
      ]
    }
  }
}

Dynamics CRM MCP Server by CData tools

Tool list not available yet

This listing does not currently have a tool list to display. This does not mean the server has no tools; check its documentation for supported capabilities.

We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.

Overview

What is Dynamics CRM MCP Server by CData?

This is a read-only MCP server that allows LLMs to query live Dynamics CRM data via natural language, powered by the CData JDBC Driver for Dynamics CRM. It exposes Dynamics CRM as SQL relational models through a simple MCP interface.

How to use Dynamics CRM MCP Server by CData?

Clone the repository, build with Maven (mvn clean install), then download and license the CData JDBC Driver for Dynamics CRM. Create a .prp file with your JDBC connection details and add the server to your MCP client (e.g., Claude Desktop) by editing the claude_desktop_config.json. The server runs on stdio and must be on the same machine as the client.

Key features of Dynamics CRM MCP Server by CData

  • Read-only access to live Dynamics CRM data
  • Natural language querying via MCP interface
  • Built on the CData JDBC Driver for Dynamics CRM
  • Supports all tables and columns from the data source
  • Easy integration with Claude Desktop and other MCP clients

Use cases of Dynamics CRM MCP Server by CData

  • Answer ad‑hoc business questions about CRM data without writing SQL
  • Analyze correlations between closed‑won opportunities and account industries
  • Generate live insights from Dynamics CRM tables using natural language

Frequently asked questions

1

Is this server read-only?

Yes, this project builds a read-only MCP server. For full CRUD and action capabilities, see the separate CData MCP Server for Dynamics CRM (beta).

2

What are the runtime requirements?

Java (for the JAR), Maven (for building), and the CData JDBC Driver for Dynamics CRM. The server uses `stdio` transport, so it must run on the same machine as the MCP client.

3

How do I configure the connection?

Create a `.prp` file with properties such as `DriverPath`, `DriverClass`, `JdbcUrl`, and optionally `Tables`. Obtain the JDBC URL using the driver’s connection string utility.

4

Which tables are available?

By default, all tables from the Dynamics CRM data source are accessible. You can restrict access by setting the `Tables` property in the `.prp` file.

5

How do I troubleshoot connectivity issues?

Verify the connection string using the JDBC driver’s utility, ensure the driver is licensed, and fully restart your MCP client (e.g., quit Claude Desktop completely) after adding the server configuration.

Comments

More Data & Analytics MCP servers