home / mcp / hubspot mcp server

HubSpot MCP Server

This read-only MCP Server allows you to connect to HubSpot data from Claude Desktop through CData JDBC Drivers. For full CRUD support, check out the first managed MCP platform: CData Connect AI (https://www.cdata.com/ai/).

Installation

Add the following to your MCP client configuration file.

Configuration

View docs

{
  "mcpServers": {
    "cdatasoftware-hubspot-mcp-server-by-cdata": {
      "command": "PATH\\TO\\java.exe",
      "args": [
        "-jar",
        "PATH\\TO\\CDataMCP-jar-with-dependencies.jar",
        "PATH\\TO\\hubspot.prp"
      ]
    }
  }
}

You can query live HubSpot data through a local MCP server that wraps the CData JDBC Driver. This server exposes a simple MCP interface so you can ask natural language questions and retrieve up-to-date HubSpot data without writing SQL. It’s designed for read-only access when used locally, making it easy to power AI assistants with live information from HubSpot.

How to use

You will run an MCP server locally and connect your AI client (such as Claude Desktop) to it. The server presents a small set of tools that let you discover what data you can access and run queries against HubSpot data. Start by configuring the MCP server and then load it into your client. Once connected, you can ask questions like “What is the correlation between won opportunities and account industry?” or “How many open tickets do I have in a given project?” The client will use the built-in tools to fetch data and answer your questions without exposing raw SQL to you.

How to install

Prerequisites: you need a Java runtime and a Java build tool to compile and run the MCP server. You will also install the CData JDBC Driver for HubSpot and create a property file that points to your HubSpot connection.

Step 1: Build the MCP server from source code.

Additional sections

Configuration, security, troubleshooting, and practical notes are provided to help you deploy and use the server with confidence. You will learn how to prepare your HubSpot connection, start the MCP server locally, and connect clients to browse and query data safely.

Notes on security and troubleshooting

Keep your HubSpot connection credentials secure. If you encounter issues, ensure you fully restart your client so new MCP servers populate, verify the connection string in your .prp file, and consult the CData support resources if problems persist.

Available tools

hubspot_get_tables

Retrieves a list of tables available in the HubSpot data source. The output is returned as CSV with a header row.

hubspot_get_columns

Retrieves a list of columns for a specified table. The output is returned as CSV with a header row.

hubspot_run_query

Executes a SQL SELECT query against HubSpot data and returns the results.