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

「その他」の他のコンテンツ

Unity MCP ✨

justinpbarnett

Unity MCP acts as a bridge between AI assistants and your Unity Editor. Give your LLM tools to manage assets, control scenes, edit scripts, and automate tasks within Unity.

12.2K