MySQL

What you can do

6 actions, each one call from a workflow or a server function. Triggers come from your app: a row changing, a schedule or a webhook.

• Delete Rowdelete_row
  Deletes one or more rows from a table
• Insert Rowinsert_row
  Inserts a new row into a table
• Update Rowupdate_row
  Updates one or more rows in a table
• Execute Queryexecute_query
  Executes a query on the mysql database and returns the results
• Find Rowsfind_rows
  Reads rows from a table
• Get Tablesget_tables
  Returns a list of tables in the database

Set it up

About two minutes, once per project or once for the whole workspace.

1. Open Integrations in the builder

   Backend panel, Integrations tab, then MySQL. To connect it for every project, use Workspace settings, Integrations.

2. Add your credentials

   Fill in the fields the provider needs (listed below). They are stored encrypted in the vault.

   • Host Database server hostname or IP address
   • Port Database server port (default 3306)
   • User Database username
   • Password Database password
   • Database Database name to connect to
3. Call an action

   From a workflow, by integration id and action name. The call answers with success, output and, when it fails, the reason.

   // .workflow.js (native ctx)
   export async function run(ctx) {
     const res = await ctx.integrations.invoke("mysql", "delete_row", {
       "table": "<table>",
       "search_column": "<search column>",
       "search_value": "<search value>"
     });
     if (!res.success) throw new Error(res.error);
     ctx.log.info("MySQL answered", { output: res.output });
   }

More in Data and storage

• S3Amazon S3
• Dropbox
• Google Cloud Storage
• MongoDB
• PostgreSQL
• Supabase
• All of Data and storage