mafzaal/d365fo-client

**Production-ready Model Context Protocol (MCP) server** that exposes the full capabilities of Microsoft Dynamics 365 Finance & Operations (D365 F&O) to AI assistants and other MCP-compatible tools. This enables sophisticated Dynamics 365 integration workflows through standardized protocol interactions.
**🚀 One-Click Installation for VS Code:**
**🐳 Docker Installation for VS Code:**
-2496ED?style=flat-square&logo=docker&logoColor=white)
-24bfa5?style=flat-square&logo=docker&logoColor=white)
**☁️ Deploy to Azure Container Apps:**
Deploy the MCP server as a secure, internet-accessible HTTP endpoint with OAuth or API Key authentication. Perfect for web integrations and remote AI assistant access.
**Option 1: Using Bash Script (Recommended)**
**Option 2: Using ARM Template**
1. Download azure-deploy.json
2. Go to Azure Portal → Deploy a custom template
3. Click "Build your own template in the editor"
4. Paste the contents of azure-deploy.json
5. Fill in the parameters and deploy
**Also includes a comprehensive Python client library** for Microsoft Dynamics 365 Finance & Operations with OData endpoints, metadata operations, label management, and CLI tools.
MCP Server Overview
The d365fo-client includes a **production-ready Model Context Protocol (MCP) server** (d365fo-fastmcp-server) built on the FastMCP framework that exposes the full capabilities of D365 Finance & Operations to AI assistants and other MCP-compatible tools.
The server provides multi-transport support (stdio, HTTP, SSE) with enhanced performance and deployment flexibility.
Key Features
- **49 comprehensive tools** covering all major D365 F&O operations across 9 functional categories
- **12 resource types** with comprehensive metadata exposure and discovery capabilities
- **2 prompt templates** for advanced workflow assistance
- **Multi-transport support** (FastMCP): stdio, HTTP, Server-Sent Events (SSE)
- **Production-ready** implementation with proper error handling, authentication, and security validation
- **Enhanced performance** (FastMCP): 40% faster startup, 15% lower memory usage
- **Advanced profile management** supporting multiple environments with secure credential storage
- **Database analysis capabilities** with secure SQL querying and metadata insights
- **Session-based synchronization** with detailed progress tracking and multiple sync strategies
- **Multi-language support** with label resolution and localization capabilities
- **Enterprise security** with Azure AD integration, Key Vault support, and audit logging
New in v0.3.0
- **🔧 Pydantic Settings Model**: Type-safe environment variable management with validation for 35+ configuration options
- **📂 Custom Log File Support**: D365FO_LOG_FILE environment variable for flexible log file paths
- **🔄 Legacy Config Migration**: Automatic detection and migration of legacy configuration files
- **🌐 Environment Variable Standardization**: All MCP HTTP variables now use D365FO_ prefix for consistency
- **⚡ Enhanced FastMCP Server**: Improved startup configuration, error handling, and graceful shutdown
- **🔀 MCP Return Type Standardization**: All MCP tools now return dictionaries instead of JSON strings for better type safety
- **🛠️ Enhanced Configuration**: Support for .env files and comprehensive environment variable documentation
Quick Start
Installation and Setup
FastMCP Server (Recommended)
The modern FastMCP implementation provides enhanced performance and multiple transport options:
**Key Benefits:**
- **Optimized performance** with FastMCP framework
- **Efficient resource usage** through optimized architecture
- **Multi-transport support**: stdio, HTTP, Server-Sent Events (SSE)
- **Enhanced error handling** with better async/await support
- **Production ready** with web transports for API integration
Integration with AI Assistants
VS Code Integration (Recommended)
**FastMCP Server with Default Credentials:**
Add to your VS Code mcp.json for GitHub Copilot with MCP:
**Option 2: Explicit Credentials**
For environments requiring service principal authentication:
**Option 3: Docker Integration**
For containerized environments and enhanced isolation:
**Benefits of Docker approach:**
- Complete environment isolation and reproducibility
- No local Python installation required
- Consistent runtime environment across different systems
- Automatic dependency management with pre-built image
- Enhanced security through containerization
- Persistent data storage via Docker volume (d365fo-mcp)