MQTT and MySQL Integration

MQTT
MySQL

Demonstration of how apps are integrated in WEXTL workflow builder [4]

MQTT is a WEXTL® built-in workflow node — it ships with the platform and drops straight into any MySQL workflow you build. Pick a MySQL trigger or action below, then add MQTT to the canvas in one click. Full visual setup, 3 simple steps, no code and no extra credentials to configure.

3-day trialCancel anytimeUp to 10 minutes quick set up
  • GDPR
  • Data Encryption
  • 2FA
  • Local Data Region

Learn about MQTT and MySQL

Detailed info you need to know about MQTT and MySQL integrations in WEXTL. Explore which modules apps support and how you connect them.

MQTT

Built-in1 trigger1 actionPublish messages to an MQTT broker, and start a workflow when messages arrive on the topics you subscribe to. Works with MQTT 5 brokers such as Mosquitto, EMQX, HiveMQ and AWS IoT Core. [5]

MySQL

Built-in1 trigger6 actionsRead 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. [6]

How to connect MQTT to MySQL

Set up your MQTT and MySQL integration in 3 simple steps [2] — no coding required. Up to 10 minutes setup.

How does the integration between MQTT and MySQL work in WEXTL?

WEXTL exposes actions and triggers for MQTT and MySQL that help you connect apps and automate repetitive tasks [1]. A trigger is an event that happens, an action — a step that performs when the event has occurred.

MQTT (built-in)MySQL (built-in)

MQTT modules
  • M
    Publish a messagePublish a message to a topic and wait for the broker to confirm it (QoS 1).
  • M
    Watch messagesStart a workflow when messages arrive on the topics you subscribe to. Checks on your workflow schedule.
MySQL modules
  • M
    Delete rowsDelete the rows that match your conditions.
  • M
    Execute a queryRun your own SQL, with values passed as parameters.
  • M
    Insert a rowAdd a row to a table and get its new id back.
  • M
    Insert or update a rowAdd a row, or update it when a row with the same key already exists.
  • M
    Select rowsRead rows from a table with simple conditions, a sort and a limit.
  • M
    Update rowsChange the rows that match your conditions.
  • M
    Watch rowsStart a workflow when new or changed rows appear in a table. Checks on your workflow schedule.

Explore alternative integrations

There are other apps [9] supported by WEXTL that can be paired with MQTT and MySQL integrations. Pick any from the list below if the current combination isn't the one you need.

Alternative integrations to MQTT [5]

Alternative integrations to MySQL [6]

Try MQTT and MySQL on WEXTL®

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

Cancel anytime.

Frequently asked questions

Common questions about connecting MQTT and MySQL.

References

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

  1. MQTT and MySQL integration source code, module specs and credentials implementation.
  2. Our MQTT and MySQL integration documentation, structured input and output parameters, scopes, and authentication methods.
  3. Official vendor API documentation for MQTT and MySQL — used to verify field meanings, authentication flows, and anything our own specs don't fully capture.
  4. WEXTL® visual workflow builder, anonymized data from our technical support team.
  5. MQTT integration information
  6. MySQL integration information
  7. WEXTL® Scheduling
  8. WEXTL® Pricing and Trial
  9. WEXTL® Apps Library

Explore MQTT and MySQL, or get started