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

Name: cdata-jdbc-mcp-server (read-only)
Author: CDataSoftware

@CDataSoftware

cdata-jdbc-mcp-server (read-only) について

This read-only MCP Server allows you to connect to external data from Claude Desktop through CData JDBC Drivers. Free (beta) read/write servers available at

基本情報

カテゴリ

その他

ライセンス

MIT license

ランタイム

java

トランスポート

stdio

公開者

CDataSoftware

投稿者

Jerod Johnson

設定

以下の設定を使って、このサーバーを MCP 対応クライアントに追加してください。

{
  "mcpServers": {
    "salesforce": {
      "command": "PATH\\TO\\java.exe",
      "args": [
        "-jar",
        "PATH\\TO\\CDataMCP-jar-with-dependencies.jar",
        "PATH\\TO\\PROPERTY_FILE"
      ]
    }
  }
}

ツール

ツールは検出されませんでした

ツールは README から自動的に抽出されます。メンテナーは ## Tools という見出しの下に記載することで、このタブに反映できます。

概要

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.