devart-mcp-server-dynamics365-business-central

[](https://www.devart.com/mcp/) # Devart MCP Server for Dynamics 365 Business Central Devart MCP Server for Dynamics 365 Business Central enables AI clients to interact with your data through a secure server running in your environment. It turns a regular AI chat into a practical way to work with real-world business data — and it is faster than conventional export or manual querying. ## Key benefits Devart MCP Server for Dynamics 365 Business Central allows you to: * Work with data intuitively through natural language. * Retrieve the required data for analysis within minutes. * Generate reports faster with AI-powered assistance. * Minimize manual data handling and integration maintenance. ## How it works Devart MCP Server for Dynamics 365 Business Central helps AI clients communicate directly with Dynamics 365 Business Central databases using natural-language prompts. It translates AI requests into structured queries, executes them through Devart connectivity drivers, and returns clean, structured results for seamless AI-powered data access.  ## Quick start To get started with Devart MCP Server for Dynamics 365 Business Central: 1\. [Download](https://www.devart.com/odbc/dynamicsbc/download.html) and [install](https://docs.devart.com/odbc/dynamicsbc/installation-clouds.htm) Devart ODBC Driver for Dynamics 365 Business Central. 2\. [Download](https://www.devart.com/mcp/download.html) and [install](https://docs.devart.com/mcp/installation.html) Devart MCP Server for Dynamics 365 Business Central. 3\. In Devart MCP Server for Dynamics 365 Business Central, [configure your data connection and integration settings](https://docs.devart.com//mcp/connection-configuration.html).  4\. Run your first natural-language query. [](https://www.devart.com/mcp/universal/) ## Manual installation and configuration **Prerequisites** Before building and running Devart MCP Server for Dynamics 365 Business Central, ensure the following components are installed: * [.NET 8 SDK](https://dotnet.microsoft.com/download/dotnet/8.0) * **ODBC connection** — **Devart.AI.McpServer.DynamicsBc.csproj** [Devart ODBC Driver for Dynamics 365 Business Central](https://www.devart.com/odbc/dynamicsbc/download.html) (requires manual download and installation) **Step 1: Clone the repository** Clone the project repository and navigate to the project directory: 1\. Open **Command Prompt**. 2\. Enter the following command: ```cmd git clone https://github.com/devart-ai-connectivity/devart-mcp-server-dynamics365-business-central.git cd devart-mcp-server-dynamics365-business-central ``` **Step 2: Build the MCP Server from source** You can build Devart MCP Server for Dynamics 365 Business Central from source using ODBC. To build the MCP server with ODBC, select the command based on the bitness of your data source. * For 64-bit data source, run the following command: ```cmd dotnet publish Devart.AI.McpServer.Odbc/Devart.AI.McpServer.Odbc.DynamicsBc/Devart.AI.McpServer.Odbc.DynamicsBc.csproj -c ReleaseDynamicsBc -r "win-x64" /p:TargetFramework=net8.0 ``` * For 32-bit data source, run the following command: ```cmd dotnet publish Devart.AI.McpServer.Odbc/Devart.AI.McpServer.Odbc.DynamicsBc/Devart.AI.McpServer.Odbc.DynamicsBc.csproj -c ReleaseDynamicsBc -r "win-x86" /p:TargetFramework=net8.0 ``` >**Note** > >The target platform must match the bitness of your ODBC data source. **Step 3: Configure the database connection for the MCP Server** 1\. Create an `mcpserver.json` configuration file in the directory containing the built MCP Server executable. 2\. In the file, configure the database connection: ```json { "Connections": [ { "Name": "my_dynamicsbc", "DsnName": "your_dsn_name", "ProtocolType": "stdio" } ] } ``` Alternatively, you can configure the database connection using the connection string: ```json { "Connections": [ { "Name": "my_dynamicsbc", "ConnectionString": "Driver={Devart ODBC Driver for Dynamics 365 Business Central};Server=localhost;User ID=dynamicsbc;Password=your_password;Database=your_database;", "ProtocolType": "stdio" } ] } ``` where: * `Name` — The name of the ODBC connection. * `DsnName` — The name of your data source. * `ProtocolType` — A transport protocol. The possible options are: `stdio` or `http`. * `HttpPort` (required if `ProtocolType` is set to `http`) — The port number for the `http` protocol. **Step 4: Run the MCP server** After you configure the MCP Server, you can start it. >**Note** > >This step is required only when `ProtocolType` is configured as `http`. If you use the `stdio` transport protocol, your AI client starts the server automatically. To start the server, run the following command: ```cmd Devart.AI.McpServer.Odbc.DynamicsBc.exe run my_dynamicsbc ``` where `my_dynamicsbc` is the name of the ODBC connection. **Step 5: Integrate with Claude Desktop** 1\. Open `claude_desktop_config.json`, the Claude configuration file. >**Tip** > >If you can't locate the configuration file, it may not exist yet. To create it, open Claude Desktop and navigate to **File** > **Settings** > **Developer**, then click **Edit Config**. The folder with the `claude_desktop_config.json` file opens. 2\. Add one of the following objects, depending on the transport protocol used by MCP Server: * STDIO ```json { "mcpServers": { "devart": { "command": "C:\\path\\to\\Devart.AI.McpServer.Odbc.DynamicsBc.exe", "args": [ "run", "my_dynamicsbc" ] } } } ``` where: * `devart` is the connector name that will appear in Claude Desktop. * `C:\\path\\to\\Devart.AI.McpServer.Odbc.DynamicsBc.exe` is the path to the executable file. * `my_dynamicsbc` is the connection name specified in the `mcpserver.json` configuration file. * **HTTP** ```json "mcpServers": { "devart": { "command": "npx", "args": [ "-y", "mcp-remote", "http://localhost:5000/sse" ] } } ``` where: * `devart` is the connector name that will appear in Claude Desktop. * `5000` is the MCP Server listening port. 3\. Save the file. 4\. Restart Claude Desktop. Devart MCP Server for Dynamics 365 Business Central is now integrated with Claude, and **devart** appears in the Claude Desktop app in **Customize** > **Connectors**. You can also [integrate](https://docs.devart.com/mcp/ai-integration/) Devart MCP Server for Dynamics 365 Business Central with other AI clients such as Cline, Codex, Cursor, Visual Studio Code, Windsurf, Zed. ## Supported clients Devart MCP Server for Dynamics 365 Business Central supports integration with the following AI clients: * Claude Desktop * Visual Studio Code * Cursor * Codex * Windsurf * Cline * Zed * ...and other MCP-compatible AI clients ## Typical use cases Devart MCP Server for Dynamics 365 Business Central is a practical fit for teams working with Dynamics 365 Business Central as their primary data source. * **Financial reporting and period analysis** Query general ledger entries, balance sheets, P&L data, and period comparisons from Business Central in natural language without accountant SQL skills. * **Inventory and warehouse management insights** Let warehouse and operations teams check stock levels, reorder points, item availability, and warehouse movement data directly from Business Central. * **Purchase order and vendor management** Analyze open purchase orders, vendor payment terms, outstanding invoices, and procurement activity stored in Business Central. * **Sales order and customer analysis** Access sales order histories, customer credit limits, outstanding receivables, and order fulfillment status from Business Central data. * **Project and job costing** Query job cards, project budgets, resource utilization, and cost tracking entries from Business Central project management data. * **Cash flow and AP/AR monitoring** Help finance teams monitor accounts payable, accounts receivable, payment due dates, and cash flow projections from Business Central. ## Licensing and activation Devart MCP Server for Dynamics 365 Business Central is distributed as a free single-source MCP server. To connect to Dynamics 365 Business Central, the server requires the corresponding [Devart ODBC Driver for Dynamics 365 Business Central](https://www.devart.com/odbc/dynamicsbc/download.html), which is a paid product. A 30-day free trial is available for the Devart ODBC Driver for Dynamics 365 Business Central. See the product page and documentation for the latest installation and activation details. ## Support * [Documentation](https://docs.devart.com/mcp/) * [Submit a request](https://www.devart.com/company/contactform.html) * [Suggest a feature](https://devart.uservoice.com/) * [Join our forum](https://support.devart.com/portal/en/community) ## Other Devart connectivity solutions * [MCP Server Universal](https://github.com/devart-ai-connectivity/devart-mcp-server-universal) * [ODBC Driver for Dynamics 365 Business Central](https://www.devart.com/odbc/dynamicsbc/download.html)