cdata-jdbc-mcp-server (read-only)

What is cdata-jdbc-mcp-server (read-only)?

cdata-jdbc-mcp-server (read-only) is a read-only Model Context Protocol (MCP) server that wraps CData JDBC Drivers. It enables LLMs (like Claude Desktop) to query live data from over 300+ SaaS apps, NoSQL stores, and APIs via natural language, without requiring SQL.

How to use cdata-jdbc-mcp-server (read-only)?

Clone the repository, build with Maven (mvn clean install), install and license a CData JDBC Driver, configure the connection string using the driver’s utility, create a .prp file with JDBC properties, then add the server to your MCP client’s config (e.g., claude_desktop_config.json). The server uses stdio transport and must run on the same machine as the client.

Key features of cdata-jdbc-mcp-server (read-only)

• Read-only MCP server wrapping any CData JDBC Driver
• Access to over 300+ data sources (SaaS, NoSQL, APIs)
• Tools: get_tables, get_columns, run_query (prefixed by server name)
• Queries live data via natural language, no SQL needed
• Configured via a single .prp file with JDBC connection details

Use cases of cdata-jdbc-mcp-server (read-only)

• Ask an AI about correlations between Salesforce opportunities and account industry
• Query the number of open tickets in a project (e.g., SUPPORT)
• Retrieve today’s calendar events from a data source
• Explore available tables and columns in any supported backend

FAQ from cdata-jdbc-mcp-server (read-only)

What is cdata-jdbc-mcp-server (read-only) and how does it differ from the full CData MCP Servers?

This server is read-only, allowing only queries. For full read, write, update, delete, and action capabilities, the free CData MCP Servers (beta) offers simplified setup.

What data sources are supported?

Over 300+ sources are supported via CData JDBC Drivers, including Salesforce, Google Analytics, Snowflake, SAP, SQL Server, and many more. See the “Supported Sources” table in the README.

How do I configure the server for my data source?

Download and license the appropriate CData JDBC Driver, use its Connection String utility to build a connection string, then create a .prp file with entries for Prefix, ServerName, ServerVersion, DriverPath, DriverClass, JdbcUrl, and Tables. The server reads this file at startup.

Why can’t I see the server in Claude Desktop after configuration?

Fully quit Claude Desktop (use Task Manager on Windows, Activity Monitor on Mac) and reopen it. The server uses stdio transport, so it must be launched from the Claude config and run on the same machine.

What transport does cdata-jdbc-mcp-server (read-only) use?

The server uses stdio transport and can only be used with clients running on the same machine.