MySQL

Run queries, insert, update, and delete rows in a MySQL database. In Appbricx, your workflows and server functions call it by name once it is connected.

Connect MySQLFull reference

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
    // .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 });
}

MySQL and its logo are trademarks of their owner, shown only to identify the service this integration connects to. Their use does not imply endorsement by, or affiliation with, that company.

Connect MySQL once. Every workflow can use it.

Start freeAll integrations