mafzaal avatar

D365FO MCP Server

mafzaal/d365fo-client

This is a production-ready MCP server that connects AI assistants directly to Microsoft Dynamics 365 Finance & Operations through its OData endpoints and metadata APIs. It handles authentication via Azure AD service principals and exposes operations for querying entities, managing labels, and executing D365 F&O workflows. You'd reach for this when building AI integrations that need to read or manipulate financial data, inventory records, or other ERP entities in D365 F&O environments. The server includes both stdio transport for local Claude Desktop use and can deploy as an Azure Container App with OAuth or API key authentication for remote access. It's built on FastMCP and ships with a full Python client library underneath for direct programmatic access if you need it.

GitHub stars
32
tools
49
auth
Secret needed
transport
STDIO
env vars
4
last updated
Nov 23, 2025

Tools

49 tools

Public tool metadata for what this MCP can expose to an agent.

d365fo_test_connectionTest connectivity and authentication with performance metrics and error diagnostics

Test connectivity and authentication with performance metrics and error diagnostics

No parameter schema in public metadata yet.

d365fo_get_environment_infoGet comprehensive environment details including versions, configurations, and capabilities

Get comprehensive environment details including versions, configurations, and capabilities

No parameter schema in public metadata yet.

d365fo_query_entitiesSimplified OData querying with 'eq' filtering, wildcard patterns, field selection, and pagination

Simplified OData querying with 'eq' filtering, wildcard patterns, field selection, and pagination

No parameter schema in public metadata yet.

d365fo_get_entity_recordRetrieve specific records by key with expansion options and ETag support

Retrieve specific records by key with expansion options and ETag support

No parameter schema in public metadata yet.

d365fo_create_entity_recordCreate new entity records with validation and business logic execution

Create new entity records with validation and business logic execution

No parameter schema in public metadata yet.

d365fo_update_entity_recordUpdate existing records with partial updates and optimistic concurrency control

Update existing records with partial updates and optimistic concurrency control

No parameter schema in public metadata yet.

d365fo_delete_entity_recordDelete entity records with referential integrity checking and cascading rules

Delete entity records with referential integrity checking and cascading rules

No parameter schema in public metadata yet.

d365fo_call_actionExecute OData actions and functions for complex business operations

Execute OData actions and functions for complex business operations

No parameter schema in public metadata yet.

d365fo_call_json_serviceCall generic JSON service endpoints with parameter support and response handling

Call generic JSON service endpoints with parameter support and response handling

No parameter schema in public metadata yet.

d365fo_search_entitiesSearch entities by pattern with category filtering and full-text search capabilities

Search entities by pattern with category filtering and full-text search capabilities

No parameter schema in public metadata yet.

d365fo_get_entity_schemaGet detailed entity schemas with properties, relationships, and label resolution

Get detailed entity schemas with properties, relationships, and label resolution

No parameter schema in public metadata yet.

d365fo_search_actionsSearch available OData actions with binding type and parameter information

Search available OData actions with binding type and parameter information

No parameter schema in public metadata yet.

d365fo_search_enumerationsSearch system enumerations with keyword-based filtering

Search system enumerations with keyword-based filtering

No parameter schema in public metadata yet.

d365fo_get_enumeration_fieldsGet detailed enumeration member information with multi-language support

Get detailed enumeration member information with multi-language support

No parameter schema in public metadata yet.

d365fo_get_installed_modulesRetrieve information about installed modules and their configurations

Retrieve information about installed modules and their configurations

No parameter schema in public metadata yet.

d365fo_get_labelGet single label text by ID with multi-language support and fallback options

Get single label text by ID with multi-language support and fallback options

No parameter schema in public metadata yet.

d365fo_get_labels_batchGet multiple labels efficiently with batch processing and performance optimization

Get multiple labels efficiently with batch processing and performance optimization

No parameter schema in public metadata yet.

d365fo_list_profilesList all configured D365FO environment profiles with status information

List all configured D365FO environment profiles with status information

No parameter schema in public metadata yet.

d365fo_get_profileGet detailed configuration information for specific profiles

Get detailed configuration information for specific profiles

No parameter schema in public metadata yet.

d365fo_create_profileCreate new environment profiles with comprehensive authentication options

Create new environment profiles with comprehensive authentication options

No parameter schema in public metadata yet.

d365fo_update_profileModify existing profile configurations with partial update support

Modify existing profile configurations with partial update support

No parameter schema in public metadata yet.

d365fo_delete_profileRemove environment profiles with proper cleanup and validation

Remove environment profiles with proper cleanup and validation

No parameter schema in public metadata yet.

d365fo_set_default_profileDesignate a specific profile as the default for operations

Designate a specific profile as the default for operations

