Integrations
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.
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 entityget-entity-attributes
: Get attributes/fields of a PowerPlatform entityget-entity-attribute
: Get a specific attribute/field of a PowerPlatform entityget-entity-relationships
: Get relationships for a PowerPlatform entityget-global-option-set
: Get a global option set definitionget-record
: Get a specific record by entity name and IDquery-records
: Query records using an OData filter expressionuse-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
This server cannot be installed
hybrid server
The server is able to function both locally and remotely, depending on the configuration or use case.
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.
Related Resources
Related MCP Servers
- AsecurityAlicenseAqualityA Model Context Protocol (MCP) server implementation that provides database interaction and business intelligence capabilities through SQLite. This server enables running SQL queries, analyzing business data, and automatically generating business insight memos.Last updated -644,650JavaScriptMIT License
- -security-license-qualityA specialized server that helps users create new Model Context Protocol (MCP) servers by providing tools and templates for scaffolding projects with various capabilities.Last updated -1TypeScript
- -security-license-qualityA Model Context Protocol (MCP) server that interacts with system APIs, allowing users to check connections, search employees, register breakfast, and update chemical information by shifts.Last updated -2
- AsecurityAlicenseAqualityModel Context Protocol (MCP) server that provides weather forecast, warnings, water level associated with flood, and earthquake reports from Malaysia Government's Open API.Last updated -4PythonMIT License