Skip to main content

MySQL

Connect to and interact with MySQL databases for data operations, automation, and integration.

Overview​

The MySQL package provides database connectivity for MySQL and MariaDB databases. Use it when you need to query data, insert records, perform transactions, or integrate automation workflows with MySQL databases.

Key Features​

  • Query Execution - Run SELECT queries and get results
  • Data Modification - INSERT, UPDATE, DELETE operations
  • Transactions - Manage database transactions with commit/rollback
  • Backup & Restore - Backup and restore database
  • Wait Operations - Wait for data conditions to be met

Available Nodes​

  • Connect - Establish connection to MySQL database
  • Disconnect - Close database connection
  • Query - Execute SELECT query and return results
  • Non Query - Execute INSERT, UPDATE, DELETE statements
  • Insert - Insert data into a table
  • Start Transaction - Begin a database transaction
  • Commit - Commit the current transaction
  • Backup - Create database backup
  • Restore - Restore database from backup
  • Wait Table - Wait for table to have rows
  • Wait Row - Wait for specific row condition
  • Wait Column - Wait for column value condition

When to Use This Package​

  • Data Extraction: Query and export data from MySQL
  • Data Entry: Insert automation results into database
  • Report Generation: Pull data for automated reports
  • System Integration: Connect RPA with MySQL backend
  • Database Maintenance: Backup and restore operations

Typical Workflow​

  1. Connect with database credentials
  2. Query to retrieve data
  3. Process data in your automation
  4. Insert or Non Query to write results
  5. Disconnect when finished

Transaction Support​

For atomic operations:

  1. Start Transaction
  2. Perform multiple insert/update operations
  3. Commit if all succeed

Wait Operations​

Wait nodes are useful for:

  • Waiting for data to arrive before processing
  • Synchronizing with external systems
  • Polling for status changes