Sage 200 MCP Server by CData

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.

FAQ from Sage 200 MCP Server by CData

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.

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.

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.

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).

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.