MySQL Integration

Read and change rows in a MySQL or MariaDB database, run your own query, and start a workflow when new rows appear. Works with MySQL, MariaDB, Amazon RDS and Aurora, and other MySQL-compatible servers. Use MySQL inside visual workflows on WEXTL to compose logic that vendor integrations alone cannot cover. Pair it with app triggers and actions on the canvas to build end-to-end automations.
3-day trialCancel anytimeUp to 10 minutes quick set up
  • GDPR
  • Data Encryption
  • 2FA
  • Local Data Region

Supported triggers and actions for MySQL integration

Triggers can detect changes in MySQL and run actions that can create, search or modify data inside MySQL automatically [3] — exactly how you set them.

  • Watch rowsStart a workflow when new or changed rows appear in a table. Checks on your workflow schedule.
  • Delete rowsDelete the rows that match your conditions.
  • Execute a queryRun your own SQL, with values passed as parameters.
  • Insert a rowAdd a row to a table and get its new id back.
  • Insert or update a rowAdd a row, or update it when a row with the same key already exists.
  • Select rowsRead rows from a table with simple conditions, a sort and a limit.
  • Update rowsChange the rows that match your conditions.

How to integrate MySQL in automation workflow?

3 simple steps to make your MySQL connected with other apps in automation workflows on WEXTL. Up to 10 minutes integration set up.

Connect MySQL to popular apps on WEXTL

Enter a name of the other app you want to sync with MySQL below. Click on selected app to explore integration options with MySQL. If the app you search for is not available in WEXTL yet, you can use HTTP node [10] instead to integrate it directly.

Example automation with MySQL integration

Select Watch rows trigger from MySQL - this will be a starting point in your automation. Whenever event happens in MySQL, workflow will start [7] from Watch rows node.

Search for Delete rows, connect it as the next step of integration sequence. You can use filters between Watch rows and Delete rows, so only important data pass from Watch rows to the next step. WEXTL gives you full control over the process of MySQL automation. All parts of workflow are visible on the canvas [4].

MySQL on WEXTL has 7 modules for building built-in automations. Explore MySQL documentation for more.

MySQL
Watch rows
Microsoft SQL Server
Performs action
OR
Microsoft SQL Server
Triggers
MySQL
Delete rows

Demonstration of how visual MySQL automation [6] looks in WEXTL.

Frequently asked questions

Common questions about automating MySQL in your workflows.

Try MySQL on WEXTL®

Claim your 3-day trial to build MySQL integrations and access every WEXTL® feature.

Cancel anytime.

References

List of sources used to gather information about the MySQL integration.

  1. MySQL integration source code, module specs and credentials implementation.
  2. Internal MySQL integration documentation, structured input and output parameters, scopes, and authentication methods.
  3. This is a built-in WEXTL® workflow node — see the Visual Workflow Builder capability page for how it's used on the canvas.
  4. WEXTL® Visual Workflow Builder, anonymized data from our technical support team.
  5. WEXTL® Apps Library
  6. WEXTL® MySQL App Documentation
  7. WEXTL® Workflow Scheduler
  8. WEXTL® HTTP node documentation