home / mcp / reckon accounts hosted mcp server

Reckon Accounts Hosted MCP Server

This read-only MCP Server allows you to connect to Reckon Accounts Hosted data from Claude Desktop through CData JDBC Drivers. For full CRUD support, check out the first managed MCP platform: CData Connect AI (https://www.cdata.com/ai/).

Installation

Add the following to your MCP client configuration file.

Configuration

View docs

{
  "mcpServers": {
    "cdatasoftware-reckon-accounts-hosted-mcp-server-by-cdata": {
      "command": "java",
      "args": [
        "-jar",
        "/PATH/TO/CDataMCP-jar-with-dependencies.jar",
        "/PATH/TO/Salesforce.prp"
      ]
    }
  }
}

You can query live Reckon Accounts Hosted data through an MCP (Model Context Protocol) server that wraps the CData JDBC Driver. This server exposes a simple, read-only MCP interface so you can ask natural language questions and receive up-to-date data without writing SQL.

How to use

You connect an MCP client to the Reckon Accounts Hosted MCP Server and start asking questions about accounts, opportunities, tickets, calendar events, and related data. The server provides a small set of tools to discover available data tables and columns, and to run read queries. You do not need to know SQL; simply request the information you need and the client will handle the rest.

How to install

Prerequisites you need before you begin: a Java Runtime Environment (JRE) suitable for running the MCP server and Maven for building the project.

# Clone the project
git clone https://github.com/cdatasoftware/reckon-accounts-hosted-mcp-server-by-cdata.git
cd reckon-accounts-hosted-mcp-server-by-cdata

# Build the MCP server jar with dependencies
mvn clean install
# This creates the JAR file: CDataMCP-jar-with-dependencies.jar

Additional configuration and runtime notes

You will also need the CData JDBC Driver for Reckon Accounts Hosted and a connection string that points to your data source. The driver must be licensed before use.

License the CData JDBC Driver by running the license command in the driver’s lib directory and providing your name, email, and the license key (TRIAL or your license key).

Configure a JDBC connection using the driver’s connection utility, then save the resulting connection string in a .prp file for the MCP server to use. An example property file structure is shown here (values must be adapted to your environment):

Prefix=reckonaccountshosted
ServerName=CDataReckonAccountsHosted
ServerVersion=1.0
DriverPath=PATH\TO\cdata.jdbc.reckonaccountshosted.jar
DriverClass=cdata.jdbc.reckonaccountshosted.ReckonAccountsHostedDriver
JdbcUrl=jdbc:reckonaccountshosted:InitiateOAuth=GETANDREFRESH;
Tables=

Running the server

To run the MCP server on its own, execute the following command. This example uses a Salesforce.prp file; replace it with your Reckon Accounts Hosted PRP as needed.

java -jar /PATH/TO/CDataMCP-jar-with-dependencies.jar /PATH/TO/Salesforce.prp

Using the server with Claude Desktop or similar clients

Create a client configuration that points to the MCP server. Add an entry for the Reckon Accounts Hosted MCP server to your client’s mcpServers list, supplying the java runtime and the MCP JAR with the PRP file as shown.

{
  "mcpServers": {
    "reckon_accounts_mcp": {
      "command": "PATH\\TO\\java.exe",
      "args": [
        "-jar",
        "PATH\\TO\\CDataMCP-jar-with-dependencies.jar",
        "PATH\\TO\\reckon-accounts-hosted.prp"
      ]
    }
  }
}

Troubleshooting and tips

If you cannot see the MCP server or data in your client, ensure you fully quit and re-open the client after adding or updating the MCP configuration. Double-check that your PRP path and JDBC connection string are correct. If issues persist, verify the PRP file contains a valid DriverPath and JdbcUrl, and confirm your data source permissions allow read access.

Available tools

reckon_accounts_mcp_get_tables

Retrieves a list of tables available in the data source. Output is CSV with column headers on the first line.

reckon_accounts_mcp_get_columns

Retrieves a list of columns for a specific table. Output is CSV with column headers on the first line.

reckon_accounts_mcp_run_query

Executes a SQL SELECT query against the connected data source.