PowerPlatform MCP Server
A Model Context Protocol (MCP) server that provides intelligent access to PowerPlatform/Dataverse entities and records. This tool offers context-aware assistance, entity exploration and metadata access.
Key features:
- Rich entity metadata exploration with formatted, context-aware prompts
- Advanced OData query support with intelligent filtering
- Comprehensive relationship mapping and visualization
- AI-assisted query building and data modeling through AI agent
- Full access to entity attributes, relationships, and global option sets
Installation
You can install and run this tool in two ways:
Option 1: Install globally
Then run it:
Option 2: Run directly with npx
Run without installing:
Configuration
Before running, set the following environment variables:
Usage
This is an MCP server designed to work with MCP-compatible clients like Cursor, Claude App and GitHub Copilot. Once running, it will expose tools for retrieving PowerPlatform entity metadata and records.
Available Tools
get-entity-metadata: Get metadata about a PowerPlatform entity
get-entity-attributes: Get attributes/fields of a PowerPlatform entity
get-entity-attribute: Get a specific attribute/field of a PowerPlatform entity
get-entity-relationships: Get relationships for a PowerPlatform entity
get-global-option-set: Get a global option set definition
get-record: Get a specific record by entity name and ID
query-records: Query records using an OData filter expression
use-powerplatform-prompt: Use pre-defined prompt templates for PowerPlatform entities
MCP Prompts
The server includes a prompts feature that provides formatted, context-rich information about PowerPlatform entities.
Available Prompt Types
The
use-powerplatform-prompt tool supports the following prompt types:- ENTITY_OVERVIEW: Comprehensive overview of an entity
- ATTRIBUTE_DETAILS: Detailed information about a specific entity attribute
- QUERY_TEMPLATE: OData query template for an entity with example filters
- RELATIONSHIP_MAP: Visual map of entity relationships
Examples
Entity Overview Prompt
Output:
Attribute Details Prompt
Output:
Query Template Prompt
Output:
Common Filter Examples
- Equals:
name eq 'Contoso'
- Contains:
contains(name, 'Contoso')
- Greater than date:
createdon gt 2023-01-01T00:00:00Z
- Multiple conditions:
name eq 'Contoso' and statecode eq 0
Output:
Prompt Examples
Here are some examples of how you can interact with assistant using the PowerPlatform MCP prompts:
1. Entity Understanding
You can ask assistant about entities in natural language:
2. Building Queries
You can ask for help constructing queries:
3. Understanding Relationships
You can explore entity relationships naturally:
4. Field/Attribute Investigation
You can ask about specific fields:
5. Complex Data Modeling
You can get help with data modeling decisions:
6. Debugging Assistance
You can get help troubleshooting:
These examples show how AI assistant can leverage the MCP prompts to provide context-aware, accurate assistance for PowerPlatform development tasks. The AI understands your environment's specific configuration and can help with both simple queries and complex architectural decisions.
License
MIT
PowerPlatform MCP Server
A Model Context Protocol (MCP) server that provides intelligent access to PowerPlatform/Dataverse entities and records. This tool offers context-aware assistance, entity exploration and metadata access.
Key features:
- Rich entity metadata exploration with formatted, context-aware prompts
- Advanced OData query support with intelligent filtering
- Comprehensive relationship mapping and visualization
- AI-assisted query building and data modeling through AI agent
- Full access to entity attributes, relationships, and global option sets
Installation
You can install and run this tool in two ways:
Option 1: Install globally
Then run it:
Option 2: Run directly with npx
Run without installing:
Configuration
Before running, set the following environment variables:
Usage
This is an MCP server designed to work with MCP-compatible clients like Cursor, Claude App and GitHub Copilot. Once running, it will expose tools for retrieving PowerPlatform entity metadata and records.
Available Tools
get-entity-metadata: Get metadata about a PowerPlatform entity
get-entity-attributes: Get attributes/fields of a PowerPlatform entity
get-entity-attribute: Get a specific attribute/field of a PowerPlatform entity
get-entity-relationships: Get relationships for a PowerPlatform entity
get-global-option-set: Get a global option set definition
get-record: Get a specific record by entity name and ID
query-records: Query records using an OData filter expression
use-powerplatform-prompt: Use pre-defined prompt templates for PowerPlatform entities
MCP Prompts
The server includes a prompts feature that provides formatted, context-rich information about PowerPlatform entities.
Available Prompt Types
The
use-powerplatform-prompt tool supports the following prompt types:- ENTITY_OVERVIEW: Comprehensive overview of an entity
- ATTRIBUTE_DETAILS: Detailed information about a specific entity attribute
- QUERY_TEMPLATE: OData query template for an entity with example filters
- RELATIONSHIP_MAP: Visual map of entity relationships
Examples
Entity Overview Prompt
Output:
Attribute Details Prompt
Output:
Query Template Prompt
Output:
Common Filter Examples
- Equals:
name eq 'Contoso'
- Contains:
contains(name, 'Contoso')
- Greater than date:
createdon gt 2023-01-01T00:00:00Z
- Multiple conditions:
name eq 'Contoso' and statecode eq 0
Output:
Prompt Examples
Here are some examples of how you can interact with assistant using the PowerPlatform MCP prompts:
1. Entity Understanding
You can ask assistant about entities in natural language:
2. Building Queries
You can ask for help constructing queries:
3. Understanding Relationships
You can explore entity relationships naturally:
4. Field/Attribute Investigation
You can ask about specific fields:
5. Complex Data Modeling
You can get help with data modeling decisions:
6. Debugging Assistance
You can get help troubleshooting:
These examples show how AI assistant can leverage the MCP prompts to provide context-aware, accurate assistance for PowerPlatform development tasks. The AI understands your environment's specific configuration and can help with both simple queries and complex architectural decisions.
License
MIT