HubSpot Connector

HubSpot is an integrated inbound marketing, sales, and CRM platform, offering a multitude of tools to captivate, engage, and retain customers.

Start for free View documentation

4.8 on G2

Weld · Data Sources

HubSpot

HubSpotYour warehouseLive

contact4 columnsSynced

deal5 columnsSynced

company5 columnsSynced

engagement25 columnsSyncing

ticket5 columnsQueued

Lands in

snowflake

bigquery

databricks

Agent context over MCP

How it works

Set up in minutes.
No code, no maintenance.

HubSpot

HubSpot

Data source

Authenticating...

Ready to connect

Overview

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.

Agent context

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: 61
fields: 534
relationships: 38

Loading diagram…

pipeline_stages

metadata_isClosed

metadata_ticketState

metadata_probability

internal_write_only

ticket_engagement

engagement_meeting

internal_meeting_notes

attendee_owner_ids

meeting_outcome

pre_meeting_prospect_reminders

deal_engagement

service_subscription

service_subscription

service_subscription_id

service_subscription_contact

service_subscription_id

properties_hs_created_by_user_id

properties_hs_external_id

properties_hs_object_id

properties_hs_product_id

properties_hs_updated_by_user_id

properties_hs_variant_id

properties_hs_object_source_id

properties_hs_object_source_user_id

properties_hubspot_owner_id

properties_hubspot_team_id

properties_ip_sync_extension_external_source_account_id

properties_ip_sync_extension_external_source_app_id

delivery_address

delivery_address

delivery_address_id

delivery_address_company

delivery_address_id

licence_company

licence_contact

company_company

company_contact

company_engagement

contact_company

contact_engagement

subscription_change

subscription_id

normalized_email_id

caused_by_event_id

email_campaign_id

email_campaign_group_id

obsoleted_by_id

sent_by_created

lead_nurturing_campaign_id

kickback_email_workflow_id

business_unit_id

notify_recipients

created_user_id

updated_user_id

hubspot_defined

show_currency_symbol

modification_metadata

line_item_property_history

updated_by_user_id

internal_list_id

meta_data_parent_folder_id

meta_data_last_size_change_at

meta_data_processing

ticket_property_history

updated_by_user_id

marketing_email

marketing_email_id

analytics_page_id

can_spam_settings_id

email_campaign_group_id

feedback_survey_id

primary_email_campaign_id

published_by_id

last_edit_session_id

last_edit_update_id

ab_hours_to_wait

ab_sample_size_default

ab_sampling_default

ab_success_metric

ab_test_percentage

contact_property_history

updated_by_user_id

subscription_id

deal_property_history

updated_by_user_id

product_property_history

updated_by_user_id

form_submission

company_property_history

updated_by_user_id

properties_hs_created_by_user_id

properties_hs_folder_id

properties_hs_object_id

properties_hs_updated_by_user_id

properties_hubspot_owner_id

properties_hubspot_team_id

properties_hs_object_source_id

properties_hs_object_source_user_id

properties_product_id

properties_amount

properties_createdate

properties_description

properties_discount

properties_hubspot_owner_assigneddate

properties_name

properties_price

properties_quantity

Open the schema explorer Open the full schema explorer

Weld MCP server

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

Set up the MCP server

Claude CodeOpus 5

ConnectedWeld MCPAgent contextHubSpottables61fields534joins38

>

How many subscription_change rows do we have in our HubSpot data?

Reading the HubSpot context first, so the query uses the right tables and keys.

●weld·search_available_references

⎿raw.hubspot.subscription_change

raw.hubspot.subscription

+ 59 more HubSpot tables

●weld·get_reference_schema

⎿subscription_change · 8 columns

related to subscription

●weld·run_query

⎿select count(*) from {{raw.hubspot.subscription_change}}

submitted

●weld·get_query_status

⎿DONE

●weld·get_query_result

⎿rows returned

✓Answered from HubSpot data in your warehouse

>Ask about your HubSpot dataMCP

Destinations

Load HubSpot into any warehouse.
Set up in minutes, no code.

Resources

Everything you need.
To get started.

HubSpot setup guide

Step-by-step instructions to configure and start syncing.

Connect your agents

Set up Claude, Cursor, ChatGPT or Codex against your Weld workspace.

Weld Connect API

Build custom connectors

Use the Weld Connect API to build and publish your own connector.

Common questions

Answers to frequently asked questions about Weld connectors.

Weld Connect API

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.

Explore Weld Connect API reference

POST/elt_syncs

# Create a HubSpot ELT sync
curl -X POST https://connect.weld.app/elt_syncs \
  -H "x-api-key: $API_KEY" \
  -d '{
    "connection_id": "conn_abc123",
    "integration_id": "hubspot-v2",
    "destination_schema_name": "hubspot-v2_data",
    "sync_interval": "0 * * * *"
  }'
▌

FAQ

Common questions.
About connectors.

Something not covered here? A data engineer can walk through your setup with you.

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.

HubSpot

Source

Weld

MCPAgents

Start for free Talk to us

Connectors

Explore more connectors.
300+ and counting.

View all connectors