# cdatasoftware/cdata-jdbc-mcp-server architecture

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

- Interactive diagram: https://gitdiagram.com/cdatasoftware/cdata-jdbc-mcp-server
- Repository: https://github.com/cdatasoftware/cdata-jdbc-mcp-server

## Overview

##### Project type and purpose
- This is a standalone Java “read-only” MCP (Model Context Protocol) server.
- It wraps CData JDBC drivers to expose data from external sources via a simple tooling interface over stdio for LLM clients (e.g., Claude Desktop).

##### File structure
- pom.xml – Maven build file.
- src/main/java/com/cdata/mcp – core packages:
– Program.java: entry point, bootstraps the server.
– Config.java, Constants.java: configuration and static values.
– ITool.java, IResource.java: abstractions for “tools” (actions) and “resources.”
– CsvUtils/CsvWriter, JsonSchemaBuilder: formatting and schema generation.
– StringUtil, UrlUtil: utility classes.
– Table.java: domain model for tables.
- src/main/java/com/cdata/mcp/resources – HTTP‐like or MCP resources (e.g., TableMetadataResource).
- src/main/java/com/cdata/mcp/tools – concrete tools: GetTablesTool, GetColumnsTool, RunQueryTool.
- src/test – unit tests for JsonSchemaBuilder and Table.

##### README for additional insights
- Describes the overall architecture: MCP server communicates over stdio, uses a .prp file for configuration, loads a CData JDBC Driver, exposes three main tools to an LLM client.
- No web/API layer—communication is purely stdio-based.
- Workflow: load config -> instantiate driver -> register tools -> listen/serve tool invocations -> return CSV/JSON to client.

##### Detail
- Every package/component group.
- How tests fit in (unit testing layer not present at runtime, but ensures correctness of JsonSchemaBuilder and Table model).
- Don’t over-complicate—focus on drawing as many discrete components/modules as possible to highlight separation of concerns.

## Diagram (Mermaid)

