APIANT.aiApp
MySQL
Connect directly to a MySQL database and run SQL statements from your automations.
What your agent can do with MySQL
Triggers and actions 4 triggers · 6 actions
- TriggerNew or Updated Row
Triggers when a new row is added or modified.
- TriggerNew or Updated Row (Custom Query)
Fires for each new or changed row returned by a SELECT statement you write against the connected MySQL database.
- TriggerNew Row
Triggers when you add a new row.
- TriggerNew Table
Fires when a new table appears in the connected MySQL database.
- ActionAdd Row
Adds a new row.
- ActionDelete Row
Delete the rows in a table whose chosen column equals a value.
- ActionFind Row
Finds a row in a table via a lookup column.
- ActionFind 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 ?.
- ActionFind Row via Custom Query
Runs a SELECT statement you write against the connected MySQL database and returns the first row it matches.
- ActionUpdate 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.
Not listed?
Need a trigger or action that is not here?
Ask your agent. Describe what you need in plain language and it reads the MySQL API documentation, builds the operation at whatever depth the API allows, tests every branch and ships it. The list above is what exists today, not the limit.