# cdatasoftware/dynamics-365-business-central-mcp-server-by-cdata architecture

> Architecture diagram of the GitHub repository cdatasoftware/dynamics-365-business-central-mcp-server-by-cdata, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2025-08-29). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/cdatasoftware/dynamics-365-business-central-mcp-server-by-cdata
- Repository: https://github.com/cdatasoftware/dynamics-365-business-central-mcp-server-by-cdata

## Overview

##### Project type and purpose
- This is a Java-based, command-line/stdio JSON-RPC server implementing CData’s Model Context Protocol (MCP).
- Purpose: wrap the CData JDBC Driver for Dynamics 365 Business Central and expose read-only data via JSON-RPC “tools” so LLMs or scripts can query live data without writing SQL.

##### File structure
- src/main/java/com/cdata/mcp: core packages
- Program.java – entry point, reads `.prp` config, starts the JSON-RPC loop
- Config.java – loads/holds connection properties from the `.prp` file
- ITool, IResource – interfaces defining tools and metadata resources
- tools/ – individual tool implementations (GetTablesTool, GetColumnsTool, RunQueryTool)
- resources/ – metadata endpoints (TableMetadataResource)
- CsvUtils, CsvWriter, JsonSchemaBuilder – utility classes for formatting output
- pom.xml – Maven build & dependencies (shade plugin to bundle driver JAR)
- src/test – unit tests for core builders and Table model

##### README for additional insights
- Describes MCP Server’s runtime workflow:
1. Java process launched with `-jar CDataMCP-jar-with-dependencies.jar` + `.prp` file
2. JSON-RPC 2.0 messages in/stdout
3. Commands map to tool implementations, which open a JDBC connection via the CData driver JAR
4. Query results are returned in CSV or JSON schema form

##### Main components
a. Client Layer
- LLM or custom script (e.g. Claude Desktop)
- Communicates via stdin/stdout JSON-RPC
b. Server Core (Application Layer)
1. Program (Main)
- Reads `.prp` config via Config loader
- Initializes Tool registry and Resource endpoints
- Enters JSON-RPC request loop
2. JSON-RPC Dispatcher
- Parses incoming method calls (tools/call)
- Routes to the appropriate ITool implementation
3. Tools Layer
- GetTablesTool → returns table names
- GetColumnsTool → returns column metadata
- RunQueryTool → executes arbitrary SELECT SQL
4. Metadata Resources Layer
- TableMetadataResource
5. Utilities
- CsvUtils, CsvWriter – format tabular data as CSV with headers
- JsonSchemaBuilder – build JSON schema from table definitions
c. Data Access Layer
- CData JDBC Driver (external JAR)
- JDBC Connection managed by Program or tools
d. External Systems
- Dynamics 365 Business Central (the actual data source)
- License & JDBC configuration utility (out of band)

##### Relationships and data flow
- Client → stdin JSON-RPC → Program/Main
- Program → dispatch → Tool implementation
- Tool → JDBC driver (DriverManager) → Dynamics 365 Business Central
- Results → Utilities (CSV/JSON builder) → JSON-RPC response → stdout → Client

##### Architectural patterns & design principles
- Layered architecture: Presentation (JSON-RPC) → Application (dispatcher/tools) → Data (JDBC)
- Interface-driven design: ITool and IResource abstractions for future extension
- Single-process, no HTTP—uses stdio to ensure client and server run co-located
- Configuration-based wiring: `.prp` file dictates driver path, URL, tables

##### Detail
- Every layer and abstraction (IResource vs. ITool) even if they’re small interfaces
- Build artifact (uber-jar) contains both server code and JDBC driver
- Stdio contract (no HTTP server) so engineers don’t assume a web tier

## Diagram (Mermaid)

