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
Output
MySQL Insert
Insert new record into MySQL database
Input
Output
MySQL Update
Update existing records in MySQL database
Input
Output
MySQL Delete
Delete records from MySQL database
Input
Output
MySQL Execute
Execute raw SQL query on MySQL database
Input
Output
MySQL Introspect
Introspect MySQL database schema to retrieve table structures, columns, and relationships