powerplatform

PowerPlatform MCP Server provides intelligent access to PowerPlatform/Dataverse entities and records. It exposes tools to fetch entity metadata, attributes, relationships, and records, and supports AI-assisted prompt templates to simplify querying and modeling. You can use tools like get-entity-metadata, get-entity-attributes, get-record, query-records, and use-powerplatform-prompt to generate structured prompts for entity overviews, attribute details, query templates, and relationship maps. This enables MCP clients (such as Cursor, Claude App, or GitHub Copilot) to interact with Dataverse data in a context-aware way, building OData filters and navigating complex entity relationships with guided prompts.

Prerequisites:

• Node.js and npm installed on your system
• Access to a Power Platform/Dataverse environment and credentials

Option A: Install globally via npm and run

npm install -g powerplatform-mcp

Then start the server:

powerplatform-mcp

Option B: Run directly with npx (no installation required)

npx powerplatform-mcp

Configuration details:

• Set environment variables before running the server (POWERPLATFORM_URL, POWERPLATFORM_CLIENT_ID, POWERPLATFORM_CLIENT_SECRET, POWERPLATFORM_TENANT_ID).
• You can clone the repo, install dependencies locally, and run from source if you prefer local development.

Development workflow (optional):

git clone https://github.com/michsob/powerplatform-mcp.git
cd powerplatform-mcp
npm install
cp .env.example .env

Environment variables are required to authenticate to Dataverse. Ensure your Azure AD app has the correct permissions to access Dataverse data. If you encounter connectivity issues, verify that your POWERPLATFORM_URL is reachable and that your client credentials are valid. When using npx, the command will fetch the latest package version from npm; for production use, consider installing globally or packaging a Docker image if preferred. The MCP supports prompts for entity overviews, attribute details, query templates, and relationship maps, which can be invoked through use-powerplatform-prompt with the appropriate promptType and parameters.