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
コメント