MCP.so
Sign In
S

Sage 300 MCP Server by CData

@CDataSoftware

Repository

About Sage 300 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 300 (beta): https://www.cdata.com/download/download.aspx?sku=GTZK-V&type=beta

#sage-300#mcp-server#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-300.prp"
      ]
    }
  }
}

Tools

No tools detected

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

Overview

What is Sage 300 MCP Server by CData?

Sage 300 MCP Server by CData is a read-only Model Context Protocol server that lets LLMs (such as Claude Desktop) query live data from Sage 300 through the CData JDBC Driver. It exposes Sage 300 data as relational SQL models, enabling natural language questions without SQL.

How to use Sage 300 MCP Server by CData?

Clone the repository, build with Maven, install and license the CData JDBC Driver for Sage 300, configure a connection string using the driver’s utility, create a .prp file with JDBC properties, and add the server to your client’s MCP configuration (e.g., claude_desktop_config.json). Once connected, the LLM can use tools like {prefix}_get_tables, {prefix}_get_columns, and {prefix}_run_query to explore and query data.

Key features of Sage 300 MCP Server by CData

  • Read-only access to Sage 300 data via MCP
  • Powered by the CData JDBC Driver for Sage 300
  • Exposes tables, columns, and SQL queries as MCP tools
  • LLMs can ask questions in natural language
  • Uses stdio transport (client and server on same machine)
  • MIT licensed

Use cases of Sage 300 MCP Server by CData

  • Ask an LLM for live Sage 300 reports (e.g., open tickets, opportunity correlations)
  • Discover available tables and columns in Sage 300
  • Run ad‑hoc SELECT queries against Sage 300 data
  • Integrate Sage 300 analytics into AI‑powered assistants

FAQ from Sage 300 MCP Server by CData

Is Sage 300 MCP Server by CData read‑only or full CRUD?

It is read‑only. The project explicitly builds a read‑only MCP server. For full read/write/update/delete capabilities, CData offers a separate MCP Server beta.

What dependencies are required to run the server?

Java, Maven, and the CData JDBC Driver for Sage 300 (which must be downloaded and licensed separately).

How does the server communicate with the client?

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

Does the connection setup involve OAuth?

If the Sage 300 data source uses OAuth, you will need to authenticate in your browser during the connection string setup step.

Where can I get help if something goes wrong?

Refer to the Troubleshooting section in the README or contact the CData Support Team or the CData Community.

Frequently asked questions

Is Sage 300 MCP Server by CData read‑only or full CRUD?

It is read‑only. The project explicitly builds a read‑only MCP server. For full read/write/update/delete capabilities, CData offers a separate MCP Server beta.

What dependencies are required to run the server?

Java, Maven, and the CData JDBC Driver for Sage 300 (which must be downloaded and licensed separately).

How does the server communicate with the client?

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

Does the connection setup involve OAuth?

If the Sage 300 data source uses OAuth, you will need to authenticate in your browser during the connection string setup step.

Where can I get help if something goes wrong?

Refer to the Troubleshooting section in the README or contact the CData Support Team or the CData Community.

Comments

Basic information

Category

Other

Transports

stdio

Author

CDataSoftware

Submitted by

Cameron Leblanc

More Other MCP servers

Inbox Zero AI MCP

elie222

The world's best AI personal assistant for email. Open source app to help you reach inbox zero fast.

11.6K

MCP Go 🚀

mark3labs

A Go implementation of the Model Context Protocol (MCP), enabling seamless integration between LLM applications and external data sources and tools.

8.9K

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

Sequential Thinking

modelcontextprotocol

Model Context Protocol Servers

88.2K

IDA Pro MCP

mrexodia

AI-powered reverse engineering assistant that bridges IDA Pro with language models through MCP.

9.9K