広告掲載
MCP.so
ログイン
J

JSON MCP Server by CData

@CDataSoftware

リポジトリ

基本情報

カテゴリ

その他

トランスポート

stdio

作者

CDataSoftware

投稿者

Cameron Leblanc

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 の設定

以下の設定を使って、このサーバーを MCP 対応クライアントに追加してください。

{
  "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 のツール

ツール一覧はまだありません

この掲載には表示できるツール一覧がまだありません。サーバーにツールがないという意味ではありません。対応機能はプロジェクトのドキュメントをご確認ください。

ツールは 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

よくある質問

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

コメント

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

Handl

Handl speaks the Model Context Protocol. Your whole billing operation — projects, invoices, clients, reports, approvals — as tools any AI assistant can call, inside your autonomy rules.

MCP Toolbox for Databases

googleapis

MCP Toolbox for Databases is an open source MCP server for databases.

15.9K

Blender

ahujasid

Open-source MCP to use Blender with any LLM

23.6K

Senso MCP for Joomla

sensomedia

Senso MCP turns a Joomla 5 or 6 site into a remote MCP server. It runs inside Joomla itself (no extra server, no Node.js bridge) and is secured with OAuth 2.1 and Joomla's own ACL. The free pack lets an AI assistant crea

Glasswarp

Glasswarp

See and control a real Windows PC you own — from any MCP client, locally or remotely. Observe (UIA + screenshots), click/type/drag/scroll, launch apps, owner Live View. BYOH: your machine, your key.

広告掲載