```mermaid
flowchart TB
    %% External Client
    Client["LLM or Script\n(stdin/stdout JSON-RPC)"]:::external

    %% Configuration File
    ConfigFile[".prp Config File"]:::configFile

    %% Main Application
    subgraph "Application Layer"
        Program["Program (Main)"]:::app
        JSONRPC["JSON-RPC Dispatcher"]:::app
        ITool["ITool Interface"]:::app
        IResource["IResource Interface"]:::app
    end

    %% Tools Layer
    subgraph "Tools Layer"
        GetTables["GetTablesTool"]:::app
        GetColumns["GetColumnsTool"]:::app
        RunQuery["RunQueryTool"]:::app
    end

    %% Resources Layer
    subgraph "Metadata Resources Layer"
        TableMeta["TableMetadataResource"]:::app
    end

    %% Utilities Layer
    subgraph "Utilities"
        CsvUtils["CsvUtils"]:::util
        CsvWriter["CsvWriter"]:::util
        JsonSchema["JsonSchemaBuilder"]:::util
        StringUtil["StringUtil"]:::util
        UrlUtil["UrlUtil"]:::util
    end

    %% Data Access
    JDBCDriver["CData JDBC Driver (JAR)"]:::lib

    %% External System
    ExternalDB["Dynamics 365 Business Central"]:::external

    %% Build Configuration
    pom["pom.xml"]:::build

    %% Connections
    Client -->|"JSON-RPC request"| Program
    ConfigFile -->|"loads settings"| Program
    Program -->|"dispatch"| JSONRPC
    JSONRPC -->|"tools/call"| GetTables
    JSONRPC -->|"tools/call"| GetColumns
    JSONRPC -->|"tools/call"| RunQuery
    JSONRPC -->|"tools/call"| TableMeta

    GetTables -->|"JDBC Connection"| JDBCDriver
    GetColumns -->|"JDBC Connection"| JDBCDriver
    RunQuery -->|"JDBC Connection"| JDBCDriver
    TableMeta -->|"JDBC Connection"| JDBCDriver
    JDBCDriver --> ExternalDB

    GetTables -->|"format"| CsvUtils
    GetTables -->|"format"| CsvWriter
    GetColumns -->|"format"| JsonSchema
    TableMeta -->|"format"| JsonSchema
    RunQuery -->|"format"| CsvUtils
    RunQuery -->|"format"| CsvWriter

    RunQuery --> StringUtil
    RunQuery --> UrlUtil

    Program --> pom

    %% Click Events
    click Program "https://github.com/cdatasoftware/dynamics-365-business-central-mcp-server-by-cdata/blob/main/src/main/java/com/cdata/mcp/Program.java"
    click ConfigFile "https://github.com/cdatasoftware/dynamics-365-business-central-mcp-server-by-cdata/blob/main/src/main/java/com/cdata/mcp/Config.java"
    click ITool "https://github.com/cdatasoftware/dynamics-365-business-central-mcp-server-by-cdata/blob/main/src/main/java/com/cdata/mcp/ITool.java"
    click IResource "https://github.com/cdatasoftware/dynamics-365-business-central-mcp-server-by-cdata/blob/main/src/main/java/com/cdata/mcp/IResource.java"
    click GetTables "https://github.com/cdatasoftware/dynamics-365-business-central-mcp-server-by-cdata/blob/main/src/main/java/com/cdata/mcp/tools/GetTablesTool.java"
    click GetColumns "https://github.com/cdatasoftware/dynamics-365-business-central-mcp-server-by-cdata/blob/main/src/main/java/com/cdata/mcp/tools/GetColumnsTool.java"
    click RunQuery "https://github.com/cdatasoftware/dynamics-365-business-central-mcp-server-by-cdata/blob/main/src/main/java/com/cdata/mcp/tools/RunQueryTool.java"
    click TableMeta "https://github.com/cdatasoftware/dynamics-365-business-central-mcp-server-by-cdata/blob/main/src/main/java/com/cdata/mcp/resources/TableMetadataResource.java"
    click CsvUtils "https://github.com/cdatasoftware/dynamics-365-business-central-mcp-server-by-cdata/blob/main/src/main/java/com/cdata/mcp/CsvUtils.java"
    click CsvWriter "https://github.com/cdatasoftware/dynamics-365-business-central-mcp-server-by-cdata/blob/main/src/main/java/com/cdata/mcp/CsvWriter.java"
    click JsonSchema "https://github.com/cdatasoftware/dynamics-365-business-central-mcp-server-by-cdata/blob/main/src/main/java/com/cdata/mcp/JsonSchemaBuilder.java"
    click StringUtil "https://github.com/cdatasoftware/dynamics-365-business-central-mcp-server-by-cdata/blob/main/src/main/java/com/cdata/mcp/StringUtil.java"
    click UrlUtil "https://github.com/cdatasoftware/dynamics-365-business-central-mcp-server-by-cdata/blob/main/src/main/java/com/cdata/mcp/UrlUtil.java"
    click pom "https://github.com/cdatasoftware/dynamics-365-business-central-mcp-server-by-cdata/blob/main/pom.xml"

    %% Styles
    classDef app fill:#cce5ff,stroke:#004085,color:#004085
    classDef util fill:#ffeeba,stroke:#856404,color:#856404
    classDef lib fill:#d4edda,stroke:#155724,color:#155724
    classDef external fill:#e2e3e5,stroke:#6c757d,color:#6c757d
    classDef configFile fill:#f5c6cb,stroke:#721c24,color:#721c24
    classDef build fill:#e2e3e5,stroke:#343a40,color:#343a40
```
