- JSON MCP Server by CData
JSON MCP Server by CData
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?
- Querying live data from JSON sources using AI.
- Integrating with AI clients for data retrieval.
- 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"
]
}
}
}