```mermaid
graph TB
    Client["LLM Client\n(Claude Desktop)"]:::external
    Client -->|"MCP protocol\nstdin/stdout"| Server["MCP Server"]:::server

    subgraph "MCP Server"
        direction TB
        Program["Program"]:::bootstrap
        Config["Config"]:::core
        Constants["Constants"]:::core

        subgraph "Ports (Interfaces)"
            direction TB
            ITool["ITool"]:::interface
            IResource["IResource"]:::interface
        end

        subgraph "Tool Registry & Implementations"
            direction TB
            GetTablesTool["GetTablesTool"]:::impl
            GetColumnsTool["GetColumnsTool"]:::impl
            RunQueryTool["RunQueryTool"]:::impl
            TableMetadataResource["TableMetadataResource"]:::impl
        end

        subgraph "Formatting & Schema"
            direction TB
            CsvUtils["CsvUtils"]:::util
            CsvWriter["CsvWriter"]:::util
            JsonSchemaBuilder["JsonSchemaBuilder"]:::util
        end

        subgraph "Utilities"
            direction TB
            StringUtil["StringUtil"]:::util
            UrlUtil["UrlUtil"]:::util
        end

        subgraph "Domain Model"
            direction TB
            Table["Table"]:::model
        end

        subgraph "Config Loader & JDBC Adapter"
            direction TB
            ConfigLoader[".prp Parser"]:::core
            JDBCAdapter["JDBC Adapter"]:::core
        end
    end

    Server --> Program
    Program --> Config
    Program --> Constants
    Program --> ITool
    Program --> IResource

    ITool --> GetTablesTool
    ITool --> GetColumnsTool
    ITool --> RunQueryTool
    IResource --> TableMetadataResource

    Config --> ConfigLoader
    ConfigLoader --> JDBCDriver["CData JDBC Driver"]:::external
    JDBCAdapter --> JDBCDriver
    GetTablesTool --> JDBCAdapter
    GetColumnsTool --> JDBCAdapter
    RunQueryTool --> JDBCAdapter
    JDBCDriver --> DataSource["External Data Source\n(SQL DB, CRM, etc)"]:::external

    GetTablesTool --> CsvWriter
    GetColumnsTool --> JsonSchemaBuilder
    RunQueryTool --> CsvUtils
    JsonSchemaBuilder --> Table
    CsvWriter --> StringUtil
    CsvUtils --> UrlUtil

    Server --> JsonTests["JsonSchemaBuilderTests"]:::test
    Server --> TableTests["TableTests"]:::test
    JsonTests --> JsonSchemaBuilder
    TableTests --> Table

    click Program "https://github.com/cdatasoftware/cdata-jdbc-mcp-server/blob/main/src/main/java/com/cdata/mcp/Program.java"
    click Config "https://github.com/cdatasoftware/cdata-jdbc-mcp-server/blob/main/src/main/java/com/cdata/mcp/Config.java"
    click Constants "https://github.com/cdatasoftware/cdata-jdbc-mcp-server/blob/main/src/main/java/com/cdata/mcp/Constants.java"
    click ITool "https://github.com/cdatasoftware/cdata-jdbc-mcp-server/blob/main/src/main/java/com/cdata/mcp/ITool.java"
    click IResource "https://github.com/cdatasoftware/cdata-jdbc-mcp-server/blob/main/src/main/java/com/cdata/mcp/IResource.java"
    click GetTablesTool "https://github.com/cdatasoftware/cdata-jdbc-mcp-server/blob/main/src/main/java/com/cdata/mcp/tools/GetTablesTool.java"
    click GetColumnsTool "https://github.com/cdatasoftware/cdata-jdbc-mcp-server/blob/main/src/main/java/com/cdata/mcp/tools/GetColumnsTool.java"
    click RunQueryTool "https://github.com/cdatasoftware/cdata-jdbc-mcp-server/blob/main/src/main/java/com/cdata/mcp/tools/RunQueryTool.java"
    click TableMetadataResource "https://github.com/cdatasoftware/cdata-jdbc-mcp-server/blob/main/src/main/java/com/cdata/mcp/resources/TableMetadataResource.java"
    click CsvUtils "https://github.com/cdatasoftware/cdata-jdbc-mcp-server/blob/main/src/main/java/com/cdata/mcp/CsvUtils.java"
    click CsvWriter "https://github.com/cdatasoftware/cdata-jdbc-mcp-server/blob/main/src/main/java/com/cdata/mcp/CsvWriter.java"
    click JsonSchemaBuilder "https://github.com/cdatasoftware/cdata-jdbc-mcp-server/blob/main/src/main/java/com/cdata/mcp/JsonSchemaBuilder.java"
    click StringUtil "https://github.com/cdatasoftware/cdata-jdbc-mcp-server/blob/main/src/main/java/com/cdata/mcp/StringUtil.java"
    click UrlUtil "https://github.com/cdatasoftware/cdata-jdbc-mcp-server/blob/main/src/main/java/com/cdata/mcp/UrlUtil.java"
    click Table "https://github.com/cdatasoftware/cdata-jdbc-mcp-server/blob/main/src/main/java/com/cdata/mcp/Table.java"
    click pom "https://github.com/cdatasoftware/cdata-jdbc-mcp-server/blob/main/pom.xml"
    click readme "https://github.com/cdatasoftware/cdata-jdbc-mcp-server/blob/main/README.md"
    click JsonTests "https://github.com/cdatasoftware/cdata-jdbc-mcp-server/blob/main/src/test/java/com/cdata/mcp/tests/JsonSchemaBuilderTests.java"
    click TableTests "https://github.com/cdatasoftware/cdata-jdbc-mcp-server/blob/main/src/test/java/com/cdata/mcp/tests/TableTests.java"

    classDef external fill:#f2f2f2,stroke:#333,stroke-width:1px
    classDef server fill:#e6f7ff,stroke:#007acc,stroke-width:1px
    classDef core fill:#d9f7be,stroke:#52c41a,stroke-width:1px
    classDef interface fill:#fff7e6,stroke:#fa8c16,stroke-width:1px
    classDef impl fill:#f6ffed,stroke:#52c41a,stroke-width:1px
    classDef util fill:#fff0f6,stroke:#eb2f96,stroke-width:1px
    classDef model fill:#e6fffb,stroke:#13c2c2,stroke-width:1px
    classDef test fill:#fffbe6,stroke:#faad14,stroke-width:1px
    class Program bootstrap
```
