MySQL

Connect to MySQL database

Usage Instructions

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

Tools

`mysql_query`

Input

Parameter	Type	Required	Description
`host`	string	Yes	No description
`port`	number	Yes	No description
`database`	string	Yes	No description
`username`	string	Yes	No description
`password`	string	Yes	No description
`ssl`	string	No	No description
`query`	string	Yes	No description

Output

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

`mysql_insert`

Input

Parameter	Type	Required	Description
`host`	string	Yes	No description
`port`	number	Yes	No description
`database`	string	Yes	No description
`username`	string	Yes	No description
`password`	string	Yes	No description
`ssl`	string	No	No description
`table`	string	Yes	No description
`data`	object	Yes	No description

Output

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

`mysql_update`

Input

Parameter	Type	Required	Description
`host`	string	Yes	No description
`port`	number	Yes	No description
`database`	string	Yes	No description
`username`	string	Yes	No description
`password`	string	Yes	No description
`ssl`	string	No	No description
`table`	string	Yes	No description
`data`	object	Yes	No description
`where`	string	Yes	No description

Output

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

`mysql_delete`

Input

Parameter	Type	Required	Description
`host`	string	Yes	No description
`port`	number	Yes	No description
`database`	string	Yes	No description
`username`	string	Yes	No description
`password`	string	Yes	No description
`ssl`	string	No	No description
`table`	string	Yes	No description
`where`	string	Yes	No description

Output

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

`mysql_execute`

Input

Parameter	Type	Required	Description
`host`	string	Yes	No description
`port`	number	Yes	No description
`database`	string	Yes	No description
`username`	string	Yes	No description
`password`	string	Yes	No description
`ssl`	string	No	No description
`query`	string	Yes	Raw SQL query to execute (e.g., CREATE TABLE users (id INT PRIMARY KEY, name VARCHAR(255)))

Output

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

`mysql_introspect`

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

Input

Parameter	Type	Required	Description
`host`	string	Yes	No description
`port`	number	Yes	No description
`database`	string	Yes	No description
`username`	string	Yes	No description
`password`	string	Yes	No description
`ssl`	string	No	No description

Output

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

МойОфис myTarget

On this page

Usage Instructions

mysql_execute

mysql_introspect

Start building today

Trusted by over 100,000 builders.

The SaaS platform to build AI agents and run your agentic workforce.