Skip to main content
Glama

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] alt text

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.


Related MCP server: Dynamics 365 Finance & Operations MCP Server

πŸ“¦ 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
  1. MCP Server calls the D365 F&O endpoint with this query.

  2. Response is then passed back to the LLM for post-processing to extract just the Customer Name and ID.

  3. 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

Tool Schema Changelog

Recent tool additions, removals, and schema changes observed during successful MCP inspections.

Loading tool schema changelog…

    Related MCP Connectors

    Related MCP Servers

    • A
      license
      Not graded
      quality
      D
      maintenance
      Enables AI assistants to explore metadata, query data, and perform write operations across multiple Microsoft Dynamics 365 Finance & Operations environments. It features specialized tools for OData execution and data analysis with built-in read-only safety for production environments.
      38 npm
      10
      MIT
    • F
      license
      Not graded
      quality
      C
      maintenance
      Enables AI assistants to search and analyze Microsoft Dynamics 365 Finance & Operations artifacts, read local source code, and generate context-aware solutions through natural language.
      12
      -
    • A
      license
      Not graded
      quality
      D
      maintenance
      Enables natural language interaction with Microsoft Dynamics 365 Finance & Operations, including entity discovery, CRUD operations, and a learning system that improves over time.
      MIT