hubspot-mcp-server-by-cdata

What is hubspot-mcp-server-by-cdata?

hubspot-mcp-server-by-cdata is a read-only MCP server from CData that lets LLMs (like Claude Desktop) query live HubSpot data using natural language. It wraps the CData JDBC Driver for HubSpot, which exposes HubSpot data as relational SQL tables, and makes that data available through a simple MCP interface — no SQL required.

How to use hubspot-mcp-server-by-cdata?

Clone the repository, build the JAR with mvn clean install, install and license the CData JDBC Driver for HubSpot, configure a connection string using the driver's utility, create a .prp file with JDBC properties, then add the server to Claude Desktop's claude_desktop_config.json using a java -jar command that points to the JAR and the .prp file.

Key features of hubspot-mcp-server-by-cdata

• Read-only access to HubSpot data via MCP
• Query live data using natural language
• Built on CData JDBC Driver for HubSpot
• Provides get_tables, get_columns, and run_query tools
• Uses stdio transport (same-machine clients only)

Use cases of hubspot-mcp-server-by-cdata

• Ask an LLM "What is the correlation between my closed won opportunities and the account industry?"
• Ask "How many open tickets do I have in the SUPPORT project?"
• Ask "Can you tell me what calendar events I have today?"
• Let non-technical users explore HubSpot data conversationally

FAQ from hubspot-mcp-server-by-cdata

Is this server read-only, or does it support write operations?

This project builds a read-only MCP server. For full read, write, update, delete, and action capabilities, CData offers a free beta version of the CData MCP Server for HubSpot.

What dependencies are required?

You need Java, Maven, and the CData JDBC Driver for HubSpot (which must be downloaded and licensed separately). The driver handles OAuth authentication with HubSpot.

Does the data stay local?

Yes. The server runs on your machine and queries HubSpot directly via the JDBC driver. No data is sent to CData.

What transports or authentication does the server use?

The server uses stdio transport, so it can only be used with clients that run on the same machine. Authentication is handled by the CData JDBC Driver (e.g., OAuth).

What tables or data does the server expose?

By default, all tables available in the HubSpot JDBC driver are exposed. You can limit access by setting the Tables property in the .prp file to a comma-separated list of table names.