cdata-jdbc

This MCP server exposes a read-only interface to CData JDBC-backed sources. After starting the server, clients (such as Claude Desktop or custom JSON-RPC clients) can query the connected data sources using the built-in MCP tools. The available tools follow the pattern {servername}_get_tables, {servername}_get_columns, and {servername}_run_query, where {servername} is the configured server name (e.g., cdata-jdbc). For example, to list tables in your data source you would call cdata-jdbc_get_tables, then drill down to specific columns with cdata-jdbc_get_columns, and finally execute a SELECT query via cdata-jdbc_run_query. The server communicates via JSON-RPC over STDIN/STDOUT, so it is intended to run on the same machine as your client software. Use the provided PRP file (the .prp) to configure the JDBC driver connection to your data source, including the driver path, connection string, and any required authentication. When integrating with Claude Desktop, add an entry to your claude_desktop_config.json under mcpServers with the appropriate command and arguments to launch the MCP JAR using the prepared PRP file.

Prerequisites:

• Java runtime (JRE/JDK) installed and available on PATH
• Maven installed for building the MCP server
• Access to a CData JDBC Driver for your data source (license as required)

Step-by-step:

1. Clone the repository and build

   • git clone https://github.com/cdatasoftware/cdata-jdbc-mcp-server.git
   • cd cdata-jdbc-mcp-server
   • mvn clean install
   • This builds the MCP JAR: CDataMCP-jar-with-dependencies.jar

2. Obtain and license the JDBC driver

   • Download your JDBC driver for the target data source from CData (e.g., Salesforce, etc.).
   • Apply the license using the driver's license utility per the vendor instructions.

3. Create a PRP configuration for your data source (example Salesforce.prp)

   • Use the following properties as a template and customize paths and values: Prefix=salesforce ServerName=CDataSalesforce ServerVersion=1.0 DriverPath=PATH/TO/cdata.jdbc.salesforce.jar DriverClass=cdata.jdbc.salesforce.SalesforceDriver JdbcUrl=jdbc:salesforce:InitiateOAuth=GETANDREFRESH; Tables=

4. Run the MCP server with the PRP

   • java -jar /PATH/TO/CDataMCP-jar-with-dependencies.jar /PATH/TO/Salesforce.prp
   • Note: The server uses stdio, so it must run on the same machine as the client.

5. Optional: configure Claude Desktop (or other clients) to connect to the running MCP server using the explicit command and PRP path in the mcpServers configuration.

Tips and common issues:

• The MCP server uses standard I/O; ensure your client on the same machine can communicate with the process.
• If the MCP server does not appear in Claude Desktop, fully quit and restart Claude Desktop after starting the server.
• When configuring connections, use the JDBC driver's connection utility to generate a valid connection string, then embed that into the PRP (JdbcUrl field).
• Ensure the Java process has sufficient memory; adjust -Xmx as needed via JAVA_OPTS in the mcp_config.env or your startup script.
• The example tools produce CSV output for tables/columns; queries should be standard SQL SELECT statements compatible with the underlying JDBC driver.
• Replace placeholder paths in the mcp_config with real paths to the JAR and PRP file before running.