Skip to main content

MySQL

MySQL Plugin – Custom, Delete, Insert, Select, Update, Upsert​

Summary (SEO Meta Description):
The MySQL Plugin in WeHub allows workflows to connect with MySQL databases.
Use this plugin to query, insert, update, upsert, or delete records in relational workflows at scale.

Overview​

The MySQL Plugin integrates WeHub workflows with MySQL, one of the most widely used relational databases.
It enables you to run SQL queries, manage tables, and manipulate records directly inside workflows.

This plugin is essential for workflows that require transactional data management, reporting, and structured storage.

Typical Use Cases:

  • Store workflow results in MySQL tables
  • Automate CRUD operations on relational data
  • Query MySQL for reporting or analytics
  • Update transactional or healthcare records dynamically
  • Upsert records to avoid duplicates while keeping data fresh

Available Actions​

  • Custom – Execute raw SQL queries against a MySQL database.
  • Delete – Remove records from a MySQL table.
  • Insert – Add new records to a MySQL table.
  • Select – Query records from a MySQL table.
  • Update – Modify existing records in a MySQL table.
  • Upsert – Insert or update records in a MySQL table depending on existence.

FAQ​

Q: Can I run raw SQL queries with the MySQL Plugin?
A: Yes. The Custom action lets you execute raw SQL for advanced operations beyond standard CRUD.

Q: Does the plugin support schema validation?
A: Yes. Input and output schemas can be configured to ensure consistent data mapping.

Q: Is MySQL supported as both a Trigger and Processor?
A: No. The MySQL Plugin is a Processor and is used to query or manage records, not to initiate workflows.

Keywords: MySQL Plugin, WeHub MySQL Integration, SQL Workflow Automation, MySQL Database CRUD, MySQL Query Plugin