OData MCP Server by CData

@CDataSoftware

代码仓库

基本信息

分类

其他

传输方式

stdio

作者

CDataSoftware

提交者

Cameron Leblanc

关于 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

OData MCP Server by CData 配置

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

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

OData MCP Server by CData 工具

工具列表暂未提供

当前收录暂时没有可展示的工具列表，不代表服务没有工具。请查阅项目文档了解支持的能力。

工具是从 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

常见问题

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.

How do I connect to my OData source?

Use the CData JDBC Driver’s Connection String utility to configure and test the connection, then copy the resulting JDBC URL into your .prp file.

Can OData MCP Server by CData modify my data?

No. It is read-only; only SELECT queries can be executed via the `run_query` tool.

What transport does OData MCP Server by CData use?

It uses `stdio` transport, so the server must run on the same machine as the

其他分类下的更多 MCP 服务器

Soar Flight Booking MCP

Soar Flight Booking MCP is a remote MCP server available at https://mcp.soar.flights.

Handl

Handl speaks the Model Context Protocol. Your whole billing operation — projects, invoices, clients, reports, approvals — as tools any AI assistant can call, inside your autonomy rules.

Volley.sh

Volley

A good sequence diagram can solve almost any communication problem in engineering. Volley lets your agent write them as plain text, with the real request and response payloads on every arrow. It checks its own syntax wi

Sequential Thinking

modelcontextprotocol

Model Context Protocol Servers

88.2K

The Living Bread

A free remote MCP server for The Living Bread. Bible passages read word for word from a stored public domain text with an evidence label, keyword search and cross references, real churches, gatherings and prayer groups w