# Dynamics 365 MCP

> Microsoft Dynamics 365 MCP connects your AI agent directly to a unified CRM and ERP system. It lets you manage accounts, track sales opportunities, create support cases, and query complex financial data—all through natural conversation.

## Overview
- **Category:** industry-titans
- **Price:** Free
- **Tags:** account-management, opportunity-pipeline, business-processes, crm-integration, lead-tracking, enterprise-data

## Description

Imagine talking to your business software like it’s an extension of your mind. This MCP connects your conversational AI client to Microsoft Dynamics 365's core operations. You stop clicking through tabs and start asking questions. Need to know the total revenue from the EMEA region this quarter? Ask for it. Want to update a deal value or assign ownership on a stalled opportunity? Tell the agent. The system handles the record updates, case creation, and data lookups behind the scenes. Because Vinkius manages thousands of MCPs, connecting your AI agent to Dynamics 365 means you get instant access to manage accounts, pipeline status, and financial records without ever leaving your chat window.

## Tools

### query_dataverse
Queries any core business data set, including accounts, contacts, opportunities, incidents, leads, sales orders, and invoices.

### count_records
Gets a simple count of records in any Dynamics 365 entity without fetching the full data set.

### get_record
Retrieves all details for one specific record using its unique ID.

### create_record
Creates a brand new record in Dynamics 365 by providing the necessary field values in JSON format.

### update_record
Modifies an existing record, allowing you to specify only the fields that need changing.

### delete_record
Permanently removes a Dynamics 365 record from the system; this action is irreversible.

### list_accounts
Retrieves a filtered list of all associated accounts within your organization's Dynamics 365 environment.

### list_opportunities
Lists sales opportunities, enabling filtering by stage, estimated value, or close date.

### list_cases
Retrieves a list of all active and closed support cases (incidents).

### list_contacts
Provides an overview list of contacts associated with the system.

## Prompt Examples

**Prompt:** 
```
Show me all opportunities closing this month with value above $100K.
```

**Response:** 
```
Found 8 opportunities closing this month with value > $100K: 1. 'Enterprise Cloud Migration' — $450,000 (Stage: Negotiate, Probability: 85%), 2. 'Digital Transformation Q2' — $280,000 (Stage: Propose, Probability: 70%), and 6 more. Total pipeline value: $1,890,000. Want details on any deal?
```

**Prompt:** 
```
Create a new support case for account 'Contoso Ltd' about a billing discrepancy.
```

**Response:** 
```
Support case CAS-2026-12345 created successfully. Account: Contoso Ltd, Subject: 'Billing Discrepancy', Priority: High, Status: Active. The case has been assigned to the Billing Support queue. Would you like to attach any documents or add internal notes?
```

**Prompt:** 
```
What's the total revenue from the EMEA region this quarter?
```

**Response:** 
```
EMEA Revenue (Q2 2026): Total closed-won revenue: €3,240,000 across 34 deals. Top contributors: 1. UK — €1,120,000 (15 deals), 2. Germany — €890,000 (8 deals), 3. France — €620,000 (6 deals). Quarter-over-quarter growth: +14.2%. Want a breakdown by product line?
```

## Capabilities

### Manage Account Data
You can list, retrieve details for, or create entirely new account and contact records.

### Track Sales Opportunities
The agent lets you query open deals by stage or probability, and update the values and owners of specific opportunities.

### Process Support Cases
You can create new support tickets (cases) for any account and track their progress through resolution cycles.

### Handle Financial Operations
The MCP allows querying journal entries and specific General Ledger accounts housed in Business Central.

### Build Records
You can create new records across multiple data types, including sales orders, quotes, or invoices.

## Use Cases

### Checking the Q3 Pipeline Status
A sales rep needs to know which deals are likely closing next quarter. Instead of running a complex report, they ask their agent: 'Show me all opportunities closing in Q3 with value above $50K.' The MCP runs list_opportunities and summarizes the total revenue for review.

### Handling an Urgent Billing Issue
A customer calls about a billing discrepancy. The agent creates a new support case using the relevant account ID, assigning it 'High' priority status immediately so the support team can jump on it.

### Getting Financial Oversight Quickly
A financial analyst needs to verify Q2 expenses related to a specific business unit. They prompt the agent to query journal entries for that period, getting immediate confirmation of the General Ledger accounts involved.

### Updating an Account After a Meeting
After a meeting, the rep needs to update key details. They use the update_record function to change the account ownership and advance the opportunity stage from 'Qualify' to 'Proposal,' all in one chat command.

## Benefits

- Stop opening multiple tabs to check pipeline status. You can use list_opportunities to query open deals by stage or probability directly in chat.
- Write support cases without leaving your workflow. Use the agent to create a new support case for any account, tracking resolution progress automatically.
- Never lose track of client details again. The MCP lets you list_contacts and list_accounts so you always know who's connected to what deal.
- Accelerate sales cycles by managing deals conversationally. You can update_record on opportunities or create a quote without navigating the full Dynamics UI.
- Access financial depth instantly. Query journal entries and G/L accounts directly, making it easier for finance teams to check business process flows.
- Get data fast. Instead of downloading large CSVs, use count_records to quickly verify how many records exist in an entity set.

## How It Works

The bottom line is you talk to a single interface that handles all your complex business data operations in Dynamics 365.

1. First, subscribe to this MCP and enter your required Azure AD credentials (Client ID, Secret, Tenant ID) along with the Dynamics 365 environment URL.
2. Next, connect your preferred AI client. Once authorized, your agent gains programmatic access to all core CRM and ERP tools.
3. Finally, simply ask your agent natural language questions—like 'Show me opportunities over $100K closing this month'—and the MCP executes the required operations.

## Frequently Asked Questions

**How does the Microsoft Dynamics 365 MCP handle security permissions?**
The system uses your provided Azure AD credentials to ensure that all actions are performed within the scope of your user permissions, meaning you only interact with data you are authorized to see or change.

**Can I use the Microsoft Dynamics 365 MCP for reporting on invoices?**
Yes. You can query_dataverse specific invoice records and even create new sales orders using the MCP, allowing for end-to-end transaction management.

**Is list_opportunities the best way to check my pipeline status?**
list_opportunities is designed specifically to filter by stage, probability, or close date. This makes it faster and more accurate than a general data query for sales forecasting.

**What if I want to delete an account record using the Microsoft Dynamics 365 MCP?**
You can use the delete_record tool, but be warned: this action is irreversible. The agent will confirm the record ID before proceeding.

**Does the MCP support custom tables outside of core CRM data?**
Yes, you can access any Dataverse entity through the Web API using query_dataverse, which includes custom tables and relationships built into your environment.