MySQL

MySQL Integration

Read and change rows in a MySQL or MariaDB database from a cloud flow

Data & Analytics 6 actions No credentials required

Start automating MySQL

What you can automate with MySQL

Drag any of these 6 actions into a process – no code, no API wrangling.

Delete rows

Delete the rows that match Where. Where cannot be empty, so a step can never empty the whole table by mistake.

Find rows

Read the rows of a table that match Where, without writing SQL.

Insert rows

Add one row, or a list of rows (up to 1000), to a table. The id of the first new row comes back.

Run a query

Run a SELECT (or any query that returns rows) and get the rows back. Values go in Parameters, never into the SQL text. At most 5000 rows come back.

Run a statement

Run a statement that changes data (INSERT, UPDATE, DELETE, or a stored procedure) and get how many rows it changed.

Update rows

Change the rows that match Where. Where cannot be empty, so a step can never change the whole table by mistake.

How the MySQL connection works

1. Authenticate

MySQL uses no credentials required. Save the connection once and reuse it across every process.

2. Build the process

Drop MySQL steps onto the process map alongside desktop, browser, Excel and email steps.

3. Run it attended or unattended

Trigger on a schedule, an email, or a file landing in a folder. Credentials stay encrypted and every run is audited.

Because MySQL has an API, Automize talks to it directly in the cloud – no bot needed on a desktop. Where a system has no API, an Automize bot drives its interface instead.

Other Data & Analytics connectors

Automate MySQL in 7 days

We build one working MySQL automation in your business inside a week, at a fixed price.