Dynamics 365 Table Relationship Explorer CLI and MCP

Name: Dynamics 365 Table Relationship Explorer CLI and MCP
Author: duggurd

@duggurd

代码仓库

关于 Dynamics 365 Table Relationship Explorer CLI and MCP

CLI tool and MCP server for finding and exploring Dynamics 365/Axapta table relationships

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

基本信息

分类

开发工具

运行时

python

传输方式

stdio

发布者

duggurd

配置

使用下面的配置,将此服务器添加到你的 MCP 客户端。

{
  "mcpServers": {
    "dynamics_relations": {
      "command": "uv",
      "args": [
        "run",
        "tr",
        "find-related",
        "Customer"
      ]
    }
  }
}

工具

未检测到工具

工具是从 README 中自动提取的。维护者可以在 ## Tools 标题下列出工具,即可填充这部分内容。

概览

What is Dynamics 365 Table Relationship Explorer CLI and MCP?

Dynamics 365 Table Relationship Explorer CLI and MCP is a tool for exploring table relationships in Microsoft Dynamics 365. It provides a CLI with table relationship finder functionality and an MCP server that exposes that functionality to AI assistants supporting the Model Context Protocol.

How to use Dynamics 365 Table Relationship Explorer CLI and MCP?

Install the core or MCP package using pip or uv add, then run uv run tr find-related <TableName> for related tables, uv run tr find-relationship <TableA> <TableB> for paths, or uv run tr optimize for file optimization. To start the MCP server, run uv run mcp with an optional --relationship-file argument.

Key features of Dynamics 365 Table Relationship Explorer CLI and MCP

Find directly related tables (case-insensitive)
Find relationship paths with configurable intermediate levels
Retrieve detailed relationship information
List all available tables in the dataset
Compute statistics about the relationships
Optimize relationship files for reduced size and performance

Use cases of Dynamics 365 Table Relationship Explorer CLI and MCP

Discovering which tables are connected to a specific Dynamics 365 entity
Tracing navigational paths between two unrelated tables for integration or reporting
Auditing and documenting the relationship network of a Dynamics 365 environment
Generating optimized local copies of relationship data for offline or low-latency use

FAQ from Dynamics 365 Table Relationship Explorer CLI and MCP

What data powers the relationship explorer?

The tool uses data from the MicrosoftDynamicsTableAssociations repository, which documents table relationships in Dynamics 365.

How do I find all tables related to a given table?

Run uv run tr find-related <tablename>. The search is case-insensitive.

How do I start the MCP server for AI assistant integration?

Run uv run mcp from the MCP package directory. Optionally specify a different relationship file with --relationship-file.

What are the runtime requirements?

Both packages depend on Python and can be installed via pip or uv. No external database or cloud service is required.

Can I reduce the size of the relationship files?

Yes. Use the tr optimize CLI command with -i and -o flags to produce an optimized, smaller JSON file.

开发工具分类下的更多 MCP 服务器

Sentry

modelcontextprotocol

Model Context Protocol Servers

88.1K

Golf

golf-mcp

Production-Ready MCP Server Framework • Build, deploy & scale secure AI agent infrastructure • Includes Auth, Observability, Debugger, Telemetry & Runtime • Run real-world MCPs powering AI Agents

834