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.
@CDataSoftware
Basic information
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
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"
]
}
}
}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.
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.
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.
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.
Java, Maven, and the CData JDBC Driver for Sage 300 (which must be downloaded and licensed separately).
The server uses stdio transport, so it must run on the same machine as the MCP client (e.g., Claude Desktop).
If the Sage 300 data source uses OAuth, you will need to authenticate in your browser during the connection string setup step.
Refer to the Troubleshooting section in the README or contact the CData Support Team or the CData Community.

Model Context Protocol Servers
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

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
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!

See and control a real Windows PC you own — from any MCP client, locally or remotely. Observe (UIA + screenshots), click/type/drag/scroll, launch apps, owner Live View. BYOH: your machine, your key.
Comments