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.
S
Sage 300 MCP Server by CData
@CDataSoftware
基本信息
关于 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 by CData 配置
使用下面的配置,将此服务器添加到你的 MCP 客户端。
{
"mcpServers": {
"{classname_dash}": {
"command": "PATH\\TO\\java.exe",
"args": [
"-jar",
"PATH\\TO\\CDataMCP-jar-with-dependencies.jar",
"PATH\\TO\\sage-300.prp"
]
}
}
}Sage 300 MCP Server by CData 工具
工具列表暂未提供
当前收录暂时没有可展示的工具列表，不代表服务没有工具。请查阅项目文档了解支持的能力。
工具是从 README 中自动提取的。维护者可以在 ## Tools 标题下列出工具,即可填充这部分内容。
概览
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
常见问题
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.
其他 分类下的更多 MCP 服务器
Volley.sh
VolleyA 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
Screenpipe
screenpipeYC (S26) | Open Computer History | Continuously record your company computer work, map your workflows, help you find work worth automating, and power your agents' context
22.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
ICSS
chokcoco不止于 CSS
20.7K
Health by Dr Brad
Dr Brad StanfieldHealth by Dr Brad works out a health plan from your own results: which screening is due at your age, and evidence-based suggestions, each with the reason and the published guideline or study behind it. Your record is one
评论