MySQL

Configuration

Query (SELECT)

Operation

Query (SELECT)

Host*

localhost or your.database.host

Port*

3306

Database Name*

your_database

Username*

root

Password*

••••••••

SSL Mode

Select...

SQL Query*

sql

SELECT * FROM users WHERE active = true

Query (SELECT) (mysql_query)

Execute SELECT query on MySQL database

Input

Parameter	Type	Required	Description
`host`	string	Yes	MySQL server hostname or IP address
`port`	number	Yes	MySQL server port (default: 3306)
`database`	string	Yes	Database name to connect to
`username`	string	Yes	Database username
`password`	string	Yes	Database password
`ssl`	string	No	SSL connection mode (disabled, required, preferred)
`query`	string	Yes	SQL SELECT query to execute

Output

Parameter	Type	Description
`message`	string	Operation status message
`rows`	array	Array of rows returned from the query

Insert Data

Operation

Insert Data

Host*

localhost or your.database.host

Port*

3306

Database Name*

your_database

Username*

root

Password*

••••••••

SSL Mode

Select...

Table Name*

users

Data (JSON)*

json

{\n "name": "John Doe",\n "email": "john@example.com",\n "active": true\n}

Insert Data (mysql_insert)

Insert new record into MySQL database

Input

Parameter	Type	Required	Description
`host`	string	Yes	MySQL server hostname or IP address
`port`	number	Yes	MySQL server port (default: 3306)
`database`	string	Yes	Database name to connect to
`username`	string	Yes	Database username
`password`	string	Yes	Database password
`ssl`	string	No	SSL connection mode (disabled, required, preferred)
`table`	string	Yes	Table name to insert into
`data`	object	Yes	Data to insert as key-value pairs

Output

Parameter	Type	Description
`message`	string	Operation status message
`rows`	array	Array of inserted rows

Update Data

Operation

Update Data

Host*

localhost or your.database.host

Port*

3306

Database Name*

your_database

Username*

root

Password*

••••••••

SSL Mode

Select...

Table Name*

users

Update Data (JSON)*

json

{\n "name": "Jane Doe",\n "email": "jane@example.com"\n}

WHERE Condition*

id = 1

Update Data (mysql_update)

Update existing records in MySQL database

Input

Parameter	Type	Required	Description
`host`	string	Yes	MySQL server hostname or IP address
`port`	number	Yes	MySQL server port (default: 3306)
`database`	string	Yes	Database name to connect to
`username`	string	Yes	Database username
`password`	string	Yes	Database password
`ssl`	string	No	SSL connection mode (disabled, required, preferred)
`table`	string	Yes	Table name to update
`data`	object	Yes	Data to update as key-value pairs
`where`	string	Yes	WHERE clause condition (without WHERE keyword)

Output

Parameter	Type	Description
`message`	string	Operation status message
`rows`	array	Array of updated rows

Delete Data

Operation

Delete Data

Host*

localhost or your.database.host

Port*

3306

Database Name*

your_database

Username*

root

Password*

••••••••

SSL Mode

Select...

Table Name*

users

WHERE Condition*

id = 1

Delete Data (mysql_delete)

Delete records from MySQL database

Input

Parameter	Type	Required	Description
`host`	string	Yes	MySQL server hostname or IP address
`port`	number	Yes	MySQL server port (default: 3306)
`database`	string	Yes	Database name to connect to
`username`	string	Yes	Database username
`password`	string	Yes	Database password
`ssl`	string	No	SSL connection mode (disabled, required, preferred)
`table`	string	Yes	Table name to delete from
`where`	string	Yes	WHERE clause condition (without WHERE keyword)

Output

Parameter	Type	Description
`message`	string	Operation status message
`rows`	array	Array of deleted rows

Execute Raw SQL

Operation

Execute Raw SQL

Host*

localhost or your.database.host

Port*

3306

Database Name*

your_database

Username*

root

Password*

••••••••

SSL Mode

Select...

SQL Query*

sql

SELECT * FROM table_name

Execute Raw SQL (mysql_execute)

Execute raw SQL query on MySQL database

Input

Parameter	Type	Required	Description
`host`	string	Yes	MySQL server hostname or IP address
`port`	number	Yes	MySQL server port (default: 3306)
`database`	string	Yes	Database name to connect to
`username`	string	Yes	Database username
`password`	string	Yes	Database password
`ssl`	string	No	SSL connection mode (disabled, required, preferred)
`query`	string	Yes	Raw SQL query to execute

Output

Parameter	Type	Description
`message`	string	Operation status message
`rows`	array	Array of rows returned from the query

Usage Instructions

Integrate MySQL into the workflow. Can query, insert, update, delete, and execute raw SQL.

Notes

Category: tools
Type: mysql

MySQL

On this page