This MCP server exposes MYOB AccountRight data via a read-only MCP interface built on top of the CData JDBC driver. It wraps the CDataMCP JAR and serves data through simple tools that let you discover tables, inspect columns, and run read-only queries against your MYOB AccountRight data source. The built-in tools are named after your server entry (for example, {servername}_get_tables, {servername}_get_columns, and {servername}_run_query). You can interact with the server through Claude Desktop or your own JSON-RPC client by pointing to the server JAR and passing the generated .prp config file that connects to your data source. Typical usage is to first list available tables, then inspect columns, and finally run SELECT queries to retrieve the data you need for analysis. Since this setup is read-only, you’ll be querying existing data without making changes. The JSON-RPC payload examples provided in the README illustrate how to call the tools and retrieve results in CSV for tables and columns, or in tabular form for query results.

Prerequisites: Java (JDK) installed, Maven installed for building the MCP server, and access to the CData JDBC Driver for MYOB AccountRight. Steps:

1. Clone the repository and navigate into it bash git clone https://github.com/cdatasoftware/myob-accountright-mcp-server-by-cdata.git cd myob-accountright-mcp-server-by-cdata

2. Build the MCP server JAR bash mvn clean install

   This creates CDataMCP-jar-with-dependencies.jar in the target directory

3. Install and configure the CData JDBC Driver for MYOB AccountRight

   • Download from: https://www.cdata.com/drivers/myobaccountright/download/jdbc
   • Install the driver on your system (follow the vendor instructions)
   • License the driver if required (via the driver’s license utility)

4. Create a .prp configuration file for the JDBC connection (example: myob-accountright.prp)

   • Include Prefix, ServerName, ServerVersion, DriverPath, DriverClass, and JdbcUrl as described in the README
   • Save the file at a path you will reference from the MCP server command

5. Run the MCP server bash java -jar /PATH/TO/CDataMCP-jar-with-dependencies.jar /PATH/TO/myob-accountright.prp

Tip: The server uses stdio, so it’s intended to be used with clients running on the same machine. If you need Claude Desktop integration, ensure Claude Desktop is configured with the appropriate claude_desktop_config.json referencing the same JAR and .prp file.

Notes and tips:

• This MCP server is read-only by design; it exposes data via SQL-like tables and columns but does not support write or delete operations through the MCP interface.
• The server runs via standard input/output (stdio), so client applications must run on the same host.
• Ensure the path placeholders in your prp and the JAR path in the command are correctly set for your environment.
• If you modify the prp or connection details, restart the MCP server to pick up changes.
• When using Claude Desktop or similar clients, you may need to fully quit and re-launch the client for MCP servers to appear.
• For OAuth-based data sources, you may be prompted to authenticate during the JDBC connection setup; complete the authentication flow in your browser as required.