MySQL
Connect to MySQL database
Configuration
Query (SELECT)
Operation
Query (SELECT)
Host*
localhost or your.database.host
Port*
3306
Database Name*
your_database
Username*
root
Password*
••••••••
SSL Mode
Preferred
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 |
rowCount | number | Number of rows returned |
Insert Data
Operation
Insert Data
Host*
localhost or your.database.host
Port*
3306
Database Name*
your_database
Username*
root
Password*
••••••••
SSL Mode
Preferred
Table Name*
users
Data (JSON)*
json
{
"name": "John Doe",
"email": "john@example.com",
"active": true
}
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 |
rowCount | number | Number of rows inserted |
Update Data
Operation
Update Data
Host*
localhost or your.database.host
Port*
3306
Database Name*
your_database
Username*
root
Password*
••••••••
SSL Mode
Preferred
Table Name*
users
Update Data (JSON)*
json
{
"name": "Jane Doe",
"email": "jane@example.com"
}
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 |
rowCount | number | Number of rows updated |
Delete Data
Operation
Delete Data
Host*
localhost or your.database.host
Port*
3306
Database Name*
your_database
Username*
root
Password*
••••••••
SSL Mode
Preferred
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 |
rowCount | number | Number of rows deleted |
Execute Raw SQL
Operation
Execute Raw SQL
Host*
localhost or your.database.host
Port*
3306
Database Name*
your_database
Username*
root
Password*
••••••••
SSL Mode
Preferred
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 |
rowCount | number | Number of rows affected |
Usage Instructions
Integrate MySQL into the workflow. Can query, insert, update, delete, and execute raw SQL.
Notes
- Category:
tools - Type:
mysql