CData MCP Server for Sage 200

Overview

The CData MCP Server for Sage 200 exposes Sage 200 as a toolset accessible to large language models (LLMs) like Claude, using the open Model Context Protocol (MCP). Each connector runs as a lightweight MCP server, enabling AI agents to discover, interpret, and invoke operations on live data — all through natural language.

This connector is designed specifically for tool-based, non-SQL interaction. LLMs use metadata provided by the server to understand and interact with Sage 200 data safely, without requiring SQL queries or traditional prompt engineering.

Key Features

Exposes Sage 200 data to Claude using the Model Context Protocol (MCP).
Supports secure, tool-based interactions — no SQL required.
Runs lightweight MCP server instances per connection.
Built-in support for popular authentication flows.
Seamless local integration with Claude Desktop.

Getting Started

See Getting Started for step-by-step instructions on installing the server, establishing a connection, and configuring Claude Desktop to access Sage 200 data.

Using With Claude

See Using With Claude to learn how Claude Desktop connects to the MCP Server and uses tool metadata to interact with Sage 200 through natural language requests.

Data Model

See Data Model for information on the available entities and how to query them.

Connection String Options

The Connection properties describe the various options that can be used to establish a connection.