Integration
Connect Klaviyo and MySQL
When New Event fires in Klaviyo, your agent runs Add Row in MySQL, or New or Updated Row in MySQL to Get Profile by Email in Klaviyo. Describe the whole flow and it is built, tested on every scenario and kept running.
What the catalog holds today. Ask for anything missing and your agent reads the API documentation and adds it.
Build solutions, not workarounds.
What do you want Klaviyo and MySQL to do together?
Ask the assistant
Connect your AI client
Give your AI client this address.
https://mcp.apiant.aiOne connection does both: ask your client to act in an app once, or have it build an automation that keeps running. Any client that takes a remote MCP server. Nothing to install. Create your free account, then sign in once in your browser.
Set it up in your client
Claude Code
Run this in the directory you want to work in.
claude mcp add --transport http -s project apiant-ai https://mcp.apiant.aiStart Claude Code there, approve the server, and sign in in the browser page it opens.
Claude Code guide (opens in a new tab)Claude, web and desktop
Open Customize, then Connectors, then Add custom connector, and paste the address. On Team and Enterprise an owner adds it first.
Setup guide (opens in a new tab)Cursor
Add the address to your MCP configuration as a server URL. Cursor signs you in in your browser.
Setup guide (opens in a new tab)Zed
Open Settings, then AI, then MCP Servers, then Add Server, then Add Remote Server.
Setup guide (opens in a new tab)Codex and the ChatGPT desktop app
Open Settings, then MCP servers, then Add server, and choose Streamable HTTP. From the terminal, Codex takes the address with its own add command and then signs you in.
Setup guide (opens in a new tab)Any other MCP client
Paste the address where the client asks for a remote MCP server URL, and name the server apiant-ai where it lets you. APIANT's skills reach the client over the same connection.
Setup guide (opens in a new tab)Connecting MySQL and Klaviyo lets your database stay the source of truth for customers and products while Klaviyo holds the profiles, lists and events marketing works from. Rows added or changed in MySQL can become Klaviyo profiles, catalog items or tracked events, and profile updates or events in Klaviyo can be written back to your tables.
Example flows
What Klaviyo and MySQL can do together
From Klaviyo to MySQL
When New Event in Klaviyo
then Add Row in MySQL
From MySQL to Klaviyo
Starting points drawn from the triggers and actions in the catalog today. Describe the flow you need, at any depth, and your agent builds it and tests every scenario before it ships.
Everything your agent can do with Klaviyo and MySQL
Triggers and actions 6 triggers · 144 actions
- New Event
Polling trigger. Fires when a new event (metric occurrence) is recorded, ordered by most-recent datetime.
- New or Updated Profile
Polling trigger. Fires when a profile is created or updated, ordered by most-recently updated.
- Add Categories to Catalog Item
Add Categories to Catalog Item
- Add Items to Catalog Category
Add Items to Catalog Category
- Add Profiles to List
Add Profiles to List
- Add Profile to List
Add an existing profile to a list by profile ID.
- Bulk Create Catalog Categories
Bulk Create Catalog Categories
- Bulk Create Catalog Items
Bulk Create Catalog Items
- Bulk Create Catalog Variants
Bulk Create Catalog Variants
- Bulk Create Coupon Codes
Bulk Create Coupon Codes
- Bulk Create Events
Bulk Create Events
- Bulk Delete Catalog Categories
Bulk Delete Catalog Categories
- Bulk Delete Catalog Items
Bulk Delete Catalog Items
- Bulk Delete Catalog Variants
Bulk Delete Catalog Variants
- Bulk Import Profiles
Bulk Import Profiles
- Bulk Subscribe Profiles
Bulk Subscribe Profiles
- Bulk Suppress Profiles
Bulk Suppress Profiles
- Bulk Unsubscribe Profiles
Bulk Unsubscribe Profiles
- Bulk Unsuppress Profiles
Bulk Unsuppress Profiles
- Bulk Update Catalog Categories
Bulk Update Catalog Categories
- Bulk Update Catalog Items
Bulk Update Catalog Items
- Bulk Update Catalog Variants
Bulk Update Catalog Variants
- Cancel Campaign Send
Cancel Campaign Send
- Clone Campaign
Clone Campaign
- Clone Template
Clone Template
- Create Back In Stock Subscription
Create Back In Stock Subscription
- Create Campaign
Create Campaign
- Create Campaign Clone
Create Campaign Clone
- Create Catalog Category
Create Catalog Category
- Create Catalog Item
Create Catalog Item
- Create Catalog Variant
Create Catalog Variant
- Create Coupon
Create Coupon
- Create Coupon Code
Create Coupon Code
- Create Event
Track an event for a profile (e.g. a custom metric like "Placed Order").
- Create Flow
Create Flow
- Create List
Create a new list.
- Create or Update Profile
Create a profile if it doesn't exist, otherwise update the matching profile (upsert by email/phone/id).
- Create Profile
Create a new profile. Errors if a profile with the email already exists.
- Create Segment
Create Segment
- Create Tag
Create Tag
- Create Template
Create Template
- Delete Campaign
Delete Campaign
- Delete Catalog Category
Delete Catalog Category
- Delete Catalog Item
Delete Catalog Item
- Delete Catalog Variant
Delete Catalog Variant
- Delete Coupon
Delete Coupon
- Delete Coupon Code
Delete Coupon Code
- Delete Flow
Delete Flow
- Delete List
Delete List
- Delete Segment
Delete Segment
- Delete Tag
Delete Tag
- Delete Template
Delete Template
- Get Campaign
Get Campaign
- Get Campaign Recipient Estimation
Get Campaign Recipient Estimation
- Get Campaigns
Get Campaigns
- Get Catalog Categories
Get Catalog Categories
- Get Catalog Category
Get Catalog Category
- Get Catalog Item
Get Catalog Item
- Get Catalog Items
Get Catalog Items
- Get Catalog Variant
Get Catalog Variant
- Get Catalog Variants
Get Catalog Variants
- Get Coupon
Get Coupon
- Get Coupon Code
Get Coupon Code
- Get Coupon Codes
Get Coupon Codes
- Get Coupons
Get Coupons
- Get Event
Get Event
- Get Events
Retrieve events, optionally filtered (e.g. by metric or profile).
- Get Flow
Get Flow
- Get Flows
Get Flows
- Get Flows Triggered by List
Get Flows Triggered by List
- Get Flows Triggered by Metric
Get Flows Triggered by Metric
- Get Flows Triggered by Segment
Get Flows Triggered by Segment
- Get Form
Get Form
- Get Forms
Get Forms
- Get Form Version
Get Form Version
- Get Image
Get Image
- Get Images
Get Images
- Get List
Get List
- Get List Profiles
Get all profiles that are members of a given list.
- Get Lists
Retrieve all lists in the account.
- Get Metric
Get Metric
- Get Metrics
Retrieve all metrics in the account.
- Get Profile
Get Profile
- Get Profile by Email
Fetch a single profile by its email address. Emits empty values if no profile is found.
- Get Profile by ID
Fetch a single profile by its Klaviyo profile ID.
- Get Profiles
List profiles, optionally filtered by email or other attributes.
- Get Push Tokens
Get Push Tokens
- Get Reviews
Get Reviews
- Get Segment
Get Segment
- Get Segment Profiles
Get all profiles in a given segment.
- Get Segments
Retrieve all segments in the account.
- Get Tag
Get Tag
- Get Tags
Get Tags
- Get Template
Get Template
- Get Templates
Get Templates
- Merge Profiles
Merge Profiles
- Query Campaign Values
Query Campaign Values
- Query Flow Series
Query Flow Series
- Query Flow Values
Query Flow Values
- Query Form Series
Query Form Series
- Query Form Values
Query Form Values
- Query Metric Aggregates
Query Metric Aggregates
- Query Segment Series
Query Segment Series
- Query Segment Values
Query Segment Values
- Refresh Campaign Recipient Estimation
Refresh Campaign Recipient Estimation
- Remove Categories from Catalog Item
Remove Categories from Catalog Item
- Remove Items from Catalog Category
Remove Items from Catalog Category
- Remove Profile from List
Remove a profile from a list by profile ID.
- Remove Profiles from List
Remove Profiles from List
- Remove Tag from Campaigns
Remove Tag from Campaigns
- Remove Tag from Flows
Remove Tag from Flows
- Remove Tag from Lists
Remove Tag from Lists
- Remove Tag from Segments
Remove Tag from Segments
- Render Template
Render Template
- Request Profile Deletion
Request Profile Deletion
- Send Campaign
Send Campaign
- Subscribe Profile
Subscribe a profile (email/SMS consent) to a given list.
- Suppress Profile
Suppress a profile from receiving email marketing (global suppression).
- Tag Campaigns
Tag Campaigns
- Tag Flows
Tag Flows
- Tag Lists
Tag Lists
- Tag Segments
Tag Segments
- Unsubscribe Profile
Unsubscribe a profile from email/SMS marketing for a given list.
- Update Campaign
Update Campaign
- Update Catalog Category
Update Catalog Category
- Update Catalog Item
Update Catalog Item
- Update Catalog Variant
Update Catalog Variant
- Update Categories for Catalog Item
Update Categories for Catalog Item
- Update Coupon
Update Coupon
- Update Coupon Code
Update Coupon Code
- Update Flow Status
Update Flow Status
- Update Image
Update a Klaviyo image. Reads the image first, overlays only the values you supply, then saves the merged result — so anything you leave blank keeps its current value.
- Update Items for Catalog Category
Update Items for Catalog Category
- Update List
Update List
- Update Profile
Update an existing profile by its Klaviyo profile ID.
- Update Segment
Update Segment
- Update Tag
Update Tag
- Update Template
Update Template
- Upload Image From File
Upload Image From File
- Upload Image From URL
Upload Image From URL
- New or Updated Row
Triggers when a new row is added or modified.
- New or Updated Row (Custom Query)
Fires for each new or changed row returned by a SELECT statement you write against the connected MySQL database.
- New Row
Triggers when you add a new row.
- New Table
Fires when a new table appears in the connected MySQL database.
- Add Row
Adds a new row.
- Delete Row
Delete the rows in a table whose chosen column equals a value.
- Find Row
Finds a row in a table via a lookup column.
- Find Rows via Custom Query
Run an author-written SELECT against the connected MySQL database and return every row it produced. Mirrors PostgreSQL 715ae2ac, SQL Server 8e0bbb5d and Oracle 2c308e4d; MySQL placeholder style is ?.
- Find Row via Custom Query
Runs a SELECT statement you write against the connected MySQL database and returns the first row it matches.
- Update Row
Updates an existing row.
No trigger or action matches that. Ask your agent to add it: it reads the API documentation and builds what you describe.
Each app on its own
Reviews
What our customers say
More from Klaviyo
Klaviyo to SalesforceSalesforce is a leading enterprise customer relationship management (CRM) platform.
Klaviyo to SlackSlack is a messaging platform for teams. Post messages, manage channels, users, reminders, and react to...
Klaviyo to MailchimpMailchimp marketing automation and email platform.
Klaviyo to ShopifyShopify is a commerce platform for online stores and retail point-of-sale.
Klaviyo to QuickBooks OnlineQuickBooks Online accounting — manage customers, invoices, bills, payments, vendors, expenses, and more via...
Klaviyo to PipedrivePipedrive is a sales CRM and pipeline management tool.
More into MySQL
Google Calendar to MySQLGoogle Calendar is a time management tool providing scheduling features, event reminders, and integration...
Asana to MySQLAsana is a collaborative information manager for workspace.
Zoom to MySQLZoom unifies cloud video conferencing, simple online meetings, group messaging, and a software-based...
Questions
Klaviyo and MySQL, answered
Can I send Klaviyo the profile ID back into my MySQL table?
Yes. After creating or updating a profile in Klaviyo, the flow can run an Update Row action in MySQL to store the returned profile ID on the matching customer row. The agent tests every scenario, including rows where a profile already existed.
What if a customer row in MySQL has no matching Klaviyo profile yet?
Get Profile by Email returns empty values when nothing is found, so the flow can fall through to Create or Update Profile instead of failing. Both scenarios, matched and unmatched, are tested before the automation goes live.
What can start an automation from Klaviyo?
Any of Klaviyo's 2 triggers in the catalog, including New Event and New or Updated Profile. Describe the moment in plain language and your agent picks the right one.
What can your agent do in MySQL when something happens in Klaviyo?
Any of MySQL's 6 actions, including Add Row, Update Row, Find Row and Find Rows via Custom Query. Your agent maps the data both ways and tests every scenario before it ships.
Can it also run from MySQL to Klaviyo?
Yes. When something happens in MySQL, your agent can act in Klaviyo too. This page covers both directions: MySQL's triggers and Klaviyo's actions are listed here as well.
Do I have to build a connector for Klaviyo or MySQL?
No. Both are in the catalog with their triggers and actions. You describe the automation; your agent builds it, tests every scenario and keeps it running.
Can my AI client use Klaviyo and MySQL without building an automation?
Yes. With your AI client connected to APIANT, ask it to do something in either app once and it runs that action on the spot. Ask for an automation and your agent builds it, tests every scenario and keeps it running. One connection covers both.
What happens when something fails?
Your agent works that out for you. It plans the failure paths along with the happy path, then tests every scenario before it ships.
Is there a free plan?
Yes. Every plan includes the agent, including free, and building from your own AI client spends no assistant credits.