What can you do with this server?

The PowerPlatform MCP server provides intelligent, context-aware access to Microsoft PowerPlatform/Dataverse data models and records, enabling AI-assisted exploration, querying, and understanding of your environment. Metadata Exploration: * Retrieve comprehensive entity metadata including structure, attributes, display names, schema names, and descriptions * Access detailed information about specific entity fields including data types, formats, requirements, and usage notes * Explore and visualize one-to-many and many-to-many relationships between entities * Retrieve definitions for global option sets used across your environment Data Access: * Fetch individual records by entity name and GUID * Query multiple records using advanced OData filter expressions with support for filtering, sorting, and pagination AI-Assisted Context: * ENTITY_OVERVIEW: Get comprehensive entity summaries with key attributes and relationship counts * ATTRIBUTE_DETAILS: Access formatted, detailed information about specific fields * QUERY_TEMPLATE: Generate OData query templates with example filters and common patterns * RELATIONSHIP_MAP: Visualize formatted relationship maps showing entity connections Use Cases: * Build and validate OData queries for PowerPlatform data * Understand existing data models and entity relationships * Design new solutions with awareness of existing schema * Get AI-powered assistance with query construction, field investigation, and complex data modeling decisions * Generate documentation about your PowerPlatform environment

Which integrations are available for this server?

Provides GitHub Copilot access to PowerPlatform/Dataverse entities and records, supporting entity exploration, intelligent OData filtering, and AI-assisted query building through a Model Context Protocol server.

How do I use PowerPlatform MCP?

1. Click on "Install Server". 2. Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state. 3. In the chat, type @ followed by the MCP server name and your instructions, e.g., "@PowerPlatform MCP show me the account entity overview" That's it! The server will respond to your query, and you can continue using it as needed. Here is a step-by-step guide with screenshots.

en es ja ko zh

PowerPlatform MCP

by michsob

Overview Schema Related Servers Score Discussions

TypeScript

Hybrid

PowerPlatform MCP / CLI

A Model Context Protocol (MCP) server and standalone CLI for querying PowerPlatform / Dataverse environments. Supports multiple environments, entity metadata, records, plugins, flows, solutions, workflows, business rules, security roles, and more.

Why MCP + CLI?

MCP integrates directly with AI clients (Claude, Cursor, GitHub Copilot) for interactive, conversational exploration of your environments.

CLI writes results to a file system cache instead of returning them inline. MCP tool responses are bound by the AI client's context window, which can truncate or degrade results when querying environments with hundreds of entities, flows, or plugin steps. The CLI avoids this limitation by persisting full results to disk, making them available for follow-up analysis without context pressure. Both interfaces share the same tools and capabilities.

Installation

Requires Node.js 22+ (< 25).

MCP Server

npm install -g powerplatform-mcp
# or
npx powerplatform-mcp

CLI

npm install -g powerplatform-cli
# or
npx powerplatform-cli

Docker

# MCP Server
docker pull ghcr.io/michsob/powerplatform-mcp
docker run --env-file .env ghcr.io/michsob/powerplatform-mcp

# CLI
docker pull ghcr.io/michsob/powerplatform-cli
docker run --env-file .env ghcr.io/michsob/powerplatform-cli entity-attributes account

Configuration

The tool supports multiple environments. Define them via environment variables:

POWERPLATFORM_ENVIRONMENTS=DEV,UAT,PROD

# For each environment, set:
POWERPLATFORM_DEV_URL=https://dev-org.crm.dynamics.com
POWERPLATFORM_DEV_CLIENT_ID=your-client-id
POWERPLATFORM_DEV_CLIENT_SECRET=your-client-secret
POWERPLATFORM_DEV_TENANT_ID=your-tenant-id

POWERPLATFORM_UAT_URL=https://uat-org.crm.dynamics.com
POWERPLATFORM_UAT_CLIENT_ID=...
POWERPLATFORM_UAT_CLIENT_SECRET=...
POWERPLATFORM_UAT_TENANT_ID=...

