MySQL
Connect to MySQL database
The MySQL tool enables you to connect to any MySQL database and perform a wide range of database operations directly within your agentic workflows. With secure connection handling and flexible configuration, you can easily manage and interact with your data.
With the MySQL tool, you can:
- Query data: Execute SELECT queries to retrieve data from your MySQL tables using the
mysql_query
operation. - Insert records: Add new rows to your tables with the
mysql_insert
operation by specifying the table and data to insert. - Update records: Modify existing data in your tables using the
mysql_update
operation, providing the table, new data, and WHERE conditions. - Delete records: Remove rows from your tables with the
mysql_delete
operation, specifying the table and WHERE conditions. - Execute raw SQL: Run any custom SQL command using the
mysql_execute
operation for advanced use cases.
The MySQL tool is ideal for scenarios where your agents need to interact with structured data—such as automating reporting, syncing data between systems, or powering data-driven workflows. It streamlines database access, making it easy to read, write, and manage your MySQL data programmatically.
Usage Instructions
Integrate MySQL into the workflow. Can query, insert, update, delete, and execute raw SQL.
Tools
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 |
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 |
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 |
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 |
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 |
Notes
- Category:
tools
- Type:
mysql