:heavy_exclamation_mark: This project builds a local, read-only MCP server. For fully remote MCP access, check out the first managed MCP platform
If you want an AI assistant working directly with Dynamics 365 By Cdata, the dynamics 365 by cdata mcp server is the bridge. :heavy_exclamation_mark: This project builds a local, read-only MCP server. For fully remote MCP access, check out the first managed MCP platform: CData Connect AI. For locally hosted, full read, write, update, delete, and action capabilities and a simplified setup.
:heavy_exclamation_mark: This project builds a local, read-only MCP server. For fully remote MCP access, check out the first managed MCP platform: CData Connect AI. For locally hosted, full read, write, update, delete, and action capabilities and a simplified setup, check out our CData MCP Server for Dynamics 365. ## Purpose We created this read-only MCP Server to allow LLMs (like Claude Desktop) to query live data Dynamics 365 supported by the CData JDBC Driver for Dynamics 365.
Once connected, the assistant can call these 3 tools directly:
dynamics_365_get_tables — The dynamics_365_get_tables tool exposed by this serverdynamics_365_get_columns — The dynamics_365_get_columns tool exposed by this serverdynamics_365_run_query — The dynamics_365_run_query tool exposed by this serverSetup follows the standard MCP pattern: clone or install the server, then register it in your client's configuration file and restart the client. The configuration snippets on this page cover Claude Desktop, Claude Code and Cursor.
Developer-tool servers are usually the first ones people connect, because they turn "help me with this code" into an assistant that can actually read the repo and act on it. Dynamics 365 By Cdata sits in that group, and the shape of its toolset — dynamics_365_get_tables, dynamics_365_get_columns, dynamics_365_run_query — tells you what it is really for. Worth comparing against the other developer tools servers in this directory before you commit to one, since several overlap in scope but differ sharply in setup cost and permissions.
| Tool | What it does |
|---|---|
| dynamics_365_get_tables | The dynamics_365_get_tables tool exposed by this server. |
| dynamics_365_get_columns | The dynamics_365_get_columns tool exposed by this server. |
| dynamics_365_run_query | The dynamics_365_run_query tool exposed by this server. |
**Linux/Mac**
```json
{
"mcpServers": {
"{classname_dash}": {
"command": "/PATH/TO/java",
"args": [
"-jar",
"/PATH/TO/CDataMCP-jar-with-dependencies.jar",
"/PATH/TO/dynamics-365.prp"
]
},
...
}
}Configuration as documented by the project. Restart the client after saving.
Kill hallucinated APIs — version-accurate, up-to-date library documentation injected straight into context.
Microsoft's official browser automation server — drive a real browser through the accessibility tree, no screenshots needed.
GitHub's official server — repos, issues, pull requests, Actions and code security, straight from your assistant.
Issue tracking at the speed of conversation — Linear's official hosted server with OAuth and zero install.
Local repository surgery — status, diffs, commits, branches and history for any repo on disk.
Timezone sanity for AI — current time anywhere and correct conversions, without the model doing date math.