Help Centre › Building Processes
Description
Overview of DATABASE functions available in RPA. These functions allow you to connect to databases (MySQL, SQL Server, PostgreSQL, SQLite, ODBC), execute queries and statements, manage transactions, perform bulk operations, and import/export data to CSV and Excel files.
Available DATABASE Functions
- Connect to database: Open a named database connection for reuse across process steps.
- Disconnect from database: Close a named database connection, or all open connections.
- Run database query: Execute a SELECT query and store results as a list of dictionaries.
- Execute statement: Execute a non-query statement (INSERT, UPDATE, DELETE) and return the number of affected rows.
- Call stored procedure: Call a stored procedure and return its result set.
- Begin transaction: Start a database transaction (disables autocommit until commit or rollback).
- Commit transaction: Commit the current database transaction.
- Rollback transaction: Rollback the current database transaction, undoing all changes.
- Bulk insert rows: Insert multiple rows into a table from a list of dictionaries with configurable batch size.
- Import CSV to table: Read a CSV file and bulk-insert its contents into a database table.
- Export query to CSV: Execute a SELECT query and write the results to a CSV file.
- Export query to Excel: Execute a SELECT query and write the results to an Excel (.xlsx) file.
- List tables: List all table names in the connected database.
- List columns: Get column metadata (name, type, nullable, default) for a table.
- Check if table exists: Check whether a table exists in the connected database.