mcpField
D
Dynamics 365 Table Relationship Explorer CLI and MCP

Dynamics 365 Table Relationship Explorer CLI and MCP

Local
github.com/duggurdDeveloper Tools0Updated 74w ago
Repository

About Dynamics 365 Table Relationship Explorer CLI and MCP

A CLI and MCP server for exploring Dynamics 365/Axapta table relationships, aimed at developers and AI assistants. It supports relationship paths, detailed relationship lookups, and relationship statistics.

Key features

  1. 01Find directly related tables
  2. 02Find paths with configurable intermediate levels
  3. 03Inspect relationship details
  4. 04List tables and relationship statistics
  5. 05Optimize relationship files

Use cases

  1. 01Trace the relationship path between two tables
  2. 02Inspect a table’s related tables and links
  3. 03Reduce relationship file size and improve performance

MCP support

The FastMCP-based package exposes the core functionality as tools for MCP-compatible AI assistants. Configuration is available through environment variables and command-line arguments.

#dynamics-365#table-relationships#cli-tool

Configuration

Local server config is the same for every client. Copy it into your client’s MCP config file.

No install method listed yet

We haven’t collected a package or remote endpoint for this server. Follow the instructions in the project README.

Repository

Tools

No tool list yet

Local servers expose tools only once running on your machine, and the maintainer has not provided a tool list.

Details

From the project README

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 d365-relations-mcp package

Comments

Markdown supported

New to MCP?

From what the protocol is to installing your first server, these answers cover most first questions.

An open protocol that defines how AI applications connect to external tools and data in a uniform way. Clients talk to the model; MCP servers provide tools, resources and prompt templates. They exchange standard messages, so one server can be reused by many clients.