OData MCP Server by CData

Name: OData MCP Server by CData
Author: CDataSoftware

@CDataSoftware

关于 OData MCP Server by CData

This project builds a read-only MCP server. For full read, write, update, delete, and action capabilities and a simplified setup, check out our free [CData MCP Server for OData (beta)](https://www.cdata.com/download/download.aspx?sku=RDZK-V&type=beta).

#odata #mcp #server #cdata

基本信息

分类

其他

传输方式

stdio

发布者

CDataSoftware

提交者

Cameron Leblanc

配置

使用下面的配置,将此服务器添加到你的 MCP 客户端。

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

工具

未检测到工具

工具是从 README 中自动提取的。维护者可以在 ## Tools 标题下列出工具,即可填充这部分内容。

概览

What is OData MCP Server by CData?

OData MCP Server by CData is a read-only Model Context Protocol (MCP) server that uses the CData JDBC Driver for OData to expose OData data sources as relational SQL models. It allows LLMs like Claude Desktop to query live OData data using natural language questions without writing SQL.

How to use OData MCP Server by CData?

Clone the repository, build the JAR with Maven, install and license the CData JDBC Driver for OData, then configure a .prp file with the JDBC connection string and other properties. Add the server to your client’s config (e.g., Claude Desktop’s claude_desktop_config.json) using a java -jar command that points to the JAR and the .prp file. The server runs over stdio and must be on the same machine as the client.

Key features of OData MCP Server by CData

Read-only SQL querying of live OData sources via natural language
Schema exploration with get_tables and get_columns tools
Execute SQL SELECT queries using the run_query tool
Uses stdio transport for local client integration
Supports hundreds of data sources through the CData JDBC Driver

Use cases of OData MCP Server by CData

Ask an LLM to find correlations between closed won opportunities and account industry
Query the number of open support tickets in a specific project
Retrieve today’s calendar events from an OData-enabled source
Explore table and column schemas without writing SQL

FAQ from OData MCP Server by CData

What is the difference between this server and the CData MCP Server for OData (beta)?

This server is read-only (supports only SQL SELECT queries). The beta version offers full read, write, update, delete, and action capabilities.

What are the prerequisites for using OData MCP Server by CData?

You need Java, Maven, the CData JDBC Driver for OData (installed and licensed), and a .prp file with your JDBC connection string, driver path, and other properties.