Reckon MCP Server by CData
@CDataSoftware
About Reckon 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 Reckon (beta): https://www.cdata.com/download/download.aspx?sku=BAZK-V&type=beta
Basic information
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\\reckon.prp"
]
}
}
}Tools
No tools detected
We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.
Overview
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, andrun_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
.prpfile.
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.
More Other MCP servers
Awesome Mcp Servers
punkpeyeA collection of MCP servers.
Core Philosophy: Connect, Unify, Respond
mindsdbDelegate anything. It comes back done.
🚀 Model Context Protocol (MCP) Curriculum for Beginners
microsoftThis open-source curriculum introduces the fundamentals of Model Context Protocol (MCP) through real-world, cross-language examples in .NET, Java, TypeScript, JavaScript, Rust and Python. Designed for developers, it focuses on practical techniques for building modular, scalable,
Inbox Zero AI
elie222The world's best AI personal assistant for email. Open source app to help you reach inbox zero fast.
FastMCP v2 🚀
jlowin🚀 The fast, Pythonic way to build MCP servers and clients.
Comments