Advertise
MCP.so
Sign In
S

Sage 200 MCP Server by CData

@CDataSoftware

Repository

Basic information

Category

Other

Transports

stdio

Author

CDataSoftware

Submitted by

Cameron Leblanc

About Sage 200 MCP Server by CData

This project builds a read-only MCP server. For full read, write, update, delete, and action capabilities and a simplified setup, check out our free CData MCP Server for Sage 200 (beta): https://www.cdata.com/download/download.aspx?sku=GGZK-V&type=beta

#sage-200#mcp-server#cdata

Sage 200 MCP Server by CData config

Add this server to your MCP-compatible client using the configuration below.

{
  "mcpServers": {
    "{classname_dash}": {
      "command": "PATH\\TO\\java.exe",
      "args": [
        "-jar",
        "PATH\\TO\\CDataMCP-jar-with-dependencies.jar",
        "PATH\\TO\\sage-200.prp"
      ]
    }
  }
}

Sage 200 MCP Server by CData tools

Tool list not available yet

This listing does not currently have a tool list to display. This does not mean the server has no tools; check its documentation for supported capabilities.

We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.

Overview

What is Sage 200 MCP Server by CData?

Sage 200 MCP Server by CData is a read-only Model Context Protocol (MCP) server that enables large language models (such as Claude Desktop) to query live Sage 200 data using natural language. It wraps the CData JDBC Driver for Sage 200, exposing Sage 200 as relational SQL models through a simple MCP interface, so users can retrieve information without writing SQL.

How to use Sage 200 MCP Server by CData?

Clone the repository, build the JAR with mvn clean install, install and license the CData JDBC Driver for Sage 200, then create a .prp property file with the JDBC connection settings. Configure your client (e.g., Claude Desktop) by adding an MCP server entry in claude_desktop_config.json pointing to the Java executable and the built JAR with the .prp file as an argument. The server uses stdio transport and runs on the same machine as the client.

Key features of Sage 200 MCP Server by CData

  • Provides read-only access to live Sage 200 data via MCP.
  • Exposes tools: get_tables, get_columns, and run_query.
  • Supports natural language queries – no SQL required.
  • Built on the CData JDBC Driver for Sage 200.
  • Uses JSON-RPC 2.0 for tool communication.
  • Open source under the MIT License.

Use cases of Sage 200 MCP Server by CData

  • Ask an LLM to summarize current Sage 200 financial trends.
  • Retrieve inventory levels or order details from Sage 200.
  • Generate reports on sales or purchase transactions without writing SQL.
  • Enable AI assistants to answer questions about Sage 200 data quickly.

Frequently asked questions

1

What is the difference between this server and the CData MCP Server for Sage 200 (beta)?

This server is read-only, while the beta version supports full read, write, update, delete, and action capabilities with a simplified setup.

2

What are the runtime requirements?

Java is required to run the server, and you must install and license the CData JDBC Driver for Sage 200. The server runs on Windows, macOS, or Linux.

3

Where does the Sage 200 data reside?

Data stays in Sage 200; the server queries it live through the JDBC driver. No data is stored by the MCP server itself.

4

What transport protocol does the server use?

The server uses `stdio` transport, so it must run on the same machine as the client (e.g., Claude Desktop).

5

How is authentication handled?

Authentication is configured in the JDBC connection string (e.g., OAuth, username/password) using the CData JDBC Driver’s Connection String utility. The server does not handle authentication directly.

Comments

More Other MCP servers

Reactive Resume

amruthpillai

A one-of-a-kind resume builder that keeps your privacy in mind. Completely secure, customizable, portable, open-source and free forever. Try it out today!

39.5K

Handl

Handl speaks the Model Context Protocol. Your whole billing operation — projects, invoices, clients, reports, approvals — as tools any AI assistant can call, inside your autonomy rules.

P

PickFu MCP

PickFu MCP is a Model Context Protocol (MCP) server that connects AI assistants, developers, marketers, product managers, and AI agents to PickFu's consumer research platform. It enables users to create surveys, conduct

Screenpipe

screenpipe

YC (S26) | Open Computer History | Continuously record your company computer work, map your workflows, help you find work worth automating, and power your agents' context

22.0K

Blender

ahujasid

Open-source MCP to use Blender with any LLM

23.6K
Advertise