MySQL

Usage Instructions

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

Execute SELECT query on MySQL database

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 (e.g., my_database)
`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 (e.g., SELECT * FROM users WHERE active = 1)

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

Insert new record into MySQL database

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 (e.g., my_database)
`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 (e.g., users, orders)
`data`	object	Yes	Data to insert as key-value pairs

Update existing records in MySQL database

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 (e.g., my_database)
`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 (e.g., users, orders)
`data`	object	Yes	Data to update as key-value pairs
`where`	string	Yes	WHERE clause condition (without WHERE keyword)

Delete records from MySQL database

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 (e.g., my_database)
`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 (e.g., users, orders)
`where`	string	Yes	WHERE clause condition (without WHERE keyword)

Execute raw SQL query on MySQL database

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 (e.g., my_database)
`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 (e.g., CREATE TABLE users (id INT PRIMARY KEY, name VARCHAR(255)))

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

Introspect MySQL database schema to retrieve table structures, columns, and relationships

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 (e.g., my_database)
`username`	string	Yes	Database username
`password`	string	Yes	Database password
`ssl`	string	No	SSL connection mode (disabled, required, preferred)

Parameter	Type	Description
`message`	string	Operation status message
`tables`	array	Array of table schemas with columns, keys, and indexes
`databases`	array	List of available databases on the server