Dynamics 365 Table Relationship Explorer CLI and MCP
About
CLI tool and MCP server for finding and exploring Dynamics 365/Axapta table relationships
Details
- Author
- duggurd
- Downloads
- 337
- Categories
- Developer Tools
Jump to
- 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
Setting up with Highlight
This MCP is not yet compatible with Highlight’s one-click setup. However, you can still use it with Highlight by following these steps:
- Download and install Highlight from highlightai.com/download
- Navigate to the plugins tab and select "Add Custom Plugin"
-
Configure the plugin with the settings below
Plugin Name
Dynamics 365 Table Relationship Explorer CLI and MCPCommand (node, npx, python, etc.)Please refer to the README for specific instructions on how to obtain API keys or other required environment variables.
- Enable "Start Automatically" if you want the plugin to start when Highlight launches
From the repository
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.
Claude Desktop / Cursor
Paste into your MCP client config file to install this server.
{
"mcpServers": {
"dynamics 365 table relationship explorer cli and mcp": {
"dynamics_relations": {
"command": "uv",
"args": [
"run",
"tr",
"find-related",
"Customer"
]
}
}
}
}McpServers
{
"dynamics_relations": {
"command": "uv",
"args": [
"run",
"tr",
"find-related",
"Customer"
]
}
}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:
```bash
Sign in to leave a review
Use Google, GitHub, or an email account so ratings stay tied to real people.
No reviews posted yet.
