JSON MCP Server by CData

Name: JSON MCP Server by CData
Author: CDataSoftware

@CDataSoftware

关于 JSON MCP Server by CData

This project builds a read-only MCP server. For full read, write, update, delete, and action capabilities and a simplified setup, check out our free [CData MCP Server for JSON (beta)](https://www.cdata.com/download/download.aspx?sku=DJZK-V&type=beta).

#json-mcp-server #data-access #api-server

基本信息

分类

其他

传输方式

stdio

发布者

CDataSoftware

提交者

Cameron Leblanc

配置

使用下面的配置,将此服务器添加到你的 MCP 客户端。

{
  "mcpServers": {
    "{classname_dash}": {
      "command": "PATH\\TO\\java.exe",
      "args": [
        "-jar",
        "PATH\\TO\\CDataMCP-jar-with-dependencies.jar",
        "PATH\\TO\\json.prp"
      ]
    }
  }
}

工具

未检测到工具

工具是从 README 中自动提取的。维护者可以在 ## Tools 标题下列出工具,即可填充这部分内容。

概览

What is JSON MCP Server by CData?

JSON MCP Server by CData is a read-only Model Context Protocol server that allows LLMs (like Claude Desktop) to query live JSON data. It wraps the CData JDBC Driver for JSON, which exposes JSON data as relational SQL models, enabling AI agents to retrieve live information through natural language questions without requiring SQL.

How to use JSON MCP Server by CData?

Clone the repository, build with mvn clean install, download and license the CData JDBC Driver for JSON, configure the connection string using the driver's utility, create a .prp file with JDBC connection details, then configure your client (e.g., Claude Desktop) to launch the JAR with the .prp file. The server uses stdio transport and runs on the same machine as the client.

Key features of JSON MCP Server by CData

Read-only MCP server for querying live JSON data
Exposes JSON sources as relational SQL models
Natural language querying via LLMs — no SQL needed
Uses the CData JDBC Driver for JSON under the hood
Provides tools: get_tables, get_columns, and run_query
MIT licensed and open source

Use cases of JSON MCP Server by CData

Let Claude Desktop answer questions about JSON-based business data
Correlate data from JSON APIs without writing SQL or code
Explore available tables and columns in a JSON data source through natural language
Run ad-hoc analytical queries against live JSON datasets

FAQ from JSON MCP Server by CData

Is this server read-only?

Yes, this MCP server is read-only. For full read, write, update, delete, and action capabilities, CData offers a separate free beta MCP Server for JSON.

What are the runtime requirements?

Java, Maven (to build), and the licensed CData JDBC Driver for JSON must be installed. The server communicates over stdio, so the client must run on the same machine.

What transport does the server use?

The server uses stdio transport and can only be used with clients running on the same machine as the server.

How do I authenticate to my JSON data source?

Configure the JDBC connection string using the CData JDBC Driver's Connection String utility. If the data source uses OAuth, you will need to authenticate in your browser during setup.

What tools does the server expose?

Three tools: {servername}_get_tables (list available tables), {servername}_get_columns (list columns for a table), and {servername}_run_query (execute a SQL SELECT query).