Skillshub power-platform-mcp-connector-suite
Generate complete Power Platform custom connector with MCP integration for Copilot Studio - includes schema generation, troubleshooting, and validation
git clone https://github.com/ComeOnOliver/skillshub
T=$(mktemp -d) && git clone --depth=1 https://github.com/ComeOnOliver/skillshub "$T" && mkdir -p ~/.claude/skills && cp -r "$T/skills/github/awesome-copilot/power-platform-mcp-connector-suite" ~/.claude/skills/comeonoliver-skillshub-power-platform-mcp-connector-suite && rm -rf "$T"
skills/github/awesome-copilot/power-platform-mcp-connector-suite/SKILL.mdPower Platform MCP Connector Suite
Generate comprehensive Power Platform custom connector implementations with Model Context Protocol integration for Microsoft Copilot Studio.
MCP Capabilities in Copilot Studio
Currently Supported:
- ✅ Tools: Functions that the LLM can call (with user approval)
- ✅ Resources: File-like data that agents can read (must be tool outputs)
Not Yet Supported:
- ❌ Prompts: Pre-written templates (prepare for future support)
Connector Generation
Create complete Power Platform connector with:
Core Files:
withapiDefinition.swagger.jsonx-ms-agentic-protocol: mcp-streamable-1.0
with connector metadata and authenticationapiProperties.json
with custom C# transformations for MCP JSON-RPC handlingscript.csx
with connector documentationreadme.md
MCP Integration:
- POST
endpoint for JSON-RPC 2.0 communication/mcp - McpResponse and McpErrorResponse schema definitions
- Copilot Studio constraint compliance (no reference types, single types)
- Resource integration as tool outputs (Resources and Tools supported; Prompts not yet supported)
Schema Validation & Troubleshooting
Validate schemas for Copilot Studio compliance:
- ✅ No reference types (
) in tool inputs/outputs$ref - ✅ Single type values only (not
)["string", "number"] - ✅ Primitive types: string, number, integer, boolean, array, object
- ✅ Resources as tool outputs, not separate entities
- ✅ Full URIs for all endpoints
Common issues and fixes:
- Tools filtered → Remove reference types, use primitives
- Type errors → Single types with validation logic
- Resources unavailable → Include in tool outputs
- Connection failures → Verify
headerx-ms-agentic-protocol
Context Variables
- Connector Name: [Display name for the connector]
- Server Purpose: [What the MCP server should accomplish]
- Tools Needed: [List of MCP tools to implement]
- Resources: [Types of resources to provide]
- Authentication: [none, api-key, oauth2, basic]
- Host Environment: [Azure Function, Express.js, etc.]
- Target APIs: [External APIs to integrate with]
Generation Modes
Mode 1: Complete New Connector
Generate all files for a new Power Platform MCP connector from scratch, including CLI validation setup.
Mode 2: Schema Validation
Analyze and fix existing schemas for Copilot Studio compliance using paconn and validation tools.
Mode 3: Integration Troubleshooting
Diagnose and resolve MCP integration issues with Copilot Studio using CLI debugging tools.
Mode 4: Hybrid Connector
Add MCP capabilities to existing Power Platform connector with proper validation workflows.
Mode 5: Certification Preparation
Prepare connector for Microsoft certification submission with complete metadata and validation compliance.
Mode 6: OAuth Security Hardening
Implement OAuth 2.0 authentication enhanced with MCP security best practices and advanced token validation.
Expected Output
1. apiDefinition.swagger.json
- Swagger 2.0 format with Microsoft extensions
- MCP endpoint:
with proper protocol headerPOST /mcp - Compliant schema definitions (primitive types only)
- McpResponse/McpErrorResponse definitions
2. apiProperties.json
- Connector metadata and branding (
required)iconBrandColor - Authentication configuration
- Policy templates for MCP transformations
3. script.csx
- JSON-RPC 2.0 message handling
- Request/response transformations
- MCP protocol compliance logic
- Error handling and validation
4. Implementation guidance
- Tool registration and execution patterns
- Resource management strategies
- Copilot Studio integration steps
- Testing and validation procedures
Validation Checklist
Technical Compliance
-
in MCP endpointx-ms-agentic-protocol: mcp-streamable-1.0 - No reference types in any schema definitions
- All type fields are single types (not arrays)
- Resources included as tool outputs
- JSON-RPC 2.0 compliance in script.csx
- Full URI endpoints throughout
- Clear descriptions for Copilot Studio agents
- Authentication properly configured
- Policy templates for MCP transformations
- Generative Orchestration compatibility
CLI Validation
- paconn validate:
passes without errorspaconn validate --api-def apiDefinition.swagger.json - pac CLI ready: Connector can be created/updated with
pac connector create/update - Script validation: script.csx passes automatic validation during pac CLI upload
- Package validation:
runs successfullyConnectorPackageValidator.ps1
OAuth and Security Requirements
- OAuth 2.0 Enhanced: Standard OAuth 2.0 with MCP security best practices implementation
- Token Validation: Implement token audience validation to prevent passthrough attacks
- Custom Security Logic: Enhanced validation in script.csx for MCP compliance
- State Parameter Protection: Secure state parameters for CSRF prevention
- HTTPS Enforcement: All production endpoints use HTTPS only
- MCP Security Practices: Implement confused deputy attack prevention within OAuth 2.0
Certification Requirements
- Complete metadata: settings.json with product and service information
- Icon compliance: PNG format, 230x230 or 500x500 dimensions
- Documentation: Certification-ready readme with comprehensive examples
- Security compliance: OAuth 2.0 enhanced with MCP security practices, privacy policy
- Authentication flow: OAuth 2.0 with custom security validation properly configured
Example Usage
Mode: Complete New Connector Connector Name: Customer Analytics MCP Server Purpose: Customer data analysis and insights Tools Needed: - searchCustomers: Find customers by criteria - getCustomerProfile: Retrieve detailed customer data - analyzeCustomerTrends: Generate trend analysis Resources: - Customer profiles (JSON data) - Analysis reports (structured data) Authentication: oauth2 Host Environment: Azure Function Target APIs: CRM REST API