json-mcp-server-by-cdata
If you are the rightful owner of json-mcp-server-by-cdata and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.
CData's Model Context Protocol (MCP) Server for JSON is a read-only server designed to allow LLMs to query live JSON data using the CData JDBC Driver for JSON.
The CData MCP Server for JSON is a read-only server that enables large language models (LLMs) to query live JSON data. It leverages the CData JDBC Driver for JSON, which exposes JSON data as relational SQL models. This server wraps the driver, providing a simple MCP interface that allows LLMs to retrieve live information through natural language queries, eliminating the need for SQL knowledge. The server is particularly useful for applications like Claude Desktop, where users can interact with JSON data using natural language. The setup involves cloning the repository, building the server, licensing the JDBC driver, configuring the connection, and creating a property file for the JDBC connection. Once configured, the server can be integrated with platforms like Claude Desktop to facilitate data interaction.
Features
- Read-only access to JSON data through MCP interface.
- Integration with CData JDBC Driver for JSON.
- Natural language querying without SQL.
- Support for various data sources via JDBC.
- Configurable connection settings for different data sources.
Tools
{servername}_get_tables
Get a list of available tables in the data source
{servername}_get_columns
Get a list of available columns in the table
{servername}_run_query
Execute SQL SELECT query
