CData JDBC Driver connects to Salesforce by exposing them as relational SQL models.
CData JDBC Driver connects to Salesforce by exposing them as relational SQL models. That is what the salesforce by cdata mcp server brings to an AI assistant: the same capability, reachable through the Model Context Protocol rather than a separate app or dashboard.
The server publishes 3 tools. What each one is for:
salesforce_get_tables — The salesforce_get_tables tool exposed by this serversalesforce_get_columns — The salesforce_get_columns tool exposed by this serversalesforce_run_query — The salesforce_run_query tool exposed by this serverBecause this one is hosted, setup is mostly authentication — you point your client at the endpoint and approve access. Nothing runs on your machine, so there is no runtime to keep patched.
Configuration is passed through the environment: CDATA_JDBC_URL, CDATA_PREFIX, CDATA_DRIVER_PATH, CDATA_DRIVER_CLASS. Treat anything key-shaped as a real credential — scope it to the minimum the server needs, and rotate it if it ever lands in a shared config.
Plenty of database access servers cover similar ground. The differences that matter in practice are scope of access and how much setup stands between you and a working tool call. Salesforce By Cdata's toolset — salesforce_get_tables, salesforce_get_columns, salesforce_run_query — is a fair guide to whether it matches your workflow. It is maintained by CDataSoftware; worth a glance at recent repository activity before you build anything load-bearing on it.
SyncDev reviews every entry in this directory against the project's own documentation before publishing, and revisits them as servers change.
| Tool | What it does |
|---|---|
| salesforce_get_tables | The salesforce_get_tables tool exposed by this server. |
| salesforce_get_columns | The salesforce_get_columns tool exposed by this server. |
| salesforce_run_query | The salesforce_run_query tool exposed by this server. |
**Linux/Mac**
```json
{
"mcpServers": {
"{classname_dash}": {
"command": "/PATH/TO/java",
"args": [
"-jar",
"/PATH/TO/CDataMCP-jar-with-dependencies.jar",
"/PATH/TO/salesforce.prp"
]
},
...
}
}Configuration as documented by the project. Restart the client after saving.
| Variable | Description | Required |
|---|---|---|
| CDATA_JDBC_URL | Endpoint or connection string the server talks to. | Yes |
| CDATA_PREFIX | Configuration value read at startup. | Optional |
| CDATA_DRIVER_PATH | Filesystem location the server is allowed to use. | Optional |
| CDATA_DRIVER_CLASS | Configuration value read at startup. | Optional |
Your workspace, on speaking terms with AI — search, read and write Notion pages and databases.
Issue tracking at the speed of conversation — Linear's official hosted server with OAuth and zero install.
Search and read your Drive — Docs, Sheets and files become context your assistant can actually use.
Your assistant inside the workspace — read channels, search history, post messages and tame the noise.
Metabase ships its own MCP endpoint — search your BI content, build and run queries, and save questions and dashboards without leaving the chat.
Stop letting your assistant hallucinate n8n node parameters — this server hands it the real schemas, templates and validation.