Mailchimp Connector

Mailchimp provides email marketing and automation services, enabling businesses to create, send campaigns, manage subscribers, and track performance.

Start for free View documentation

4.8 on G2

Weld · Data Sources

Mailchimp

MailchimpYour warehouseLive

list48 columnsSynced

member28 columnsSynced

member_activity10 columnsSynced

campaign_member_recipient9 columnsSyncing

segment_member4 columnsQueued

Lands in

snowflake

bigquery

databricks

Agent context over MCP

How it works

Set up in minutes.
No code, no maintenance.

Mailchimp

Mailchimp

Data source

Authenticating...

Ready to connect

Overview

Mailchimp in your warehouse.
Ready for your agents.

Mailchimp provides email marketing and automation services, enabling businesses to create, send campaigns, manage subscribers, and track performance. Weld's Mailchimp connector is fully managed: it extracts data from Mailchimp, 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

Mailchimp data schema.
The map your agents read.

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

tables: 24
fields: 288
relationships: 17

Loading diagram…

parent_campaign_id

long_archive_url

campaign_ab_split_opt

campaign_recipient

recipient_count

segment_opts_saved_segment_id

segment_opts_prebuilt_segment_id

segment_opts_match

segment_opts_conditions

campaign_report_summary

subscriber_clicks

ecommerce_total_orders

ecommerce_total_spent

ecommerce_total_revenue

campaign_rss_opt

schedule_daily_send_sunday

schedule_daily_send_monday

schedule_daily_send_tuesday

schedule_daily_send_wednesday

schedule_daily_send_thursday

campaign_setting

use_conversation

campaign_tracking

google_analytics

campaign_variate_setting

winning_combination_id

winning_campaign_id

winner_criteria

reply_to_addresses

campaign_variate_setting_combination

content_description

campaign_member_recipient

subscriber_count

interest_category

contact_company

contact_address_1

contact_address_2

recipient_clicks

unique_email_id

unsubscribe_reason

member_interest

member_last_note

member_location

member_marketing_permission

marketing_permission_id

member_activity

parent_campaign

options_conditions

Open the schema explorer Open the full schema explorer

Weld MCP server

Ask your agent.
It already knows Mailchimp.

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

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

Set up the MCP server

Claude CodeOpus 5

ConnectedWeld MCPAgent contextMailchimptables24fields288joins17

>

How many member rows do we have per list? Use our Mailchimp data.

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

●weld·search_available_references

⎿raw.mailchimp.member

raw.mailchimp.list

+ 22 more Mailchimp tables

●weld·get_reference_schema

⎿member · 28 columns

joins list on list_id

●weld·run_query

⎿select l.id, count(*) from {{raw.mailchimp.member}} m

join {{raw.mailchimp.list}} l on m.list_id = l.id

group by 1

submitted

●weld·get_query_status

⎿DONE

●weld·get_query_result

⎿rows returned

✓Answered from Mailchimp data in your warehouse

>Ask about your Mailchimp dataMCP

Destinations

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

Resources

Everything you need.
To get started.

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

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

Mailchimp

Source

Weld

MCPAgents

Start for free Talk to us

Connectors

Explore more connectors.
300+ and counting.

View all connectors