MySQL - Connection — Wiresk Documentation

MySQL is a powerful and widely-used relational database management system that helps businesses store, organize, and manage their data efficiently.

When integrated with Wiresk, it becomes a valuable tool for handling data-driven tasks. By connecting MySQL to Wiresk, users gain the ability to retrieve and work with database records directly within the automation platform.

Wiresk’s Query Builder makes it possible to extract specific records or multiple sets of data from a MySQL database, allowing users to interact with their data without needing advanced coding skills.

Prerequisites for MySQL Connection Copy Link

Before setting up a MySQL connection in Wiresk, the following conditions must be met to ensure a successful connection and stable operation:

Accessible Server
The MySQL server must be reachable from the internet (or from Wiresk’s IP range if restricted). Local or private servers behind firewalls must allow inbound connections.
Example: Ensure port 3306 is open for external access.
Valid Database Credentials
You must have a valid username and password with the correct privileges on the target database.
The account should have SELECT, INSERT, UPDATE, and DELETE rights if you plan to run read/write operations.
Database Name
The database (schema) you want to connect must already exist on the MySQL server.
Example: winbooks
Host or IP Address
The server URL must include the correct hostname or IP, and optionally the port if not default (3306).
Example: dev-f2c-02.srv.viazul.hk or 192.168.1.20:3307
Remote Access Permission
The MySQL user account must be configured to accept remote connections from Wiresk.
In MySQL, check host column in mysql.user table — use % or Wiresk IP as host.
SSL (Optional but Recommended)
If your server enforces secure connections, ensure SSL is enabled and certificates are properly configured.
Wiresk supports SSL-secured MySQL connections.
Database Engine Compatibility
Only standard MySQL and MariaDB engines are supported.
Versions 5.7 and later are recommended.

Create a MySQL connection in Wiresk Copy Link

If your database is hosted on a local server or behind a VPN, you’ll need to whitelist Wiresk’s outbound IP addresses or use a public-facing endpoint to allow access.

The connection allows you to link your Wiresk workspace directly to a MySQL database. Once connected, you can use Triggers and Methods to read, insert, update, or delete data within your database, enabling automation between MySQL and other applications.

Add MySQL app in Wiresk Copy Link

There are two ways to connect your app to Wiresk:

In “My apps” section, where you can manage your connections (select or create your group first to get access to this section, refer to the Group system ).
While building your Flow, you can easily establish a connection to your app directly within the Flow builder. This can be done during the setup of either a Trigger or a Method.

This guide explains how to set up a connection in “My apps” section, which is essentially the same process as creating one on-the-go.

On your Wiresk’s Dashboard, select your Group.
On the left panel, go to “My apps” and select
Search the app in the search field or select it from the list of apps.

Fill in the fields:

Name to identify your connection within Wiresk.
Provide your MySQL Server URL. This can be a domain name or an IP (with optional port if not default 3306).
Username: the database username used for authentication.
Password: the corresponding password for the database user.
Database Name: the name of the database schema you want Wiresk to access.
Click Create, and voila! you are a ready to go.

Wiresk 2025 10 31 at 11.51.16 MySQL - Connection

Basic understanding of Flow creation Copy Link

Now that your app is linked to Wiresk, you’re ready to start building Flows.

Simple steps to create a Flow ↓

Select your Group, then on the Flow management screen click on “Create Flow”.
On the new screen, name the new Flow.

GIF animated screen of Wiresk, showing the way to create a new Flow.

Add a Trigger that will start your Flow

Flows can be executed by multiple Triggers, depending on the desired workflow. For example, you could use scheduled Triggers with different recurrence rules alongside a Webhook Trigger for immediate, event-driven runs of the Flow. If you choose to “Run Once“, the Flow will execute using only one Trigger and its sample data.

Click on the (+) button to open the Trigger settings side panel.
On the settings side panel, click on the “+ Add” button.

Screenshot of the Wiresk side panel titled “Trigger.” The panel shows a section labeled “All Triggers” with a blue “+ Add” button for inserting a new Trigger.

On the Trigger selection screen, search your app or select it from the list below the screen.

Screenshot of Wiresk Trigger setting screen. Red arrows shows that you can wether search your app in the search or or select it in the list below.

Select your preferred Trigger on the next screen and customize its settings.

As mentioned in “How to connect your app to Wiresk” above, during your Trigger settings, you can create a new connection to your apps at this stage.

Add a Method that will execute a task

The Method will perform a specific task on a particular app or service you’ve connected to Wiresk like get info or send emails.

You can add at least 1 or multiple Methods for complex Flows (a maximum of 255 Methods).

On the Flow builder, select the (+) plus button next the Trigger button.
Search or scroll down to select the app that will perform a task.
Configure the Methods settings, refer to it documentation in our Help Center.

Screenshot of Wiresk Flow Builder with a Flow named “Flow Example.” The canvas shows a Gmail Trigger on the left connected to an empty step placeholder marked with a plus icon in the center. On the right, the panel lists available apps and tools. A search bar is displayed at the top of the panel for filtering apps. Red arrows highlight the empty step placeholder, the search bar, and items in the app list.

Add Wiresk Tools to your Flow

If you want to build a complex Flow, Wiresk offers a selection of tools at your disposal. Refer to Wiresk’s Tools

To add Tools in your Flow, Follow the same step as adding the Methods.

On the Flow builder screen, click on the plus button (+) then just click on the “Tool” tab and select the Tool that you want to add.

Screenshot of Wiresk Flow Builder showing a Gmail Trigger connected to an empty Method placeholder. A red arrow points to the empty step circle with a plus sign where the next action will be added. On the right side, the “Tool” tab is selected in the panel. Another red arrow highlights the “Tool” tab label at the top. A search bar is shown above a list of available tools.

You can refer to “How to Create a Flow” tutorial for more detailed instructions, including step-by-step guidance on mapping and configuration.

Triggers and Methods Settings Copy Link

If you need step-by-step details on setting up MySQL, check the Triggers and Methods Settings documentation.

When you configure a Trigger or Method in Wiresk, the settings panel lets you define how data is collected or sent, and the type of values you enter depends on the field.

Field Type	Description	Example Value
Authentication	Secure access credentials that connect Wiresk to the app.	Wiresk connection, API Key or OAuth Token
Filters or search	Criteria that narrow which records are retrieved.	Search =”QUERY”, Status = “Active” or Type = “Email”
Limits	Maximum number of records to process in one run.	Records number = 100 Page number = 1
Field Mapping	Defines how fields in one step map to another. Can be static or dynamic.	Static: Subject = “Report” Dynamic: Recipient = value from Trigger

Make sure you enter the right values so your Flow works the way you expect and gives the right results.

MySQL – Connection

Create a MySQL connection in Wiresk Copy Link

Add MySQL app in Wiresk Copy Link

Basic understanding of Flow creation Copy Link

Triggers and Methods Settings Copy Link