mcp-d365-connector

MCP Server for Dynamics 365 Finance & Operations

This project demonstrates how to build a custom Model Context Protocol (MCP) server that integrates Azure OpenAI with Dynamics 365 Finance & Operations (D365 F&O). The server leverages natural language input to generate valid OData queries, fetch data from D365, and process results using a Large Language Model (LLM).

---

🔧 Architecture Overview

![Architecture Diagram]

Components:

• Client (User): Sends natural language queries.
• MCP Server (FastAPI): Parses the input, uses Azure OpenAI to generate an OData query.
• D365 F&O: Returns matching business data using OData.
• Azure OpenAI: Used twice — once to generate the OData query, and again to post-process the response.
• Output: Cleaned and focused data returned to the calling system.

---

📦 Technology Stack

• Python 3.10+
• FastAPI
• Azure OpenAI (openai Python SDK)
• Requests (for HTTP calls)
• OAuth2 for secure access to D365 F&O

---

🛠 SDKs Used

• OpenAI SDK – For communicating with Azure OpenAI deployments.
• Requests – For REST API calls to D365 and token endpoints.
• Pydantic + FastAPI – For building the RESTful MCP interface.

---

🌐 Public MCP Servers (Non-Microsoft)

While this implementation is custom-built for D365 F&O, several public MCP servers exist in the ecosystem — especially for open-source or OSS-focused LLM projects:

• LangChain MCP Examples
• Haystack LLM Agent Servers
• DSPy Agent Context Servers
• AutoGen Frameworks with context protocol layers

These are usually used for document retrieval, QA systems, and autonomous agents.

---

📘 Example Scenario

"Show me top 10 customers from California with credit limit over $10,000"

How It Works:

1. User sends a natural language request.
2. MCP Server uses LLM to generate this OData query:

CustomersV3?$filter=State eq 'CA' and CreditLimit gt 10000&$top=10

3. MCP Server calls the D365 F&O endpoint with this query.
4. Response is then passed back to the LLM for post-processing to extract just the Customer Name and ID.
5. Final cleaned output is returned to the caller.

---

💡 LLM Prompting Strategy

Two distinct prompts are used:

• Prompt #1 (Generate OData Query) – Guides the LLM to only return a valid OData URL fragment.
• Prompt #2 (Refine Response) – Extracts only CustomerAccount and CustomerName from the raw OData response.

---

---

📂 Getting Started

1. Clone the repo.
2. Copy .env.sample to .env and fill in your keys.
3. Run the server:

uvicorn main:app --reload

---

🔐 Security

Make sure .env is added to .gitignore. Do not commit your credentials or secrets.

---

Testing

Use CURL or tools like PostMan to send API call:
Invoke-RestMethod -Uri http://127.0.0.1:8000/api/mcp -Method POST
-Body '{"name":"Test","context":"Get Customers and first only"}' `
-ContentType "application/json"

📄 License

MIT License