Enables comprehensive schema and solution management for Microsoft Dataverse
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 (6)
create_tableCreate a custom table in a specific Dataverse solutioncreate_columnAdd a new column to an existing Dataverse tablecreate_relationshipCreate One-to-Many or Many-to-Many relationships between tablesexport_schemaExport solution schema to JSON for visualizationgenerate_mermaid_erdConvert exported schema JSON into a Mermaid ERD diagramgenerate_webapi_callGenerate cURL and JavaScript code for Dataverse operationsEnvironment Variables
DATAVERSE_URLrequiredThe environment URL (e.g., org.crm.dynamics.com)AZURE_CLIENT_IDrequiredApplication (client) ID from Azure App RegistrationAZURE_CLIENT_SECRETrequiredClient secret from Azure App RegistrationAZURE_TENANT_IDrequiredDirectory (tenant) ID from AzureConfiguration
{"mcpServers":{"dataverse":{"command":"npx","args":["-y","@wizspdemo/dataverse-mcp3"],"env":{"DATAVERSE_URL":"your-org.crm.dynamics.com","AZURE_CLIENT_ID":"your-client-id","AZURE_CLIENT_SECRET":"your-client-secret","AZURE_TENANT_ID":"your-tenant-id"}}}}