Intercom Connector

Conversational Relationship Platform helping businesses build customer relationships through personalized, messenger-based experiences.

Start for free View documentation

4.8 on G2

Weld · Data Sources

Intercom

IntercomYour warehouseLive

call19 columnsSynced

conversation59 columnsSynced

contact43 columnsSynced

admin5 columnsSyncing

conversation_part14 columnsQueued

Lands in

snowflake

bigquery

databricks

Agent context over MCP

How it works

Set up in minutes.
No code, no maintenance.

Intercom

Intercom

Data source

Authenticating...

Ready to connect

Overview

Intercom in your warehouse.
Ready for your agents.

Conversational Relationship Platform helping businesses build customer relationships through personalized, messenger-based experiences. Weld's Intercom connector is fully managed: it extracts data from Intercom, 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

Intercom data schema.
The map your agents read.

Every table, field and relationship Weld syncs from Intercom is served to agents as context over MCP, so they pick the right tables and join on the right keys.

tables: 15
fields: 217
relationships: 9

Loading diagram…

intercom_team_admin

intercom_contact_company

contact_updated_at

intercom_contact_tag

contact_updated_at

admin_assignee_id

team_assignee_id

conversation_rating_remark

intercom_conversation_admin

conversation_id

conversation_updated_at

intercom_conversation_contact

conversation_id

conversation_updated_at

conversation_part

conversation_part

conversation_id

assigned_to_type

conversation_updated_at

intercom_conversation_part_attachment

conversation_part_id

conversation_part_created_at

conversation_id

ticket_type_name

ticket_type_description

ticket_type_icon

ticket_type_workspace_id

ticket_type_archived

ticket_type_created_at

Open the schema explorer Open the full schema explorer

Weld MCP server

Ask your agent.
It already knows Intercom.

Connect Claude, Cursor, ChatGPT or your own agent to Weld over MCP. It reads the Intercom context, finds the tables it needs and queries your warehouse.

Agent contextIntercom tables, fields and joins
QuerySQL against your warehouse
OperateCheck, rerun and refresh syncs

Set up the MCP server

Claude CodeOpus 5

ConnectedWeld MCPAgent contextIntercomtables15fields217joins9

>

How many call rows do we have per conversation? Use our Intercom data.

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

●weld·search_available_references

⎿raw.intercom.call

raw.intercom.conversation

+ 13 more Intercom tables

●weld·get_reference_schema

⎿call · 19 columns

joins conversation on conversation_id

●weld·run_query

⎿select j.id, count(*) from {{raw.intercom.call}} c

join {{raw.intercom.conversation}} j on c.conversation_id = j.id

group by 1

submitted

●weld·get_query_status

⎿DONE

●weld·get_query_result

⎿rows returned

✓Answered from Intercom data in your warehouse

>Ask about your Intercom dataMCP

Destinations

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

Resources

Everything you need.
To get started.

Intercom 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 Intercom 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 Intercom ELT sync
curl -X POST https://connect.weld.app/elt_syncs \
  -H "x-api-key: $API_KEY" \
  -d '{
    "connection_id": "conn_abc123",
    "integration_id": "intercom",
    "destination_schema_name": "intercom_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 Intercom data to work.

Connect Intercom, pick a warehouse, and your agents can query it today. Free for 14 days, no credit card.

Intercom

Source

Weld

MCPAgents

Start for free Talk to us

Connectors

Explore more connectors.
300+ and counting.

View all connectors