# Microsoft Dynamics 365 MCP for AI Agents AI Agent Connect

> Microsoft Dynamics 365 MCP connects your CRM and ERP environment to your AI agent. It allows you to manage accounts, track sales opportunities, handle support cases, and query financial data through natural conversation, removing the need to click through complex menus.

## Overview
- **Category:** industry-titans
- **Price:** Free
- **Endpoint:** https://edge.vinkius.com/vk_preview_2D5pZptUti1NAJZPEQkgQp0Hd1cAV4nej1yQGusB/ai-agent-connect
- **Tags:** account-management, opportunity-pipeline, business-processes, crm-integration, lead-tracking, enterprise-data

## Description

This Microsoft Dynamics 365 MCP connects your Dynamics environment to your AI agent so you can manage your CRM and ERP operations through natural conversation. Instead of digging through nested menus to find a customer's history or a specific sales deal, you just ask your agent for the info. You'll be able to create new accounts, update opportunity values, and track support cases without leaving your chat interface. It handles the heavy lifting of navigating the Dataverse for you. Since Vinkius hosts this Connector, you can get it running quickly alongside your other enterprise tools. It bridges the gap between your core business data and your daily workflow, making it feel like your agent actually knows your business. You can query your sales pipeline, check financial dimensions in Business Central, or audit custom entities without ever opening a browser tab. It turns your CRM into a conversational database that responds to your needs in real time.

## Tools

### count_records
The count_records tool gives you a quick tally of records in any entity set. This is perfect for high-level dashboarding where you just need the numbers.

### create_record
The create_record tool adds a new record to Dynamics 365 by providing field values. It lets your agent build new entries for you instantly.

### update_record
Use update_record to change only the specific fields you want on an existing record. This keeps your data clean by avoiding unnecessary overwrites.

### query_dataverse
Use query_dataverse to pull specific data from any entity set using OData filters. It helps you grab exactly what you need without fetching entire tables.

### delete_record
The delete_record tool permanently removes a record from your environment. Use this with caution when you need to clear out old data.

### list_accounts
Use list_accounts to retrieve a list of accounts from your CRM. You can narrow the results down by using specific filters.

### list_opportunities
The list_opportunities tool lets you view your sales opportunities sorted by stage or value. It helps you keep track of your active pipeline.

### list_cases
Use list_cases to pull a list of support cases and incidents. This gives you a clear view of what your team needs to resolve.

### list_contacts
You can use list_contacts to pull a list of all contacts from your system. It makes it easy to see who you're dealing with at a glance.

### get_record
Use get_record to fetch a single record using its unique ID. It lets you see every detail on one specific account or lead.

## Prompt Examples

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

**Response:** 
```
Found 8 opportunities closing this month with value > $100K:

| Deal Name | Value | Stage | Probability |
| :--- | :--- | :--- | :--- |
| Enterprise Cloud Migration | $450,000 | Negotiate | 85% |
| Digital Transformation Q2 | $280,000 | Propose | 70% |
| ... | ... | ... | ... |

**Total Pipeline Value:** $1,890,000. Would you like the details on any of these deals?
```

**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:**
*   **UK:** €1,120,000 (15 deals)
*   **Germany:** €890,000 (8 deals)
*   **France:** €620,000 (6 deals)

**Quarter-over-quarter growth:** +14.2%. Want a breakdown by product line?
```

## Capabilities

### Create and update account records
Add new customer profiles or update existing contact information using plain text.

### Track sales opportunities
Query your active pipeline by stage, value, or close date.

### Manage sales orders
Create quotes and invoices across your sales organization.

### Handle support cases
Track resolution progress and manage SLA compliance for customer incidents.

### Query financial data
Access journal entries and G/L accounts in Business Central.

### Access custom entities
Interact with any Dataverse entity, including custom tables and relationships.

### Advance business processes
Move records through different pipeline stages automatically.

## Use Cases

### Updating a deal during a live call
A rep needs to check the status of a $50k deal during a call. They ask the agent to show the current sales pipeline for a specific client.

### Logging a billing discrepancy
A customer reports a billing issue. The agent finds the account history and logs a new support incident for the billing team.

### Quick financial summaries
A manager needs a summary of last month's entries. The agent pulls the numbers and provides a total revenue overview.

### Auditing duplicate accounts
An admin wants to check for duplicate accounts. They ask the agent to list accounts with a specific name and review the results.

## Benefits

- Faster data entry for sales teams who can create new records using natural language instead of manual typing.
- Keep your pipeline clean by viewing sales opportunities sorted by stage or value to see what's closing soon.
- Faster support response times since your agent can pull a list of cases and see high-priority issues instantly.
- Accurate financial reporting because your agent can pull journal entries and G/L accounts for quick summaries.
- Better data integrity by letting your agent update only the specific fields that matter on an existing record.
- Instant access to specific data points by pulling records from any entity set using simple filters.

## How It Works

The bottom line is you get a conversational interface for your entire enterprise data suite.

1. Subscribe to the Connector via the Vinkius catalog.
2. Enter your Azure AD app credentials and your Dynamics 365 environment URL.
3. Start asking your AI client to perform CRM or ERP tasks like pulling reports or creating records.

## Frequently Asked Questions

**Can the Microsoft Dynamics 365 MCP help with sales pipeline tracking?**
Yes, it allows your AI agent to pull and display your current sales opportunities. You can ask about specific deal values, stages, and close dates to get a clear view of your pipeline without opening the CRM.

**How do I connect Microsoft Dynamics 365 to my AI agent?**
You just need to subscribe to the Connector and provide your Azure AD credentials and environment URL. Once connected, your agent can start interacting with your CRM and ERP data immediately.

**Can I use this Connector to manage my Business Central financial data?**
Yes, it supports financial operations including querying journal entries and G/L accounts. This makes it easy to pull financial data for reports through a simple conversation.

**Does Microsoft Dynamics 365 MCP support custom entities?**
Yes, it can access any Dataverse entity. This includes custom tables and relationships you've built within your Dynamics environment.

**Is my data secure when using the Microsoft Dynamics 365 MCP?**
The Connector uses your existing Azure AD credentials to authenticate. Your data remains within your secure environment, and the agent only accesses what you authorize through your permissions.

**Can the Connector create new records like quotes and invoices?**
Yes, it can create new records including sales orders, quotes, and invoices. You can simply tell your agent what details to include, and it will populate the fields for you.

**How does authentication work with Dynamics 365?**
Dynamics 365 uses OAuth 2.0 via Microsoft Entra ID (Azure AD). You register an app in Azure Portal, obtain a Client ID and Client Secret, configure API permissions for Dynamics CRM, and create an Application User in your Dynamics environment.

**Can I query custom entities and tables in Dataverse?**
Yes. The `query_dataverse` tool queries any entity in Dataverse — standard or custom. Use OData filter expressions, $expand for related entities, and $select for specific columns.

**Does it work with both Dynamics 365 Sales and Business Central?**
Yes. The Connector supports the Dataverse Web API (for Sales, Service, Marketing) and the Business Central API (for financials, inventory, purchasing). Just point to the correct environment URL.

**Can I advance opportunities through pipeline stages?**
Absolutely. The `update_record` tool can update the stage, probability, estimated revenue, and close date of any opportunity. The agent also supports advancing records through Business Process Flows.