Sponsored by Deepsite.site

JSON MCP Server by CData

Created By
CDataSoftware7 months ago
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).
Overview

What is JSON MCP Server by CData?

The JSON MCP Server by CData is a read-only Model Context Protocol (MCP) server designed to allow large language models (LLMs) to query live JSON data using natural language, without the need for SQL.

How to use JSON MCP Server?

To use the JSON MCP Server, clone the repository, build the server, install the CData JDBC Driver for JSON, configure your connection, and run the server. You can then connect it to AI clients like Claude Desktop to query data.

Key features of JSON MCP Server?

  • Provides a read-only interface for querying JSON data.
  • Allows natural language queries without SQL.
  • Integrates with various data sources through JDBC.

Use cases of JSON MCP Server?

  1. Querying live data from JSON sources using AI.
  2. Integrating with AI clients for data retrieval.
  3. Simplifying data access for non-technical users.

FAQ from JSON MCP Server?

  • Can I write data using this server?

No, this server is read-only. For write capabilities, consider the full CData MCP Server for JSON.

  • Is there a trial version available?

Yes, you can download a trial version of the CData JDBC Driver for JSON.

  • What types of data sources can I connect to?

The server supports a wide range of data sources, including Salesforce, Google Sheets, and many more.

Server Config

{
  "mcpServers": {
    "{classname_dash}": {
      "command": "PATH\\TO\\java.exe",
      "args": [
        "-jar",
        "PATH\\TO\\CDataMCP-jar-with-dependencies.jar",
        "PATH\\TO\\json.prp"
      ]
    }
  }
}
Recommend Servers
TraeBuild with Free GPT-4.1 & Claude 3.7. Fully MCP-Ready.
Zhipu Web SearchZhipu Web Search MCP Server is a search engine specifically designed for large models. It integrates four search engines, allowing users to flexibly compare and switch between them. Building upon the web crawling and ranking capabilities of traditional search engines, it enhances intent recognition capabilities, returning results more suitable for large model processing (such as webpage titles, URLs, summaries, site names, site icons, etc.). This helps AI applications achieve "dynamic knowledge acquisition" and "precise scenario adaptation" capabilities.
Tavily Mcp
BlenderBlenderMCP connects Blender to Claude AI through the Model Context Protocol (MCP), allowing Claude to directly interact with and control Blender. This integration enables prompt assisted 3D modeling, scene creation, and manipulation.
Playwright McpPlaywright MCP server
Context7Context7 MCP Server -- Up-to-date code documentation for LLMs and AI code editors
AiimagemultistyleA Model Context Protocol (MCP) server for image generation and manipulation using fal.ai's Stable Diffusion model.
Serper MCP ServerA Serper MCP Server
Visual Studio Code - Open Source ("Code - OSS")Visual Studio Code
DeepChatYour AI Partner on Desktop
MCP AdvisorMCP Advisor & Installation - Use the right MCP server for your needs
TimeA Model Context Protocol server that provides time and timezone conversion capabilities. This server enables LLMs to get current time information and perform timezone conversions using IANA timezone names, with automatic system timezone detection.
WindsurfThe new purpose-built IDE to harness magic
Baidu Map百度地图核心API现已全面兼容MCP协议,是国内首家兼容MCP协议的地图服务商。
ChatWiseThe second fastest AI chatbot™
Jina AI MCP ToolsA Model Context Protocol (MCP) server that integrates with Jina AI Search Foundation APIs.
Amap Maps高德地图官方 MCP Server
EdgeOne Pages MCPAn MCP service designed for deploying HTML content to EdgeOne Pages and obtaining an accessible public URL.
CursorThe AI Code Editor
MiniMax MCPOfficial MiniMax Model Context Protocol (MCP) server that enables interaction with powerful Text to Speech, image generation and video generation APIs.
Howtocook Mcp基于Anduin2017 / HowToCook (程序员在家做饭指南)的mcp server,帮你推荐菜谱、规划膳食,解决“今天吃什么“的世纪难题; Based on Anduin2017/HowToCook (Programmer's Guide to Cooking at Home), MCP Server helps you recommend recipes, plan meals, and solve the century old problem of "what to eat today"