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.

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.

Dynamics 365 Table Relationship Explorer CLI and MCP

Using data from and inspired by https://github.com/ameyer505/MicrosoftDynamicsTableAssociations

The repo contains two packages

  1. Core Package (d365-relations-cli): Contains the table relationship finder functionality and CLI.
  2. MCP Package (d365-relations-mcp): Provides an MCP server that exposes the core functionality to AI assistants.

Core Package

The core package provides the following functionality:

  • Finding directly related tables (case-insensitive)
  • Finding relationship paths between tables with configurable levels of intermediate tables
  • Getting detailed relationship information
  • Listing all available tables
  • Retrieving statistics about the relationships
  • Optimizing relationship files for reduced size and improved performance

MCP Package

The MCP package builds on the core package and exposes its functionality as MCP tools with FastMCP:

  • MCP tools that mirror the core functionality
  • Simple configuration through environment variables and command-line arguments

Installation

Both packages can be installed separately:

# or using uv
uv add d365-relations-cli
uv add d365-relations-mcpk

Usage

Core Package CLI

# Find related tables
uv run tr find-related Customer

# Find relationship paths
uv run tr find-relationship Customer SalesOrder --levels 2

# Optimize relationship file
uv run tr optimize -i tablefieldassociations.json -o tablefieldassociations_opt.json

MCP Server

# Start the MCP server
uv run mcp

# optionally specify a different relationship file
uv run mcp --relationship-file tablefieldassociations_opt.json

AI Assistant Integration

The MCP server integrates with AI assistants that support the MCP protocol. Example prompts are provided in the example_prompts.md file.

See more details on how to use in the