sage-cloud-accounting -by-cdata

This MCP server wraps the CData JDBC Driver for Sage Cloud Accounting and exposes the underlying data as an MCP interface. It is read-only by design, allowing LLMs and clients to query live data from Sage Cloud Accounting without requiring SQL proficiency. Once configured, you can use the built-in tools to discover data structures, inspect table schemas, and run read-only queries. The available tools follow a consistent naming pattern based on the server name (for example, sagecloudaccounting_get_tables, sagecloudaccounting_get_columns, sagecloudaccounting_run_query). Use the get_tables tool to fetch available tables, then drill into a table with get_columns to see its columns, and finally execute a SELECT via run_query to retrieve data. The server communicates via JSON-RPC 2.0 style calls over stdio, so it is intended for use with clients running on the same machine as the server.

Prerequisites:

• Java JDK 8+ and Maven
• Access to the Sage Cloud Accounting JDBC driver from CData
• A compatible environment to run the MCP server (Windows/Linux/macOS)

Installation steps:

1. Clone the repository and build:

   git clone https://github.com/cdatasoftware/sage-cloud-accounting-mcp-server-by-cdata.git
   cd sage-cloud-accounting-mcp-server-by-cdata
   mvn clean install
   

   This will produce the MCP jar, e.g. CDataMCP-jar-with-dependencies.jar.

2. Download and install the CData JDBC Driver for Sage Cloud Accounting from: https://www.cdata.com/drivers/sagecloudaccounting/download/jdbc Follow the vendor instructions to install and license the driver.

3. License the JDBC Driver (example paths; adjust to your installation):

   • Windows: C:\Program Files\CData\CData JDBC Driver for Sage Cloud Accounting> java -jar cdata.jdbc.sagecloudaccounting.jar --license
   • macOS/Linux: /Applications/CData JDBC Driver for Sage Cloud Accounting/> java -jar cdata.jdbc.sagecloudaccounting.jar --license Provide your name, email, and a license key if needed.

4. Create the Sage Cloud Accounting MCP prop file (sage-cloud-accounting.prp) with the required properties, for example:

   Prefix=sagecloudaccounting
   ServerName=CDataSageCloudAccounting
   ServerVersion=1.0
   DriverPath=PATH\TO\cdata.jdbc.sagecloudaccounting.jar
   DriverClass=cdata.jdbc.sagecloudaccounting.SageCloudAccountingDriver
   JdbcUrl=jdbc:sagecloudaccounting:InitiateOAuth=GETANDREFRESH;
   Tables=
   

5. Run the MCP server using the generated JAR and the PRP file:

   java -jar CDataMCP-jar-with-dependencies.jar /PATH/TO/sage-cloud-accounting.prp
   

6. Verify the server is discoverable by your MCP client (e.g., Claude Desktop) and connect using the configured classname_dash (e.g., sagecloudaccounting).

Tips and notes:

• This server provides read-only access to Sage Cloud Accounting data via the MCP interface. To enable full read/write capabilities, you would need the non-read-only MCP configuration or different server builds as provided by CData.
• The MCP server uses stdio for communication; ensure your client runs on the same machine or adapt the setup for your environment accordingly.
• When configuring Claude Desktop or similar clients, add the server under the mcpServers section with the appropriate path to your Java executable and the jar/PRP file.
• If you encounter issues seeing the MCP server, fully quit and restart the client, and ensure the Java process is running the correct jar with the correct PRP path. Ensure the Sage Cloud Accounting JDBC driver is licensed and accessible at runtime.
• Environment variables are optional but can be used to expose paths or runtime options. Example: JAVA_TOOL_OPTIONS for JVM tuning or CLOUD_ACCOUNTING_PRP_PATH to override the PRP path.