Intercom Connector
Conversational Relationship Platform helping businesses build customer relationships through personalized, messenger-based experiences.
IntercomYour warehouseLive
Agent context over MCPSet up in minutes.
No code, no maintenance.
Intercom
Data source
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.
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
- 17
- fields
- 220
- relationships
- 10
Intercom models.
What the numbers mean.
Open-source SQL that turns the raw Intercom tables into the reports people ask about. Deploy them in Weld and your agent queries the definitions, not guesses.
- Monthly Conversations By Team Extracts monthly conversation data by team from the Intercom integration. It selects the month, team ID, team name, and ticket count from the conversation table. It then joins the conversation table with the team table and groups the results by month, team ID, and team name, ordering them by month and ticket count in descending order.
- Monthly Tickets By TeamExtracts monthly ticket data for each team, including the team ID, team name, and the count of tickets. It uses the Intercom integration and joins the ticket and team tables based on the team assignee ID. The results are grouped by month, team ID, and team name, and ordered by month and ticket count in descending order.
- Monthly Ticket Resolution TimeExtracts the monthly ticket resolution time for a specific integration (intercom). It selects the month, team ID, team name, and average resolution time in days. It joins the ticket and team tables, filters for resolved tickets, groups the results by month and team, and sorts them in descending order by month and ascending order by average resolution time.
- Monthly Tags By ConversationThis SQL template extracts monthly tags by conversation from the Intercom integration. It uses a common table expression (CTE) to join the conversation and conversation_tag tables, and then retrieves the month, tag name, and tag count for each conversation. The results are grouped by month and tag name, and ordered by month in descending order.
- Monthly Average Conversations RatingExtracts the monthly average rating for conversations from the Intercom integration. It selects the truncated month and calculates the average rating for conversations that have a non-null rating value. The results are grouped by month and ordered in descending order.
- Count of Tickets By State Extracts the count of tickets grouped by month and ticket state from the Intercom integration. It uses the `date_trunc` function to truncate the `created_at` column to the month level. The result is then ordered by month in descending order, followed by the ticket count in descending order.
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
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.
Load Intercom into any warehouse.
Set up in minutes, no code.
Everything you need.
To get started.
Intercom 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 Intercom connections, configure ELT syncs, and manage pipelines entirely through code. Built for embedding, automation, and CI/CD workflows.
▌Common questions.
About connectors.
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.
Source
