Advertise
MCP.so
Sign In

Dynamics 365 Table Relationship Explorer CLI and MCP Server

@duggurd

Repository

Basic information

Category

Developer Tools

Transports

stdio

Author

duggurd

About Dynamics 365 Table Relationship Explorer CLI and MCP Server

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

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

Dynamics 365 Table Relationship Explorer CLI and MCP Server config

Add this server to your MCP-compatible client using the configuration below.

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

Dynamics 365 Table Relationship Explorer CLI and MCP Server tools

Tool list not available yet

This listing does not currently have a tool list to display. This does not mean the server has no tools; check its documentation for supported capabilities.

We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.

Overview

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

Frequently asked questions

1

What data powers the relationship explorer?

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

2

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

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

3

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`.

4

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.

5

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.

Comments

More Developer Tools MCP servers

FARPY

mangomunchr

Verified distributed compute for humans, applications, and agents. Submit Blender, Octane, and video workloads, route them across qualified GPUs, track asynchronous execution, download finished artifacts, and verify FARP

1

Foremerge

naw103

Catch intent conflicts before code conflicts. The open-source coordination protocol for coding agents, built above Git.

50

Casefile

azimov777

One case file per task — shared by every session, agent and person that touches it. Self-hosted MCP server and live board. MIT.

3

Meticulous

Meticulous

dot.tools

Bitgate

28 developer utilities for LLMs: format, convert, encode, decode, generate and validate — JSON, YAML, XML, SQL, JWT, certificates, CIDR subnets, cron, hashes, UUIDs, passwords, QR codes and more. Stateless, fast, free.

Advertise