Klaviyo Connector

Klaviyo is a powerful email marketing platform tailored for e-commerce businesses, allowing them to create personalized, multi-channel campaigns.

Start for free View documentation

4.8 on G2

Weld · Data Sources

Klaviyo

KlaviyoYour warehouseLive

profile30 columnsSynced

event9 columnsSynced

segment_profile4 columnsSynced

segment10 columnsSyncing

metric10 columnsQueued

Lands in

snowflake

bigquery

databricks

Agent context over MCP

How it works

Set up in minutes.
No code, no maintenance.

Klaviyo

Klaviyo

Data source

Authenticating...

Ready to connect

Overview

Klaviyo in your warehouse.
Ready for your agents.

Klaviyo is a powerful email marketing platform tailored for e-commerce businesses, allowing them to create personalized, multi-channel campaigns. Weld's Klaviyo connector is fully managed: it extracts data from Klaviyo, 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

Klaviyo data schema.
The map your agents read.

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

tables: 10
fields: 111
relationships: 5

Loading diagram…

segment_profile

custom_properties

klaviyo_properties

send_options_use_smart_sending

tracking_options_is_add_utm

tracking_options_utm_params

send_strategy_method

send_strategy_options_static_datetime

integration_object

integration_key

integration_name

integration_category

attributes_email

attributes_phone_number

attributes_external_id

attributes_anonymous_id

attributes_first_name

attributes_last_name

attributes_organization

Open the schema explorer Open the full schema explorer

Weld MCP server

Ask your agent.
It already knows Klaviyo.

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

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

Set up the MCP server

Claude CodeOpus 5

ConnectedWeld MCPAgent contextKlaviyotables10fields111joins5

>

How many segment_profile rows do we have per profile? Use our Klaviyo data.

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

●weld·search_available_references

⎿raw.klaviyo.segment_profile

raw.klaviyo.profile

+ 8 more Klaviyo tables

●weld·get_reference_schema

⎿segment_profile · 4 columns

joins profile on profile_id

●weld·run_query

⎿select p.id, count(*) from {{raw.klaviyo.segment_profile}} s

join {{raw.klaviyo.profile}} p on s.profile_id = p.id

group by 1

submitted

●weld·get_query_status

⎿DONE

●weld·get_query_result

⎿rows returned

✓Answered from Klaviyo data in your warehouse

>Ask about your Klaviyo dataMCP

Destinations

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

Resources

Everything you need.
To get started.

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

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

Klaviyo

Source

Weld

MCPAgents

Start for free Talk to us

Connectors

Explore more connectors.
300+ and counting.

View all connectors