Reckon MCP Server by CData

What is Reckon MCP Server by CData?

Reckon MCP Server by CData is a read-only Model Context Protocol (MCP) server that allows LLMs like Claude Desktop to query live data from Reckon using natural language questions. It is built on the CData JDBC Driver for Reckon, which exposes Reckon data as relational SQL models.

How to use Reckon MCP Server by CData?

Clone the repository, build with mvn clean install, install and license the CData JDBC Driver for Reckon, configure a .prp file with connection details, then add the server to your client’s claude_desktop_config.json using the built JAR file and the .prp file. The server runs over stdio and must be started on the same machine as the client.

Key features of Reckon MCP Server by CData

• Read-only access to live Reckon data via natural language.
• Exposes three tools: get_tables, get_columns, and run_query.
• Uses CData JDBC Driver for Reckon under the hood.
• No manual SQL required—LLMs handle query generation.
• Supports all tables and columns via configurable .prp file.

Use cases of Reckon MCP Server by CData

• Ask an AI assistant questions about Reckon data without coding.
• Explore Reckon schema live (tables and columns).
• Run ad-hoc read queries from connected AI clients.
• Integrate Reckon data into AI-driven dashboards or reports.

FAQ from Reckon MCP Server by CData

Is this server read-only?

Yes. The README explicitly states it is a read-only MCP server. For full read, write, update, delete, and action capabilities, CData offers a separate beta server.

What dependencies are required?

Java (to run the JAR), Maven (to build), and the CData JDBC Driver for Reckon (must be installed and licensed). The server runs locally and communicates over stdio.

Where does the data live?

Data stays in Reckon. The server connects to your Reckon instance via the JDBC driver and retrieves live data each time a tool is called.

What transport does the server use?

The server uses stdio as its transport. It can only be used with clients running on the same machine.

How do I authenticate to Reckon?

Authentication is handled through the JDBC connection string, which may include OAuth flows. The README notes that for OAuth-based sources, you will need to authenticate in your browser during configuration.