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

Volley.sh

Volley

A good sequence diagram can solve almost any communication problem in engineering. Volley lets your agent write them as plain text, with the real request and response payloads on every arrow. It checks its own syntax wi

FastMCP v2 🚀

jlowin

🚀 The fast, Pythonic way to build MCP servers and clients.

26.0K

Yuppsy

Yuppsy MCP: build and publish real estate websites from your AI assistant. Yuppsy lets your AI assistant create live websites for real estate agents and individual property listings. You don't need a designer or any code

Activepieces

activepieces

AI Agents & MCPs & AI Workflow Automation • (~400 MCP servers for AI agents) • AI Automation / AI Agent with MCPs • AI Workflows & AI Agents • MCPs for AI Agents

23.2K

Senso MCP for Joomla

sensomedia

Senso MCP turns a Joomla 5 or 6 site into a remote MCP server. It runs inside Joomla itself (no extra server, no Node.js bridge) and is secured with OAuth 2.1 and Joomla's own ACL. The free pack lets an AI assistant crea

Advertise