Dynamics 365 Table Relationship Explorer CLI and MCP

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.