dynamics_relations

duggurd/dynamics_relations

3.2

If you are the rightful owner of dynamics_relations and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.

The Dynamics 365 Table Relationship Explorer provides tools to explore and manage table relationships within Dynamics 365, offering both a CLI and an MCP server for integration with AI assistants.

The Dynamics 365 Table Relationship Explorer is a comprehensive toolset designed to facilitate the exploration and management of table relationships within Microsoft Dynamics 365. It consists of two main packages: the Core Package, which offers command-line interface (CLI) tools for finding related tables, exploring relationship paths, and optimizing relationship files; and the MCP Package, which extends the core functionality by providing an MCP server that allows integration with AI assistants. This server uses the FastMCP protocol to expose the core functionalities, enabling seamless interaction with AI systems. The toolset is particularly useful for developers and administrators who need to understand and optimize the complex web of table relationships in Dynamics 365, ensuring efficient data management and system performance.

Features

  • Finding directly related tables with case-insensitivity
  • Exploring relationship paths with configurable levels of intermediate tables
  • Retrieving detailed relationship information
  • Listing all available tables
  • Optimizing relationship files for reduced size and improved performance

Usages

usage with local integration stdio

python
mcp.run(transport='stdio')  # Tools defined via @mcp.tool() decorator

usage with local integration ide plugin

{
  "mcpServers": {
    "d365-relations": {
      "command": "uv",
      "args": ["run", "mcp"]
    }
  }
}

usage with remote integration sse

python
mcp.run(transport='sse', host="0.0.0.0", port=8000)  # Specify SSE endpoint

usage with remote integration streamable http

yaml
paths:
  /mcp:
    post:
      x-ms-agentic-protocol: mcp-streamable-1.0  # Copilot Studio integration

usage with platform ecosystem integration ai toolchains

{"command": "docker", "args": ["run", "-e", "GITHUB_PERSONAL_ACCESS_TOKEN", "ghcr.io/github/github-mcp-server"]}

usage with platform ecosystem integration enterprise saas

{
  "mcpServers": {
    "d365-relations": {
      "command": "uv",
      "args": ["run", "mcp"]
    }
  }
}

Tools

  1. find-related

    Finds tables directly related to a specified table.

  2. find-relationship

    Finds relationship paths between two tables with specified levels of intermediates.

  3. optimize

    Optimizes relationship files for better performance.