home / mcp / sage cloud accounting mcp server

Sage Cloud Accounting MCP Server

Provides a read-only MCP server to query live Sage Cloud Accounting data via the CData JDBC Driver.

Installation

Add the following to your MCP client configuration file.

Configuration

{
  "mcpServers": {
    "cdatasoftware-sage-cloud-accounting-mcp-server-by-cdata": {
      "command": "java",
      "args": [
        "-jar",
        "CDataMCP-jar-with-dependencies.jar",
        "sage-cloud-accounting.prp"
      ]
    }
  }
}

You can use this MCP (Model Context Protocol) server to query live Sage Cloud Accounting data through an MCP client. It wraps the CData JDBC Driver to expose Sage Cloud Accounting data as MCP tools, letting you ask natural-language questions and receive live results without writing SQL.

How to use

After you configure the MCP server, you interact with it through an MCP client. You can ask questions like how many Sage Cloud Accounting records meet certain criteria, or compare metrics across accounts and periods. The server exposes a small set of tools you can call implicitly by asking questions, so you don’t need to craft SQL queries.

How to install

Prerequisites you need before starting: a JDK (Java Development Kit) and Maven for building the project.

# Clone the MCP server project
git clone https://github.com/cdatasoftware/sage-cloud-accounting-mcp-server-by-cdata.git
cd sage-cloud-accounting-mcp-server-by-cdata

# Build the server package
mvn clean install

This build creates the runtime JAR file named CDataMCP-jar-with-dependencies.jar. Next, install the CData JDBC Driver for Sage Cloud Accounting and license it following the driver’s instructions, so the MCP server can connect to Sage Cloud Accounting.

Create a JDBC connection properties file (example name sage-cloud-accounting.prp) with your driver details and connection URL. You will reference this PRP file when starting the MCP server.

Run the MCP server by starting the built JAR with the PRP file. The following command uses a placeholder path to the PRP file you created.

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

Additional configuration and notes

The server runs locally and uses stdio, so it is intended to be used with clients running on the same machine. You must fully stop the client and restart it if you add or modify MCP server configurations so that changes take effect.

Available tools

sagecloud_mcp_get_tables

Retrieves a list of all tables available in the Sage Cloud Accounting data source. The output is delivered in CSV format with a header row listing the table names.

sagecloud_mcp_get_columns

Retrieves a list of columns for a specified table. The output is delivered in CSV format with a header row listing the column names.

sagecloud_mcp_run_query

Executes a SQL SELECT query against the connected data source and returns the result set.