home / mcp / sage 50 uk mcp server

Sage 50 UK MCP Server

Provides read-only access to Sage 50 UK data via MCP using the CData JDBC Driver.

Installation

Add the following to your MCP client configuration file.

Configuration

{
  "mcpServers": {
    "cdatasoftware-sage-50-uk-mcp-server-by-cdata": {
      "command": "java",
      "args": [
        "-jar",
        "/PATH/TO/CDataMCP-jar-with-dependencies.jar",
        "/PATH/TO/sage-50-uk.prp"
      ]
    }
  }
}

You can query live Sage 50 UK data through a read-only MCP Server that wraps the CData JDBC Driver. This server exposes Sage 50 UK data via a simple MCP interface so you can ask natural-language questions and receive live results without writing SQL.

How to use

You interact with the Sage 50 UK MCP Server using an MCP client. Start the server on your machine and connect your client to it using the provided MCP configuration. Once connected, you can ask questions about Sage 50 UK data such as balances, open invoices, or customer details. The built-in tools let you fetch table and column information and run queries as needed, but you typically don’t need to invoke them directly. Simply ask your AI assistant to read data (for example, to retrieve a list of customers or summarize sales by period) and the assistant will use the server to fetch the live information.

How to install

Prerequisites: You need Java and Maven installed on your machine.

1. Clone the project and navigate into it.

git clone https://github.com/cdatasoftware/sage-50-uk-mcp-server-by-cdata.git
cd sage-50-uk-mcp-server-by-cdata

2. Build the server to create the JAR file.

mvn clean install

This build process produces the JAR file: CDataMCP-jar-with-dependencies.jar.

3. Download and install the CData JDBC Driver for Sage 50 UK from the driver page.

4. License the CData JDBC Driver.

java -jar cdata.jdbc.sage.jar --license
```
Enter your name, email, and TRIAL (or your license key).

5. Configure your connection string using the Connection String utility.

java -jar cdata.jdbc.sage.jar
```
Configure the connection string and test the connection. Copy the connection string for later use.

6. Create a .prp file for your JDBC connection (e.g. sage-50-uk.prp) with these properties.

Prefix=sage
ServerName=CDataSage
ServerVersion=1.0
DriverPath=PATH\TO\cdata.jdbc.sage.jar
DriverClass=cdata.jdbc.sage.SageDriver
JdbcUrl=jdbc:sage:InitiateOAuth=GETANDREFRESH;
Tables=

7. Place the .prp file where the MCP server can read it and note the path to the Sage PRP file for use in the next steps.

Additional configuration and usage notes

To use Claude Desktop or another MCP client, create a config that points to the MCP server. The server runs on your machine and uses stdio, so the client must be on the same host. The MCP server is started with the Java runtime and the PRP file you created.

If you need to run the server on its own, use the following command.

java -jar /PATH/TO/CDataMCP-jar-with-dependencies.jar /PATH/TO/Salesforce.prp

Note: The server uses stdio, so it can only be used with clients running on the same machine as the server. If you encounter issues, ensure your Claude Desktop client is fully closed and restarted so the MCP server appears, and verify your connection string in the PRP file is correct.

Available tools

sage_mcp_get_tables

Retrieves a list of Sage 50 UK tables available in the data source. Output is provided in CSV format with the first line containing column headers.

sage_mcp_get_columns

Retrieves a list of columns for a specific table. Output is provided in CSV format with the first line containing column headers.

sage_mcp_run_query

Executes a SQL SELECT query against the Sage 50 UK data via the MCP interface.