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

Triggers and Methods Settings Copy Link

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. If you need step-by-step details on setting up MySQL, check the Triggers and Methods Settings documentation.

MySQL – Connection

Create a MySQL connection in Wiresk Copy Link

Add MySQL app in Wiresk Copy Link

Triggers and Methods Settings Copy Link