home / mcp / dynamics 365 business central mcp server

Dynamics 365 Business Central MCP Server

This read-only MCP Server allows you to connect to Dynamics 365 Business Central data from Claude Desktop through CData JDBC Drivers. For full CRUD support, check out the first managed MCP platform: CData Connect AI (https://www.cdata.com/ai/).

Installation

Add the following to your MCP client configuration file.

Configuration

View docs

{
  "mcpServers": {
    "cdatasoftware-dynamics-365-business-central-mcp-server-by-cdata": {
      "command": "java",
      "args": [
        "-jar",
        "CDataMCP-jar-with-dependencies.jar",
        "/path/to/dynamics-365-business-central.prp"
      ]
    }
  }
}

You can query live Dynamics 365 Business Central data through a ready-to-use MCP server. This server exposes data via a simple MCP interface so your AI or analytics client can retrieve information with natural language questions, without writing SQL. It’s designed to be run locally with read-only access suitable for LLM-assisted data exploration.

How to use

Launch the MCP server on your machine and connect your MCP client or AI assistant to it. You will interact with Dynamics 365 Business Central data through built-in tools that let you list available tables, inspect table columns, and run read-only queries. Use natural language prompts to ask questions like “What is the total revenue by quarter for top customers?” or “Show me open support tickets related to product X.” The server handles translating your requests into safe, read-only data queries and returns results in a structured format.

How to install

Prerequisites you need before installation:

1. Java installed (JDK 8+). Ensure java is available on your PATH.

2. Maven installed for building the MCP server.

3. Access to the CData JDBC Driver for Dynamics 365 Business Central (license or trial) and the JDBC driver JAR.

Additional setup steps

Step-by-step flow to prepare and run the MCP server locally is shown below. Follow these exact commands to build the server, configure the JDBC connection, and start the MCP service.

# 1) Clone the repository
git clone https://github.com/cdatasoftware/dynamics-365-business-central-mcp-server-by-cdata.git
cd dynamics-365-business-central-mcp-server-by-cdata

# 2) Build the server
mvn clean install

# This creates the JAR: CDataMCP-jar-with-dependencies.jar

# 3) Install the CData JDBC Driver for Dynamics 365 Business Central (follow the vendor’s installer)
# After installation, license the driver (example paths shown in typical setups)
# Windows example
# java -jar cdata.jdbc.d365businesscentral.jar --license
# Mac/Linux example
# java -jar cdata.jdbc.d365businesscentral.jar --license

# 4) Configure the JDBC connection using the driver utility
java -jar cdata.jdbc.d365businesscentral.jar
# Use the Connection String utility to test and copy the JDBC URL

# 5) Create a .prp file for the JDBC connection
# Example contents (adjust paths and values to your environment)
Prefix=d365businesscentral
ServerName=CDataD365BusinessCentral
ServerVersion=1.0
DriverPath=/path/to/cdata.jdbc.d365businesscentral.jar
DriverClass=cdata.jdbc.d365businesscentral.D365BusinessCentralDriver
JdbcUrl=jdbc:d365businesscentral:InitiateOAuth=GETANDREFRESH;
Tables=

# 6) Start the MCP server using the .prp file
java -jar CDataMCP-jar-with-dependencies.jar /path/to/dynamics-365-business-central.prp
"}]} ,{

Notes on configuration and runtime

The MCP server runs with stdio when started locally, which means the client must run on the same machine. You will typically see a start command like: java -jar CDataMCP-jar-with-dependencies.jar /path/to/dynamics-365-business-central.prp

Troubleshooting and tips

If you can’t see the MCP server in your client, make sure the client is fully closed and reopened so the server process is detected. Verify the JDBC connection string by testing it with the driver utility and ensure the .prp file contains the correct JdbcUrl and paths. If you run into data access issues, confirm that the data source configuration is correct and that the license for the JDBC driver is valid.

Tools and usage patterns

The server exposes tools to list tables, list columns for a table, and run a SELECT query. You do not need to call the tools directly; ask your AI client questions and it will use these capabilities to fetch results from Dynamics 365 Business Central.

Available tools

d365bc_get_tables

Retrieves a list of tables available in Dynamics 365 Business Central. The output is CSV with headers on the first line.

d365bc_get_columns

Retrieves a list of columns for a specified table. The output is CSV with headers on the first line.

d365bc_run_query

Executes a SQL SELECT query against the connected data source and returns results.