MCP.so
Sign In
J

JSON MCP Server by CData

@CDataSoftware

Repository

About 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

Basic information

Category

Other

Transports

stdio

Publisher

CDataSoftware

Submitted by

Cameron Leblanc

Config

Add this server to your MCP-compatible client using the configuration below.

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

Tools

No tools detected

We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.

Overview

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).

Comments

More Other MCP servers

🪟 Windows-MCP

CursorTouch

MCP Server for Computer Use in Windows

6.3K

Production-ready MCP integrations for AI applications

Klavis-AI

Klavis AI: MCP integration platforms that let AI agents use tools reliably at any scale

5.8K

🚀 Model Context Protocol (MCP) Curriculum for Beginners

microsoft

This open-source curriculum introduces the fundamentals of Model Context Protocol (MCP) through real-world, cross-language examples in .NET, Java, TypeScript, JavaScript, Rust and Python. Designed for developers, it focuses on practical techniques for building modular, scalable,

16.7K

MaxKB

1Panel-dev

🔥 MaxKB is an open-source platform for building enterprise-grade agents. 强大易用的开源企业级智能体平台。

22.0K

MCP Go 🚀

mark3labs

A Go implementation of the Model Context Protocol (MCP), enabling seamless integration between LLM applications and external data sources and tools.

8.9K