Overview
What is PowerPlatform MCP Server?
A Model Context Protocol (MCP) server that provides intelligent access to Power Platform/Dataverse entities and records. It offers context-aware assistance, entity exploration, and metadata access for developers working with Power Platform.
How to use PowerPlatform MCP Server?
Install globally with npm install -g powerplatform-mcp or run directly with npx powerplatform-mcp. Set environment variables POWERPLATFORM_URL, POWERPLATFORM_CLIENT_ID, and POWERPLATFORM_TENANT_ID. On first run, follow the device code flow to authenticate interactively. The server exposes MCP tools for use with compatible clients like Cursor, Claude App, and GitHub Copilot.
Key features of PowerPlatform MCP Server
- Rich entity metadata exploration with formatted prompts
- Advanced OData query support with intelligent filtering
- Comprehensive relationship mapping and visualization
- AI-assisted query building and data modeling
- Full access to attributes, relationships, and global option sets
- Interactive authentication via device code flow
Use cases of PowerPlatform MCP Server
- Explore entity metadata and attribute details in natural language
- Build and debug OData queries with AI assistance
- Understand entity relationships for data modeling
- Investigate specific fields for troubleshooting
- Design solutions by combining entity overviews and relationship maps
FAQ from PowerPlatform MCP Server
How do I authenticate with PowerPlatform MCP Server?
The server uses interactive device code flow. On first run, it displays a URL and code. Open the URL in a browser, sign in with Power Platform credentials, and enter the code. The token is cached locally for future use.
Can I use client secret authentication?
No, client secrets are deprecated. The server now exclusively uses interactive authentication, which supports MFA and is more secure.
What environment variables are required?
POWERPLATFORM_URL (your Dataverse environment URL), POWERPLATFORM_CLIENT_ID (Azure app client ID), and POWERPLATFORM_TENANT_ID (Azure tenant ID). An optional POWERPLATFORM_TOKEN_CACHE_PATH can override the default token cache location.
How do I install PowerPlatform MCP Server?
Install globally via npm: npm install -g powerplatform-mcp, then run powerplatform-mcp. Alternatively, run directly without installation using npx powerplatform-mcp.
What tools does PowerPlatform MCP Server provide?
Tools include get-entity-metadata, get-entity-attributes, get-entity-attribute, get-entity-relationships, get-global-option-set, get-record, query-records, and use-powerplatform-prompt for pre-defined prompt templates.
