dynamics_relations

duggurd/dynamics_relations

3.1

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
3
Resources
0
Prompts
0

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