Dynamics 365 Business Central MCP Server by CData

@CDataSoftware

About Dynamics 365 Business Central 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 365 Business Central (beta): https://www.cdata.com/download/download.aspx?sku=FBZK-V&type=beta

#dynamics-365 #mcp-server #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-365-business-central.prp"
      ]
    }
  }
}

Tools

No tools detected

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

Overview

What is Dynamics 365 Business Central MCP Server by CData?

It is a read-only MCP (Model Context Protocol) server that allows LLMs (like Claude Desktop) to query live data from Dynamics 365 Business Central using natural language. The server wraps the CData JDBC Driver for Dynamics 365 Business Central, which exposes the data as relational SQL models.

How to use Dynamics 365 Business Central MCP Server by CData?

Clone the repository and build the JAR file with mvn clean install. Download and license the CData JDBC Driver, then configure a .prp file with your JDBC connection details. Finally, configure the server in your MCP client (e.g., Claude Desktop) by editing its claude_desktop_config.json to point to the JAR and .prp file.

Key features of Dynamics 365 Business Central MCP Server by CData

Read-only access to Dynamics 365 Business Central data for LLMs.
Natural language querying with no SQL required.
Powered by the CData JDBC Driver for Dynamics 365 Business Central.
Tools available: get_tables, get_columns, and run_query.
Output returned in CSV format.
Uses stdio transport (same machine as the client).

Use cases of Dynamics 365 Business Central MCP Server by CData

Ask Claude Desktop for sales opportunity correlations by industry.
Query the number of open support tickets from Dynamics 365 Business Central.
Retrieve calendar events for the current day from Business Central.
Explore available tables and columns in your Business Central environment.

FAQ from Dynamics 365 Business Central MCP Server by CData

Is this server read-only?

Yes, this MCP server is read-only. For full CRUD capabilities and a simplified setup, CData offers a free beta MCP Server for Dynamics 365 Business Central.

What dependencies are required to run it?

You need Java (JDK) to run the MCP server JAR and the CData JDBC Driver for Dynamics 365 Business Central, which must be installed and licensed separately.

What transport protocol does the server use?

The server uses stdio transport, so it can only be used with clients running on the same machine as the server.

Can I limit which tables the server can access?

Yes. In the .prp configuration file, you can set the Tables property to a list of specific tables. If left blank, the server will access all available tables.

How do I authenticate to Dynamics 365 Business Central?

Authentication is handled via the JDBC connection string. You can use the Connection String utility (run the driver JAR) to configure OAuth-based authentication and test the connection.

Frequently asked questions

Is this server read-only?

Yes, this MCP server is read-only. For full CRUD capabilities and a simplified setup, CData offers a free beta MCP Server for Dynamics 365 Business Central.

What dependencies are required to run it?

You need Java (JDK) to run the MCP server JAR and the CData JDBC Driver for Dynamics 365 Business Central, which must be installed and licensed separately.

What transport protocol does the server use?

The server uses `stdio` transport, so it can only be used with clients running on the same machine as the server.

Can I limit which tables the server can access?

Yes. In the `.prp` configuration file, you can set the `Tables` property to a list of specific tables. If left blank, the server will access all available tables.

How do I authenticate to Dynamics 365 Business Central?

Authentication is handled via the JDBC connection string. You can use the Connection String utility (run the driver JAR) to configure OAuth-based authentication and test the connection.

Comments

Basic information

More Other MCP servers

MaxKB

1Panel-dev

🔥 MaxKB is an open-source platform for building enterprise-grade agents. 强大易用的开源企业级智能体平台。

22.0K

Inbox Zero AI

elie222

The world's best AI personal assistant for email. Open source app to help you reach inbox zero fast.

11.6K

Maestro

mobile-dev-inc

Painless E2E Automation for Mobile and Web

14.8K

🚀 Model Context Protocol (MCP) Curriculum for Beginners

microsoft

This open-source curriculum introduces the fundamentals of Model Context Protocol (MCP) through real-world, cross-language examples in .NET, Java, TypeScript, JavaScript, Rust and Python. Designed for developers, it focuses on practical techniques for building modular, scalable,

16.7K

FastMCP v2 🚀

jlowin

🚀 The fast, Pythonic way to build MCP servers and clients.

26.0K