OData MCP Server by CData

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.

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