MCP.so
Sign In

Dynamics 365 Table Relationship Explorer CLI and MCP

@duggurd

Repository

About 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

Config

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

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

Tools

No tools detected

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

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.

Frequently asked questions

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.

Comments

Basic information

Category

Developer Tools

Transports

stdio

Author

duggurd

More Developer Tools MCP servers

Codex Pets

astandrik

Public read-only MCP server for discovering, inspecting, installing, and sharing approved Codex-compatible animated pet packs.

Routebase

Routebase

Routebase keeps your API's design, docs, contract tests, mocks and monitoring in one living OpenAPI spec so they can't drift apart. Agents work on that same source of truth, under your team's permissions.

Repo Test Architect

RepoAssay

Local-first, read-only MCP server for evidence-backed repository test architecture audits and test planning.

Termany

thinkany-ai

Agent-Native Terminal

174
S

SecondSim

econdSim provisions real UK mobile numbers (non-VoIP) via eSIM, built for freelancers, sole traders, small businesses, and enterprise teams. Unlike VoIP apps and virtual numbers, SecondSim numbers register as genuine phy