Sugar CRM MCP Server by CData

Name: Sugar CRM MCP Server by CData
Author: CDataSoftware

@CDataSoftware

关于 Sugar CRM 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 Sugar CRM (beta): https://www.cdata.com/download/download.aspx?sku=CCZK-V&type=beta

#sugar-crm #mcp-server #cdata

基本信息

分类

数据与分析

传输方式

stdio

发布者

CDataSoftware

提交者

Cameron Leblanc

配置

使用下面的配置,将此服务器添加到你的 MCP 客户端。

{
  "mcpServers": {
    "{classname_dash}": {
      "command": "PATH\\TO\\java.exe",
      "args": [
        "-jar",
        "PATH\\TO\\CDataMCP-jar-with-dependencies.jar",
        "PATH\\TO\\sugar-crm.prp"
      ]
    }
  }
}

工具

未检测到工具

工具是从 README 中自动提取的。维护者可以在 ## Tools 标题下列出工具,即可填充这部分内容。

概览

What is Sugar CRM MCP Server by CData?

Sugar CRM MCP Server by CData is a read-only Model Context Protocol (MCP) server that allows LLMs like Claude Desktop to query live Sugar CRM data using natural language, without SQL. It wraps the CData JDBC Driver for Sugar CRM, which exposes Sugar CRM as relational SQL models.

How to use Sugar CRM MCP Server by CData?

Clone the repository, build with mvn clean install, download and license the CData JDBC Driver for Sugar CRM, then use the Connection String utility to create a JDBC URL. Create a .prp file with connection details (e.g., Prefix, ServerName, DriverPath, DriverClass, JdbcUrl) and configure Claude Desktop’s claude_desktop_config.json to launch the server with java -jar CDataMCP-jar-with-dependencies.jar and the .prp file. The server runs via stdio.

Key features of Sugar CRM MCP Server by CData

Exposes Sugar CRM data via MCP tools for LLMs
Supports natural language queries on live data
Provides get_tables, get_columns, and run_query tools
Leverages the CData JDBC Driver for relational SQL access
Read-only access (full CRUD available in the beta CData MCP Server)
Works with Claude Desktop and other stdio-based MCP clients

Use cases of Sugar CRM MCP Server by CData

Ask an LLM to correlate closed‑won opportunities with account industry
Retrieve the number of open support tickets in a specific project
Query upcoming calendar events from Sugar CRM using plain English
Obtain a list of available tables or columns for ad‑hoc exploration

FAQ from Sugar CRM MCP Server by CData

Is this server read‑only?

Yes, this project builds a read‑only MCP server. For full read, write, update, delete, and action capabilities, CData offers a free beta MCP Server.

What are the system requirements?

You need Java (to run the JAR), Maven (to build), and the CData JDBC Driver for Sugar CRM installed and licensed. The server runs on Windows, Linux, and macOS.

Where does the Sugar CRM data live?

Data is accessed live through the CData JDBC Driver. The server does not store or cache data; all queries execute against the Sugar CRM instance.

Which transport protocol does the server use?

The server uses the stdio transport, so it can only be used with MCP clients running on the same machine as the server.

Do I need to handle OAuth manually?

Many data sources (including Sugar CRM) use OAuth. When testing the connection with the Connection String utility, you will authenticate in your browser. The driver can then refresh tokens automatically (InitiateOAuth=GETANDREFRESH).