For local development, copy .env.example to .env and fill in your credentials.

MCP Server

The MCP server is designed for AI-powered clients (Claude, Cursor, GitHub Copilot).

Available MCP Tools (38)

All tools accept an optional environment parameter to target a specific environment (defaults to the first configured).

Entity

Tool	Description	Required Params
`get-entity-metadata`	Get entity metadata	`entityName`
`get-entity-attributes`	List all attributes/fields	`entityName`
`get-entity-attribute`	Get a specific attribute	`entityName`, `attributeName`
`get-entity-relationships`	Get 1:N and N:N relationships	`entityName`

Records

Tool	Description	Required Params	Optional
`get-record`	Get a record by ID	`entityNamePlural`, `recordId`
`query-records`	OData query	`entityNamePlural`, `filter`	`maxRecords` (default 50)

Plugins

Tool	Description	Required Params	Optional
`get-plugin-assemblies`	List plugin assemblies		`includeManaged`, `maxRecords`
`get-plugin-assembly-complete`	Assembly with types, steps, images	`assemblyName`	`includeDisabled`
`get-entity-plugin-pipeline`	Plugins executing on an entity	`entityName`	`messageFilter`, `includeDisabled`
`get-plugin-trace-logs`	Plugin trace logs		`entityName`, `messageName`, `correlationId`, `pluginStepId`, `exceptionOnly`, `hoursBack`, `maxRecords`
`get-all-plugin-steps`	All SDK message processing steps		`includeDisabled`, `maxRecords`

Flows (Power Automate)

Tool	Description	Required Params	Optional
`get-flows`	List cloud flows (smart filtering)		`activeOnly`, `maxRecords`, `nameContains`, `excludeSystem`, `excludeCustomerInsights`, `excludeCopilotSales`
`search-workflows`	Search workflows and flows		`name`, `primaryEntity`, `description`, `category`, `statecode`, `maxResults`
`get-flow-definition`	Full definition or parsed summary	`flowId`	`summary`
`get-flow-runs`	Flow run history	`flowId`	`status`, `startedAfter`, `startedBefore`, `maxRecords`
`get-flow-run-details`	Run details with action-level errors	`flowId`, `runId`
`cancel-flow-run`	Cancel a running/waiting run	`flowId`, `runId`
`resubmit-flow-run`	Retry a failed run	`flowId`, `runId`
`scan-flow-health`	Batch health scan (success rates)		`daysBack`, `maxRunsPerFlow`, `maxFlows`, `activeOnly`
`get-flow-inventory`	Lightweight flow inventory		`maxRecords`

Solutions

Tool	Description	Required Params	Optional
`get-publishers`	List non-readonly publishers
`get-solutions`	List visible solutions
`get-solution`	Get solution by unique name	`uniqueName`
`get-solution-components`	List components in a solution	`solutionUniqueName`
`export-solution`	Export solution (base64)	`solutionName`	`managed`

Workflows (Classic)

Tool	Description	Required Params	Optional
`get-workflows`	List classic workflows		`activeOnly`, `maxRecords`
`get-workflow-definition`	XAML definition or summary	`workflowId`	`summary`
`get-ootb-workflows`	Background, BPFs, actions, on-demand		`maxRecords`, `categories`

Business Rules

Tool	Description	Required Params	Optional
`get-business-rules`	List business rules		`activeOnly`, `maxRecords`
`get-business-rule`	Business rule with XAML	`workflowId`

Option Sets

Tool	Description	Required Params
`get-global-option-set`	Get a global option set definition	`optionSetName`

Configuration

Tool	Description	Optional
`get-connection-references`	Connection references	`maxRecords`, `managedOnly`, `hasConnection`, `inactive`
`get-environment-variables`	Environment variable definitions + values	`maxRecords`, `managedOnly`

Security Roles

Tool	Description	Required Params	Optional
`get-security-roles`	List customizable security roles		`solutionUniqueName`, `excludeSystemRoles`, `includePrivileges`, `maxRecords`
`get-security-role-privileges`	Privileges for a role	`roleId`	`entityFilter`, `accessRightFilter`