No parameter schema in public metadata yet.

d365fo_get_default_profileRetrieve information about the currently configured default profile

Retrieve information about the currently configured default profile

No parameter schema in public metadata yet.

d365fo_validate_profileValidate profile configurations for completeness and security compliance

Validate profile configurations for completeness and security compliance

No parameter schema in public metadata yet.

d365fo_test_profile_connectionTest connectivity and authentication for specific profiles

Test connectivity and authentication for specific profiles

No parameter schema in public metadata yet.

d365fo_clone_profileClone existing profiles with customization options for new environments

Clone existing profiles with customization options for new environments

No parameter schema in public metadata yet.

d365fo_search_profilesSearch profiles by pattern with filtering and sorting capabilities

Search profiles by pattern with filtering and sorting capabilities

No parameter schema in public metadata yet.

d365fo_get_profile_namesGet simplified list of available profile names for quick reference

Get simplified list of available profile names for quick reference

No parameter schema in public metadata yet.

d365fo_import_profilesImport profile configurations from external sources or backups

Import profile configurations from external sources or backups

No parameter schema in public metadata yet.

d365fo_export_profilesExport profile configurations for backup or deployment purposes

Export profile configurations for backup or deployment purposes

No parameter schema in public metadata yet.

d365fo_execute_sql_queryExecute SELECT queries against metadata database with security validation

Execute SELECT queries against metadata database with security validation

No parameter schema in public metadata yet.

d365fo_get_database_schemaGet comprehensive database schema information including relationships

Get comprehensive database schema information including relationships

No parameter schema in public metadata yet.

d365fo_get_table_infoGet detailed information about specific database tables with sample data

Get detailed information about specific database tables with sample data

No parameter schema in public metadata yet.

d365fo_get_database_statisticsGenerate database statistics and analytics for performance monitoring

Generate database statistics and analytics for performance monitoring

No parameter schema in public metadata yet.

d365fo_start_syncInitiate metadata synchronization with various strategies and session tracking

Initiate metadata synchronization with various strategies and session tracking

No parameter schema in public metadata yet.

d365fo_get_sync_progressMonitor detailed progress of sync sessions with time estimates

Monitor detailed progress of sync sessions with time estimates

No parameter schema in public metadata yet.

d365fo_cancel_syncCancel running sync sessions with graceful cleanup

Cancel running sync sessions with graceful cleanup

No parameter schema in public metadata yet.

d365fo_list_sync_sessionsList all active sync sessions with status and progress information

List all active sync sessions with status and progress information

No parameter schema in public metadata yet.

d365fo_get_sync_historyGet history of completed sync sessions with success/failure status and statistics

Get history of completed sync sessions with success/failure status and statistics

No parameter schema in public metadata yet.

d365fo_download_srs_reportDownload SQL Server Reporting Services (SRS) reports with parameter support

Download SQL Server Reporting Services (SRS) reports with parameter support

No parameter schema in public metadata yet.

d365fo_download_sales_confirmationDownload sales confirmation reports in various formats

Download sales confirmation reports in various formats

No parameter schema in public metadata yet.

d365fo_download_purchase_orderDownload purchase order documents with formatting options

Download purchase order documents with formatting options

No parameter schema in public metadata yet.

d365fo_download_customer_invoiceDownload customer invoice reports with customization

Download customer invoice reports with customization

No parameter schema in public metadata yet.

d365fo_download_free_text_invoiceDownload free text invoice documents

Download free text invoice documents

No parameter schema in public metadata yet.

d365fo_download_debit_credit_noteDownload debit and credit note reports

Download debit and credit note reports

No parameter schema in public metadata yet.

d365fo_get_server_performanceGet server performance metrics and statistics

Get server performance metrics and statistics

No parameter schema in public metadata yet.

d365fo_get_server_configGet server configuration information and system settings

Get server configuration information and system settings

No parameter schema in public metadata yet.

d365fo_reset_performance_statsReset performance statistics and counters for fresh monitoring

Reset performance statistics and counters for fresh monitoring

No parameter schema in public metadata yet.

Sponsors

Configuration

D365FO_CLIENT_ID*

Your D365FO Client ID

D365FO_CLIENT_SECRET*secret

Your D365FO Client Secret

D365FO_TENANT_ID*

Your D365FO Tenant ID

D365FO_BASE_URL

Your D365FO Base URL

Readme

Dynamics 365 Finance & Operations MCP Server

D365FO MCP Server Logo

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.

GitHub watchers GitHub forks GitHub stars

🚀 One-Click Installation for VS Code:


View the full README on GitHub

Details

Repository
github.com/mafzaal/d365fo-client
Package
d365fo-client
Transport
STDIO
Auth
Required
Registry
MCP registry, active