reckonaccountshosted_get_tablesLABSCO SUMMARY
Read-only by construction.
Three tools and no write path is the whole design: the model discovers tables, reads columns and runs SELECTs, so a badly framed question produces a wrong answer rather than a changed record. Two things decide whether it fits. The CData JDBC driver is a separate licensed product, with a trial key to start on. And the assistant can query every table the connection can see — the Tables field in the connection profile does not narrow that, so limit the connection or the account it signs in with.
What it is
A read-only MCP server built on CData's JDBC Driver for Reckon Accounts Hosted. The driver exposes Reckon Accounts Hosted as relational tables; the server puts three tools over it, so a client can discover what tables exist, read a table's columns, and run a SELECT — without anyone writing SQL by hand.
What you get
- The tables the driver exposes for Reckon Accounts Hosted, returned as CSV with a header row —
reckonaccountshosted_get_tables - The columns of one of those tables, also as CSV, so a query can be composed against real field names —
reckonaccountshosted_get_columns - A SQL SELECT executed against live Reckon Accounts Hosted data —
reckonaccountshosted_run_query - Tool names that carry the prefix you set in the connection profile — the sample uses
Prefix=reckonaccountshosted— so several CData servers can run side by side without colliding - A
Tablessetting that only picks which tables also get a ready-made description (blank means none); it does not limit what the tools can list or query, so limit the connection or the account it signs in with
Requirements
Java and Maven to build — mvn clean install produces CDataMCP-jar-with-dependencies.jar. The CData JDBC Driver for Reckon Accounts Hosted is a separate download and needs licensing: run java -jar cdata.jdbc.reckonaccountshosted.jar --license and enter a name, an email and either TRIAL or a licence key. Connection settings go in a .prp file carrying Prefix, ServerName (the sample uses CDataReckonAccountsHosted), ServerVersion, DriverPath, DriverClass (cdata.jdbc.reckonaccountshosted.ReckonAccountsHostedDriver), the JdbcUrl produced by the driver's connection-string utility, and the optional Tables list. The client then launches java -jar CDataMCP-jar-with-dependencies.jar <YOUR_PRP_FILE>.prp. Transport is stdio, so the server has to run on the same machine as the client. If the data source authenticates over OAuth, you approve it in a browser while building the connection string.
Setup effort
Build from source — clone the repository, then point your client at the binary
USE CASES
01
Asking accounting questions in plain language
Ledger, receivable and payable data arrive as tables, so a question about balances becomes a SELECT the client writes.
02
Pulling a figure into a report you are drafting
Read a live number mid-conversation rather than switching applications to look it up.
03
Seeing which entities the driver exposes
List the tables available and read one table's columns before designing a query.
04
Reading finance data without write risk
There is no write path, so an assistant can report on the ledger without being able to post to it.
3 tools
Listed in project docs. Your client may show a different list.
reckonaccountshosted_get_columnsreckonaccountshosted_run_queryBEFORE YOU INSTALL
What to know first
Tools you get
3 tools named in the project's documentation. Tool names start with the Prefix in the .prp file, so the README's Prefix=reckonaccountshosted gives reckonaccountshosted_get_tables, reckonaccountshosted_get_columns and reckonaccountshosted_run_query.
Where it runs
Both documented setups run the server on your machine.
INSTALLATION
Connect your client
Clone the repository, then point your client at the binary. This one is built from source rather than installed with a single command.
Server setup
TERMINAL
git clone https://github.com/cdatasoftware/reckon-accounts-hosted-mcp-server-by-cdata.git
cd reckon-accounts-hosted-mcp-server-by-cdata
mvn clean installDownload and install the CData JDBC Driver for Reckon Accounts Hosted from https://www.cdata.com/drivers/reckonaccountshosted/download/jdbc
License the driver: from the driver install's lib folder run java -jar cdata.jdbc.reckonaccountshosted.jar --license, then enter your name, email, and "TRIAL" (or your license key)
Build the connection string: run java -jar cdata.jdbc.reckonaccountshosted.jar to open the Connection String utility, click "Test Connection" (browser OAuth if the source needs it), and copy the connection string
Create reckon-accounts-hosted.prp with:
FILE · reckon-accounts-hosted.prp
Prefix=reckonaccountshosted
ServerName=CDataReckonAccountsHosted
ServerVersion=1.0
DriverPath=<YOUR_DRIVER_PATH>
DriverClass=cdata.jdbc.reckonaccountshosted.ReckonAccountsHostedDriver
JdbcUrl=<YOUR_JDBC_URL>
Tables=Tables only picks which tables also get a ready-made description for your assistant, and empty means none; the server can still list and query every table your connection string reaches, so to keep data out of reach, limit that connection or the account it signs in with.
Add the mcpServers entry (block below) to claude_desktop_config.json, then fully quit and re-open the client
MCP Clients
Claude Desktop — Windows, macOS or Linux
JSON
{
"mcpServers": {
"reckon-accounts-hosted": {
"command": "<YOUR_PATH_TO_JAVA>",
"args": [
"-jar",
"<YOUR_PATH_TO_CDATA_MCP_JAR_WITH>",
"<YOUR_PATH_TO_RECKON_ACCOUNTS_HOSTED>"
]
}
}
}