PowerPlatform MCP

Instructions

Input Schema

Input Schema (JSON Schema)

Implementation Reference

• src/index.ts:465-500 (registration)

  Full MCP server.tool registration block for the 'get-entity-relationships' tool, including schema and complete handler implementation that fetches and returns entity relationships as formatted JSON text.
  server.tool( "get-entity-relationships", "Get relationships (one-to-many and many-to-many) for a PowerPlatform entity", { entityName: z.string().describe("The logical name of the entity"), }, async ({ entityName }) => { try { // Get or initialize PowerPlatformService const service = getPowerPlatformService(); const relationships = await service.getEntityRelationships(entityName); // Format the relationships as a string for text display const relationshipsStr = JSON.stringify(relationships, null, 2); return { content: [ { type: "text", text: `Relationships for entity '${entityName}':\n\n${relationshipsStr}`, }, ], }; } catch (error: any) { console.error("Error getting entity relationships:", error); return { content: [ { type: "text", text: `Failed to get entity relationships: ${error.message}`, }, ], }; } } );
• src/index.ts:468-470 (schema)

  Zod input schema for the tool, defining the 'entityName' parameter.
  { entityName: z.string().describe("The logical name of the entity"), },
• src/index.ts:471-499 (handler)

  Inline handler function of the tool that initializes the service, calls getEntityRelationships, stringifies the result, and returns it as text content.
  async ({ entityName }) => { try { // Get or initialize PowerPlatformService const service = getPowerPlatformService(); const relationships = await service.getEntityRelationships(entityName); // Format the relationships as a string for text display const relationshipsStr = JSON.stringify(relationships, null, 2); return { content: [ { type: "text", text: `Relationships for entity '${entityName}':\n\n${relationshipsStr}`, }, ], }; } catch (error: any) { console.error("Error getting entity relationships:", error); return { content: [ { type: "text", text: `Failed to get entity relationships: ${error.message}`, }, ], }; } }
• src/PowerPlatformService.ts:222-232 (helper)

  Core helper method in PowerPlatformService that concurrently retrieves one-to-many and many-to-many relationships for the given entity.
  async getEntityRelationships(entityName: string): Promise<{oneToMany: ApiCollectionResponse<any>, manyToMany: ApiCollectionResponse<any>}> { const [oneToMany, manyToMany] = await Promise.all([ this.getEntityOneToManyRelationships(entityName), this.getEntityManyToManyRelationships(entityName) ]); return { oneToMany, manyToMany }; }
• src/PowerPlatformService.ts:173-197 (helper)

  Helper method that fetches and filters one-to-many relationships from the Dataverse API, excluding certain system entities.
  async getEntityOneToManyRelationships(entityName: string): Promise<ApiCollectionResponse<any>> { const selectProperties = [ 'SchemaName', 'RelationshipType', 'ReferencedAttribute', 'ReferencedEntity', 'ReferencingAttribute', 'ReferencingEntity', 'ReferencedEntityNavigationPropertyName', 'ReferencingEntityNavigationPropertyName' ].join(','); // Only filter by ReferencingAttribute in the OData query since startswith isn't supported const response = await this.makeRequest<ApiCollectionResponse<any>>(`api/data/v9.2/EntityDefinitions(LogicalName='${entityName}')/OneToManyRelationships?$select=${selectProperties}&$filter=ReferencingAttribute ne 'regardingobjectid'`); // Filter the response to exclude relationships with ReferencingEntity starting with 'msdyn_' or 'adx_' if (response && response.value) { response.value = response.value.filter((relationship: any) => { const referencingEntity = relationship.ReferencingEntity || ''; return !(referencingEntity.startsWith('msdyn_') || referencingEntity.startsWith('adx_')); }); } return response; }