MySQL

Use cases and templates: MySQL integration for AI agents

Use MySQL to query rows, insert or modify records, execute raw SQL, and inspect databases, tables, columns, keys, and indexes. Configure the host, port, database, credentials, and SSL mode for the target server.

Query returns rows and a row count. Insert, update, and delete operations accept the data or WHERE clause documented below. Raw SQL can also change schema; use a database account with the permissions the workflow needs.

Use the block

Query, insert, update, delete, and execute raw SQL.

Actions

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 (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)

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 (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

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 (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)

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 (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)

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 (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)))

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	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)

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

MySQL

On this page