Advertise
MCP.so
Sign In
J

JSON MCP Server by CData

@CDataSoftware

Repository

Basic information

Category

Other

Transports

stdio

Author

CDataSoftware

Submitted by

Cameron Leblanc

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

JSON MCP Server by CData 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"
      ]
    }
  }
}

JSON MCP Server by CData tools

Tool list not available yet

This listing does not currently have a tool list to display. This does not mean the server has no tools; check its documentation for supported capabilities.

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

Frequently asked questions

1

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.

2

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.

3

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.

4

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.

5

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

FastMCP v2 🚀

jlowin

🚀 The fast, Pythonic way to build MCP servers and clients.

26.0K

ICSS

chokcoco

不止于 CSS

20.7K
P

PickFu MCP

PickFu MCP is a Model Context Protocol (MCP) server that connects AI assistants, developers, marketers, product managers, and AI agents to PickFu's consumer research platform. It enables users to create surveys, conduct

Screenpipe

screenpipe

YC (S26) | Open Computer History | Continuously record your company computer work, map your workflows, help you find work worth automating, and power your agents' context

22.0K

Figs, Relationship Expert

Figs O'Sullivan, LMFT

Couples therapist Figs O'Sullivan (LMFT, 17 years, endorsed by Sue Johnson, creator of EFT) inside your AI. Ask relationship questions answered from his clinical writing, name the pattern in a fight, get a three-step rep

Advertise