CData MYOB AccountRight

What it is

A local, read-only MCP server from CData that wraps the CData JDBC Driver for MYOB AccountRight. The driver presents MYOB AccountRight as relational SQL models; the server turns those models into three tools, so a client can ask questions about live accounting data without anyone writing SQL by hand.

What you get

• The list of tables the driver exposes for your MYOB AccountRight connection, returned as CSV with a header row — myobaccountright_get_tables
• Column listings for any of those tables, again as CSV with headers — myobaccountright_get_columns
• SQL SELECT execution against the live connection — myobaccountright_run_query
• A Tables setting 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

A licensed CData JDBC Driver for MYOB AccountRight — run java -jar cdata.jdbc.myobaccountright.jar --license and enter TRIAL or your key. Java and Maven, since the server is built with mvn clean install into CDataMCP-jar-with-dependencies.jar. A .prp file carrying Prefix, ServerName, ServerVersion, DriverPath, DriverClass and JdbcUrl, passed as the jar's argument. MYOB AccountRight uses OAuth, so the first connection is authenticated in a browser. Transport is stdio, so the client must run on the same machine.

Setup effort

Build from source — clone the repository, then point your client at the binary

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=myobaccountright gives myobaccountright_get_tables, myobaccountright_get_columns and myobaccountright_run_query. All three only read: run_query executes SELECT, even though one sentence in the README promises writes.

Where it runs

Both documented setups run the server on your machine.