Enables comprehensive management of Microsoft Dataverse environments
Dataverse MCP Server
A Model Context Protocol (MCP) server for Microsoft Dataverse that enables schema operations including creating and updating tables, columns, relationships, and option sets using the Dataverse Web API.
š Key Features
ā Manage Tables & Columns - Create, update, delete, and list custom tables with all column types (String, Integer, Boolean, DateTime, Picklist, Lookup, AutoNumber, etc.)
ā Manage Relationships - Create One-to-Many and Many-to-Many relationships between entities with proper cascade behaviors
ā Manage Option Sets - Create and manage global option sets with custom options, colors, and values
ā Solution-Based Architecture - Enterprise-grade solution management with persistent context and automatic customization prefixes
ā Security & Access Control - Complete security role management, team operations, and business unit hierarchy management
ā WebAPI Call Generator - Generate ready-to-use HTTP requests, cURL commands, and JavaScript code for any Dataverse operation
ā
PowerPages WebAPI Generator - Generate PowerPages-specific WebAPI calls using the /_api/[logicalEntityName] format with React examples
ā PowerPages Configuration Management - Manage table permissions and WebAPI site settings for PowerPages Code Sites with YAML file automation
ā Schema Export & Visualization - Export complete solution schemas to JSON with advanced filtering, then generate professional Mermaid ERD diagrams with relationship visualization
ā Mermaid Diagram Generation - Convert exported schemas into professional Entity Relationship Diagrams with enhanced column markers, lookup target display, and unlimited table support
ā AutoNumber Column Management - Create and manage AutoNumber columns with customizable format patterns for automatic serial numbers, reference codes, and unique identifiers
ā Professional Integration - OAuth2 authentication, comprehensive error handling, and enterprise-ready deployment
ā Production Ready - Comprehensive testing completed with 7 critical bugs found and fixed, 100% tool coverage achieved
Tools (5)
create_tableCreate a custom table in Dataverse with specified schemacreate_columnAdd a new column to an existing tablecreate_relationshipCreate One-to-Many or Many-to-Many relationships between tablesexport_schemaExport solution schema to JSON for visualizationgenerate_mermaid_erdConvert exported schema into a Mermaid ERD diagramEnvironment Variables
DATAVERSE_URLrequiredThe environment URL (e.g., https://org.crm.dynamics.com)AZURE_TENANT_IDrequiredAzure Active Directory Tenant IDAZURE_CLIENT_IDrequiredApplication (client) ID from Azure App RegistrationAZURE_CLIENT_SECRETrequiredClient secret from Azure App RegistrationConfiguration
{
"mcpServers": {
"dataverse-mcp": {
"command": "npx",
"args": ["-y", "@wizspdemo/dataverse-mcp2"],
"env": {
"DATAVERSE_URL": "https://your-org.crm.dynamics.com",
"AZURE_TENANT_ID": "your-tenant-id",
"AZURE_CLIENT_ID": "your-client-id",
"AZURE_CLIENT_SECRET": "your-client-secret"
}
}
}
}