Advertise
MCP.so
Sign In
O

OData MCP Server by CData

@CDataSoftware

Repository

Basic information

Category

Other

Transports

stdio

Author

CDataSoftware

Submitted by

Cameron Leblanc

About 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 config

Add this server to your MCP-compatible client using the configuration below.

{
  "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 tools

Tool list not available yet

This listing does not currently have a tool list to display. This does not mean the server has no tools; check its documentation for supported capabilities.

We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.

Overview

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

Frequently asked questions

1

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.

2

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.

3

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.

4

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.

5

What transport does OData MCP Server by CData use?

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

Comments

More Other MCP servers

DeepMark

DeepMark helps teachers deliver rapid, consistent marking with meaningful feedback for every student — in a fraction of the time. What once took a week, now takes one free period.

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.

YOUB

Connect your AI assistant to your own YOUB endurance training account. Read recorded activities with full analysis, planned sessions, race goals, wellness (HRV, sleep, resting HR) and your athletic profile. Create or mov

P

PickFu MCP

PickFu MCP is a Model Context Protocol (MCP) server that connects AI assistants, developers, marketers, product managers, and AI agents to PickFu's consumer research platform. It enables users to create surveys, conduct

ICSS

chokcoco

不止于 CSS

20.7K
Advertise