Integration

Connect MySQL to Ortto

When something happens in MySQL, your agent does the next thing in Ortto. Describe it in plain language and the automation is built, tested on every branch and kept running.

MySQL4 triggersMySQL6 actionsOrtto4 triggersOrtto10 actions

Browse all apps

Build it

What do you want MySQL and Ortto to do together?

Describe it and your agent reads both APIs, builds the automation, tests every branch and ships it. The list below is what exists today, not the limit.

Ask the assistant

You'll sign in before anything runs. What you typed comes with you.

Or work from Claude Code

Install the APIANT plugin for Claude Code and build, edit, test and read run history from your terminal. Every plan gets this, including free, and it spends no assistant credits.

Connect Claude Code

Everything your agent can do with MySQL and Ortto

Triggers and actions 8 triggers · 16 actions

Trigger
New or Updated Row
Triggers when a new row is added or modified.
Trigger
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.
Trigger
New Row
Triggers when you add a new row.
Trigger
New Table
Fires when a new table appears in the connected MySQL database.
Action
Add Row
Adds a new row.
Action
Delete Row
Delete the rows in a table whose chosen column equals a value.
Action
Find Row
Finds a row in a table via a lookup column.
Action
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 ?.
Action
Find Row via Custom Query
Runs a SELECT statement you write against the connected MySQL database and returns the first row it matches.
Action
Update Row
Updates an existing row.
Trigger
Fields Updated
Triggers when the specified field(s) of a record have been updated in your Ortto account.
Trigger
New Activity Occurred
Triggers when a new Ortto activity occurs.
Trigger
New Record Created
Triggers when a new record (contact or organization) has been added to your Ortto account.
Trigger
Tag Added/Removed
Triggers when a tag has beed added to, or removed from, a record.
Action
Add Custom Field
Create a new custom field on the person or organization schema in Ortto. Endpoint: POST /v1/custom-field/create. Vendor doc: https://help.ortto.com/developer/latest/api-reference/custom-field/
Action
Create Record
Create a new record (person, organization), or update an existing record in your Ortto account.
Action
Delete Record
Archive, restore, or permanently delete a person or organization record in Ortto. Endpoint: POST /v1/person/delete (and /v1/organization/delete for accounts). Vendor doc: https://help.ortto.com/a-260-archive-restore-and-delete-people-archive-restore-delete
Action
Get Record
Fetches one or more people, or one or more accounts, by their Ortto ids, returning whichever fields you ask for.
Action
List Activities
Retrieve the activity feed for a given contact in Ortto. Endpoint: POST /v1/person/activities/list (activity log for a contact ID). Vendor doc: https://help.ortto.com/a-773-retrieve-activity-feed-for-a-given-contact
Action
Opt Out From SMS
Opt out a person from all SMS communications.
Action
Search or Create Records
Search your Ortto data for a record based on the provided field or optionally create one if none is found.
Action
Tag/Untag Records
Adds or removes tags on a person or an account in Ortto, matching the record by email address or account name.
Action
Unsubscribe a Person
Unsubscribe a person from all emails.
Action
Update Audience Subscription
Subscribe or unsubscribe a person to/from an Ortto audience. Endpoint: POST /v1/audience/subscribe. Vendor doc: https://help.ortto.com/developer/latest/api-reference/audiences/

Each app on its own

The other way round: Ortto to MySQL