Sugar CRM MCP Server by CData
@CDataSoftware
About 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
Basic information
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\\sugar-crm.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 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, andrun_querytools - 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).
More Data & Analytics MCP servers
🎓 Semantic Scholar MCP Server
JackKuo666🔍 This project implements a Model Context Protocol (MCP) server for interacting with the Semantic Scholar API. It provides tools for searching papers, retrieving paper and author details, and fetching citations and references.
Web3 Research MCP
aaronjmarsDeep Research for crypto - free & fully local
🪐✨ Jupyter MCP Server
datalayer🪐 🔧 Model Context Protocol (MCP) Server for Jupyter.
HubSpot MCP Server
baryhuangA Model Context Protocol (MCP) server that enables AI assistants to interact with HubSpot CRM data, providing built-in vector storage and caching mechanisms help overcome HubSpot API limitations while improving response times.
MCP Deep Web Research Server (v0.3.0)
qpd-vEnhanced MCP server for deep web research
Comments