PowerPlatform MCP Server

Name: PowerPlatform MCP Server
Author: RuniThomsen

@RuniThomsen

代码仓库

关于 PowerPlatform MCP Server

MCP Server for Powerplatform dataverse.

基本信息

分类

其他

许可证

MIT

运行时

node

传输方式

stdio

发布者

RuniThomsen

配置

使用下面的配置,将此服务器添加到你的 MCP 客户端。

{
  "mcpServers": {
    "powerplatform-mcp-runithomsen": {
      "command": "npx",
      "args": [
        "powerplatform-mcp"
      ]
    }
  }
}

工具

Get metadata about a PowerPlatform entity

Get attributes/fields of a PowerPlatform entity

Get a specific attribute/field of a PowerPlatform entity

Get relationships for a PowerPlatform entity

Get a global option set definition

Get a specific record by entity name and ID

Query records using an OData filter expression

Use pre-defined prompt templates for PowerPlatform entities

概览

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.