HubSpot Connector
HubSpot is an integrated inbound marketing, sales, and CRM platform, offering a multitude of tools to captivate, engage, and retain customers.
HubSpotYour warehouseLive
Agent context over MCPSet up in minutes.
No code, no maintenance.
HubSpot
Data source
HubSpot in your warehouse.
Ready for your agents.
HubSpot is an integrated inbound marketing, sales, and CRM platform, offering a multitude of tools to captivate, engage, and retain customers. Weld's HubSpot connector is fully managed: it extracts data from HubSpot, loads it into your warehouse, and keeps it in sync. The data lands in a clean, documented schema with agent context attached, so analysts can query it with SQL or dbt, and agents can query it over the Weld MCP server without guessing at tables or joins.
HubSpot data schema.
The map your agents read.
Every table, field and relationship Weld syncs from HubSpot is served to agents as context over MCP, so they pick the right tables and join on the right keys.
- tables
- 47
- fields
- 1,306
- relationships
- 10
HubSpot models.
What the numbers mean.
Open-source SQL that turns the raw HubSpot tables into the reports people ask about. Deploy them in Weld and your agent queries the definitions, not guesses.
- Company 360One row per company: firmographics, owner, contacts, open and won pipeline, and last touch.grain: one row per company
- Deal activityActivities logged against each deal: counts by type, connected calls, completed meetings, and the first and latest activity.grain: one row per deal with at least one logged activity
- Deal flow by monthDeals created, won and lost per month, per pipeline and owner, with win rate.grain: month x pipeline x owner
- Deal pipelineEvery deal with its pipeline, stage, outcome, owner and primary company.grain: one row per deal
- Deal stage historyEvery stage each deal has been in, when it entered, when it left and how long it stayed.grain: one row per deal x stage entry (a deal that goes back to a stage it already visited gets a second row)
- Rep activityCalls, emails, meetings, notes and tasks logged per owner per day.grain: day x owner
Ask your agent.
It already knows HubSpot.
Connect Claude, Cursor, ChatGPT or your own agent to Weld over MCP. It reads the HubSpot context, finds the tables it needs and queries your warehouse.
- Agent contextHubSpot tables, fields and joins
- QuerySQL against your warehouse
- OperateCheck, rerun and refresh syncs
How many owner rows do we have per owner? Use our HubSpot data.
Reading the HubSpot context first, so the query uses the right tables and keys.
Load HubSpot into any warehouse.
Set up in minutes, no code.
Everything you need.
To get started.
HubSpot setup guide
Step-by-step instructions to configure and start syncing.
MCP serverConnect your agents
Set up Claude, Cursor, ChatGPT or Codex against your Weld workspace.
Weld Connect APIBuild custom connectors
Use the Weld Connect API to build and publish your own connector.
FAQCommon questions
Answers to frequently asked questions about Weld connectors.
Set it up in code.
One REST API.
Use the Weld Connect REST API to create HubSpot connections, configure ELT syncs, and manage pipelines entirely through code. Built for embedding, automation, and CI/CD workflows.
▌Common questions.
About connectors.
Put your HubSpot data to work.
Connect HubSpot, pick a warehouse, and your agents can query it today. Free for 14 days, no credit card.
Source