Dependencies

Tool	Description	Required Params
`check-component-dependencies`	Dependencies blocking deletion	`componentId`, `componentType`
`check-delete-eligibility`	Check if a component can be deleted	`componentId`, `componentType`

Service Endpoints

Tool	Description	Optional
`get-service-endpoints`	Service Bus, webhooks, Event Hub, Event Grid	`maxRecords`

MCP Prompts

Prompt	Description	Required Args
`entity-overview`	Entity overview with key attributes and relationships	`entityName`
`attribute-details`	Detailed attribute info (type, format, requirements)	`entityName`, `attributeName`
`query-template`	OData query template with example filters	`entityName`
`relationship-map`	Complete 1:N and N:N relationship map	`entityName`

CLI

Same tools as the MCP server, but results are cached to the file system for full-fidelity output on large data sets.

Global Option

--env <name> — target environment (defaults to first configured).

Commands

Entity

entity-metadata <entityName>
entity-attributes <entityName>
entity-attribute <entityName> <attributeName>
entity-relationships <entityName>

Records

record <entityNamePlural> <recordId>
query-records <entityNamePlural> <filter>  [--max <n>]

Plugins

plugin-assemblies                          [--include-managed] [--max <n>]
plugin-assembly <assemblyName>
entity-pipeline <entityName>               [--message <msg>] [--include-disabled]

Flows

flows                                      [--active] [--name <contains>] [--max <n>]
flow-definition <flowId>                   [--summary]
search-workflows                           (interactive filters)

Solutions

solutions
solution <uniqueName>
solution-components <uniqueName>

Workflows

workflows                                  [--active] [--max <n>]
workflow-definition <workflowId>           [--summary]
ootb-workflows                             [--categories <0,1,2,3,4>]

Business Rules

business-rules                             [--active] [--max <n>]
business-rule <workflowId>

Option Sets

optionset <optionSetName>

Dependencies

check-dependencies <componentId> <componentType>

Configuration

connection-references                      [--managed-only] [--has-connection] [--no-connection] [--inactive] [--max-records <n>]
environment-variables                      [--managed-only] [--max-records <n>]

Security Roles

security-roles                             [--solution <name>] [--include-system] [--include-privileges] [--max-records <n>]
security-role-privileges <roleId>          [--entity <name>] [--access-right <type>]

Service Endpoints

service-endpoints                          [--max <n>]

Development

git clone https://github.com/michsob/powerplatform-mcp.git
cd powerplatform-mcp
npm install
cp .env.example .env   # fill in credentials
npm run build
npm run inspector      # test with MCP Inspector

Releasing

To publish a new version:

Update version in package.json
Commit the change to main
Create and push a version tag:
```
git tag v1.0.2
git push origin v1.0.2
```

GitHub Actions will automatically publish:

Package	npm	GitHub Packages	Docker (GHCR)
MCP Server	`npm i powerplatform-mcp`	`npm i @michsob/powerplatform-mcp`	`ghcr.io/michsob/powerplatform-mcp`
CLI	`npm i powerplatform-cli`	`npm i @michsob/powerplatform-cli`	`ghcr.io/michsob/powerplatform-cli`

npm publishing uses Trusted Publishing (OIDC) — no tokens or secrets needed. GitHub Packages and GHCR use the built-in GITHUB_TOKEN automatically.

License

MIT

Install Server

security – no known vulnerabilities

license - permissive license

quality - not tested

How are these scores calculated?

Resources

Need Help?

Reddit Discussion

Related Servers

Tools

View all tools

Appeared in Searches

Latest Blog Posts

Tool Definition Quality Score (TDQS)
By punkpeye on April 3, 2026.
mcp
The Hackers Who Tracked My Sleep Cycle
By punkpeye on March 26, 2026.
security
Open Source Has a Bot Problem
By punkpeye on March 19, 2026.
open source

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/michsob/powerplatform-mcp'

If you have feedback or need assistance with the MCP directory API, please join our Discord server