Microsoft Business Central MCP Server
This server lets AI assistants interact with Microsoft Dynamics 365 Business Central data through MCP tools.
Retrieve schema/metadata for Business Central resources (e.g., customers, contacts, sales orders)
List records with optional OData filtering, top, and skip for pagination
Get items by matching a specific field value
Create new records in any supported resource
Update existing records by ID
Delete records by ID
Authenticate via Azure CLI or client credentials (service-to-service)
Click on "Deploy Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type
@followed by the MCP server name and your instructions, e.g., "@Microsoft Business Central MCP Server show me my top 10 customers by sales"
That's it! The server will respond to your query, and you can continue using it as needed.
Here is a step-by-step guide with screenshots.
Microsoft Business Central MCP Server
Model Context Protocol (MCP) server for Microsoft Dynamics 365 Business Central. Provides AI assistants with direct access to Business Central data through properly formatted API v2.0 calls.
Features
✅ Correct API URLs: Uses proper
/companies(id)/resourceformat (no ODataV4 segment)✅ Zero Installation: Run with
npx- no pre-installation required✅ Azure CLI Auth: Leverages existing Azure CLI authentication
✅ Client Credentials Auth: Service-to-service authentication for AI agents
✅ Clean Tool Names: No prefixes, just
get_schema,list_items, etc.✅ Full CRUD: Create, read, update, and delete Business Central records
Related MCP server: Microsoft Business Central MCP Server
Installation
Using npx (Recommended)
No installation needed! Configure in Claude Desktop or Claude Code:
{
"mcpServers": {
"business-central": {
"type": "stdio",
"command": "cmd",
"args": ["/c", "npx", "-y", "@knowall-ai/mcp-business-central"],
"env": {
"BC_URL_SERVER": "https://api.businesscentral.dynamics.com/v2.0/{tenant-id}/{environment}/api/v2.0",
"BC_COMPANY": "Your Company Name",
"BC_AUTH_TYPE": "azure_cli"
}
}
}
}Note for Windows: Use cmd with /c as shown above for proper npx execution.
Using Smithery
Install via Smithery:
npx -y @smithery/cli install @knowall-ai/mcp-business-central --client claudeLocal Development
git clone https://github.com/knowall-ai/mcp-business-central.git
cd mcp-business-central
npm install
npm run build
node build/index.jsConfiguration
Environment Variables
Variable | Required | Description | Example |
| Yes | Business Central API base URL |
|
| Yes | Company display name |
|
| No | Authentication type (default: |
|
| For client_credentials | Azure AD tenant ID |
|
| For client_credentials | App registration client ID |
|
| For client_credentials | App registration client secret |
|
Getting Your Configuration Values
Tenant ID: Find in Azure Portal → Azure Active Directory → Overview
Environment: Usually
ProductionorSandboxCompany Name: The display name shown in Business Central
Example URL format:
https://api.businesscentral.dynamics.com/v2.0/00000000-0000-0000-0000-000000000000/Production/api/v2.0Authentication
Recommendation: Use
azure_cliauthentication - it's simpler to set up and more reliable. Theclient_credentialsmethod is also supported but has known configuration challenges with Business Central's Microsoft Entra Applications setup. See docs/TROUBLESHOOTING.adoc for details.
Option 1: Azure CLI (Recommended)
The simplest and most reliable authentication method. Uses your existing Azure CLI login.
Prerequisites:
Install Azure CLI: https://docs.microsoft.com/cli/azure/install-azure-cli
Login:
az loginVerify access:
az account get-access-token --resource https://api.businesscentral.dynamics.com
Configuration:
{
"mcpServers": {
"business-central": {
"type": "stdio",
"command": "npx",
"args": ["-y", "@knowall-ai/mcp-business-central"],
"env": {
"BC_AUTH_TYPE": "azure_cli",
"BC_URL_SERVER": "https://api.businesscentral.dynamics.com/v2.0/{tenant-id}/Production/api/v2.0",
"BC_COMPANY": "My Company"
}
}
}
}Option 2: Client Credentials (Service-to-Service)
For automated systems that need to run without user interaction. This method uses OAuth 2.0 client credentials flow.
Note: This method has known configuration challenges. The Business Central "Microsoft Entra Applications" setup can be complex and the application user creation may not work as expected. See docs/TROUBLESHOOTING.adoc for detailed guidance.
Setup Overview:
Create Azure App Registration:
Go to Azure Portal → Azure Active Directory → App registrations
Create new registration (single tenant)
Add API permission: Dynamics 365 Business Central →
app_access(Application permission, NOT Delegated)Grant admin consent for the permission
Add redirect URI:
https://businesscentral.dynamics.com/OAuthLanding.htm
Generate Client Secret:
In your app registration, go to Certificates & secrets
Create a new client secret and save it securely
Configure Business Central:
In Business Central, search for "Microsoft Entra Applications"
Click + New and enter your app's Client ID
Set a Description (this becomes the application user name)
Set State to "Enabled" - you should see "A user named '[Description]' will be created"
Add permission sets:
D365 BUS FULL ACCESS(recommended) orD365 READLeave Company field blank for all companies access
Click "Grant Consent"
Verify Setup:
The application user should appear in the Users list in Business Central
If not, see docs/TROUBLESHOOTING.adoc for solutions
References:
Available Tools
1. get_schema
Get OData metadata for a Business Central resource.
Parameters:
resource(string, required): Resource name (e.g.,customers,contacts,salesOpportunities)
Example:
{
"resource": "customers"
}2. list_items
List items with optional filtering and pagination.
Parameters:
resource(string, required): Resource namefilter(string, optional): OData filter expressiontop(number, optional): Maximum number of items to returnskip(number, optional): Number of items to skip for pagination
Example:
{
"resource": "customers",
"filter": "displayName eq 'Contoso'",
"top": 10
}3. get_items_by_field
Get items matching a specific field value.
Parameters:
resource(string, required): Resource namefield(string, required): Field name to filter byvalue(string, required): Value to match
Example:
{
"resource": "contacts",
"field": "companyName",
"value": "Contoso Ltd"
}4. create_item
Create a new item in Business Central.
Parameters:
resource(string, required): Resource nameitem_data(object, required): Item data to create
Example:
{
"resource": "contacts",
"item_data": {
"displayName": "John Doe",
"companyName": "Contoso Ltd",
"email": "john.doe@contoso.com"
}
}5. update_item
Update an existing item.
Parameters:
resource(string, required): Resource nameitem_id(string, required): Item ID (GUID)item_data(object, required): Fields to update
Example:
{
"resource": "customers",
"item_id": "1366066e-7688-f011-b9d1-6045bde9b95f",
"item_data": {
"displayName": "Updated Name"
}
}6. delete_item
Delete an item from Business Central.
Parameters:
resource(string, required): Resource nameitem_id(string, required): Item ID (GUID)
Example:
{
"resource": "contacts",
"item_id": "a1b2c3d4-e5f6-g7h8-i9j0-k1l2m3n4o5p6"
}Common Resources
companies- Company informationcustomers- Customer recordscontacts- Contact recordssalesOpportunities- Sales opportunitiessalesQuotes- Sales quotessalesOrders- Sales orderssalesInvoices- Sales invoicesitems- Product/service itemsvendors- Vendor records
Troubleshooting
See docs/TROUBLESHOOTING.adoc for detailed troubleshooting guides covering:
Authentication issues (401 errors, token problems)
client_credentialssetup challenges and known issuesCompany not found errors
Environment-specific configuration (Production vs Sandbox)
Development
# Install dependencies
npm install
# Build TypeScript
npm run build
# Watch mode for development
npm run devLicense
MIT
Contributing
Issues and pull requests welcome at https://github.com/knowall-ai/mcp-business-central
Related Projects
MCP Specification: modelcontextprotocol.io
Available Tools
6 toolscreate_itemC
Create a new item in Business Central
Inputs: resource (required), item_data (required).
delete_itemB
Delete an item from Business Central
Inputs: item_id (required), resource (required).
get_items_by_fieldB
Get items matching a field value
Inputs: field (required), value (required), resource (required).
get_schemaB
Get schema information for a Business Central resource
Inputs: resource (required).
list_itemsA
Get items from Business Central with filtering and pagination
Inputs: resource (required), top, skip, filter.
update_itemC
Update an existing item in Business Central
Inputs: item_id (required), resource (required), item_data (required).
Tool Schema Changelog
Recent tool additions, removals, and schema changes observed during successful MCP inspections.
Loading tool schema changelog…
TDQS
Scored across 6 tools
Most tools have clearly distinct purposes, but list_items and get_items_by_field both retrieve items and could be confused. The descriptions differentiate them (broad listing vs. field-specific lookup), so the overlap is minor.
All tool names follow a consistent snake_case verb_noun pattern (get_schema, list_items, create_item, etc.). This makes the tool set predictable and easy to navigate.
With 6 tools, the set is well-scoped for item management plus schema access. Each tool serves a distinct function without redundancy or excessive bloat.
The set provides full CRUD coverage for items (create, read/update/delete) and adds schema inspection. Missing a direct get_item by ID, but list_items with filtering likely covers that use case. The scope is item-focused rather than covering all Business Central resources, but that seems intentional.
Maintenance
Related MCP Connectors
Model Context Protocol server for the Apideck Unified API. Connect any MCP-compatible agent framework to 100+ accounting systems, HRIS platforms, file storage providers, and more through one integration. More information https://www.apideck.com/mcp-server
MCP server unifying ERPs, CRMs, APIs and knowledge base for Claude, ChatGPT and Gemini.
MCP server that lets AI assistants use all OneSchema features exposed via the public API.
MCP server for Codat — companies, connections, invoices, bills and financial statements.
Related MCP Servers
- AlicenseBqualityDmaintenanceA Model Context Protocol server that enables interaction with Microsoft Dynamics 365 CRM from Claude Desktop, allowing users to retrieve, create, and update CRM data through natural language.522MIT
- AlicenseAqualityDmaintenanceMCP server for Microsoft Dynamics 365 Business Central that enables AI assistants to query and manage Business Central data via full CRUD operations.62,547 npmMIT
- AlicenseBqualityDmaintenanceMCP server for Microsoft Dynamics 365 Business Central, enabling AI assistants to perform CRUD operations, query data, and retrieve schemas via Business Central API v2.0.62,547 npmMIT
- AlicenseAqualityDmaintenanceMCP server that provides AI assistants direct access to Microsoft Dynamics 365 Business Central using its native WebSocket protocol, enabling page navigation, data operations, actions, and report execution without OData or browser automation.14468 npmMIT