dynamics-365-business-central -by-cdata

This MCP server exposes Dynamics 365 Business Central data via a read-only MCP interface built on top of the CData JDBC Driver. It lets large language models and clients query live Business Central data without writing SQL directly. The server is intended for read-only access, enabling natural language questions like reports on sales, customers, or service data, with outputs delivered through the MCP tools. The available tools are named using a server-specific prefix combined with the operation, for example: dynamics_365_business_central_get_tables to list accessible tables, dynamics_365_business_central_get_columns to show columns for a given table, and dynamics_365_business_central_run_query to execute a SQL SELECT against the data source. Each tool returns results in CSV format for tables and columns, or standard query results for run_query. To integrate with Claude Desktop or other clients, add a server entry in your claude_desktop_config.json with the appropriate java command and the path to the JAR and PRP file as shown in the setup instructions.

Prerequisites:

• Java installed (JDK 8+)
• Maven (for building the MCP server JAR)
• CData JDBC Driver for Dynamics 365 Business Central (install and license per your environment)

Installation steps:

1. Clone the repository and navigate to it: 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 MCP server JAR with dependencies: mvn clean install This should produce a JAR similar to CDataMCP-jar-with-dependencies.jar

3. Install and license the CData JDBC Driver for Dynamics 365 Business Central:

   • Download from: https://www.cdata.com/drivers/d365businesscentral/jdbc
   • Follow the driver installation steps for your OS
   • License the driver by running in the lib folder: java -jar cdata.jdbc.d365businesscentral.jar --license (provide name, email, and TRIAL or license key)

4. Prepare a .prp configuration file for your JDBC connection, e.g. dynamics-365-business-central.prp, with values like: 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=

5. Run the MCP server: java -jar /PATH/TO/CDataMCP-jar-with-dependencies.jar /PATH/TO/dynamics-365-business-central.prp

6. (Optional) Integrate with Claude Desktop by adding the server configuration to claude_desktop_config.json as shown in the readme.

Notes and tips:

• The MCP server is read-only by design; write/update/delete operations are not exposed in this configuration.
• The server uses stdio for the process, so it must run on the same machine as clients that communicate with it.
• Ensure the JDBC driver is licensed and accessible via the DriverPath in your PRP file.
• For Claude Desktop integration, configure the cryptic server name ( classname_dash ) consistently in your claude_desktop_config.json so that tools like dynamics_365_business_central_get_tables appear under the expected server name.
• If you encounter connection issues, verify the JdbcUrl and that the driver jar is on the classpath referenced by DriverPath. Check that the PRP file is accessible at the path specified in the command line.
• The available tools return tables and columns in CSV format; the run_query tool returns SQL results as CSV or tabular output depending on the driver.