Database Activities
Run SQL queries against SQL Server, SQLite, MySQL, and PostgreSQL directly from your workflows. All database activities share a connection string and support parameterised queries to prevent SQL injection.
Database ConnectDatabase Connect
Open a connection to SQL Server, SQLite, or PostgreSQL database.
| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
Provider | String | Yes | SQLite | Database provider to connect to Allowed: SQLServer, PostgreSQL, SQLite |
ConnectionString | String | Yes | — | Database connection string (e.g., Data Source=mydb.db; or Server=localhost;Database=mydb;User Id=sa;Password=xxx;TrustServerCertificate=True) |
OutputVariable | String | No | dbConnection | Variable name to store the database connection for reuse |
Database TransactionDatabase Transaction
Begin, Commit, or Rollback a database transaction.
| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
Action | String | Yes | Begin | Transaction operation to perform Allowed: Begin, Commit, Rollback |
ConnectionVariable | String | Yes | dbConnection | Variable name containing the open database connection |
TransactionVariable | String | Yes | dbTransaction | Variable name to store/retrieve the transaction object |
IsolationLevel | String | No | ReadCommitted | Transaction isolation level (only used with Begin action) Allowed: ReadUncommitted, ReadCommitted, RepeatableRead, Serializable, Snapshot |
Execute QueryExecute Query
Execute a SQL query against SQL Server, SQLite, or PostgreSQL.
| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
ConnectionVariable | String | Yes | — | Variable name containing an open database connection (from Database Connect) |
Query | String | Yes | — | SQL query to execute (SELECT, INSERT, UPDATE, DELETE) |
QueryType | String | No | Select | Type of query to determine how results are handled Allowed: Select, NonQuery |
OutputVariable | String | No | queryResult | Variable to store query results (rows for SELECT, affected count for NonQuery) |
Execute Stored ProcedureExecute Stored Proc
Execute a stored procedure with parameters on SQL Server or PostgreSQL.
| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
ConnectionVariable | String | Yes | — | Variable name containing an open database connection (from Database Connect) |
ProcedureName | String | Yes | — | Name of the stored procedure to execute (e.g., dbo.GetCustomers) |
Parameters | String | No | — | Parameters in format: @Name=Value;@Age=25;@City={variableName} |
ResultType | String | No | DataSet | How to handle the stored procedure results Allowed: DataSet, Scalar, NonQuery |
CommandKind | String | No | StoredProcedure | Use StoredProcedure for procedure execution, or Text to run SQL text (useful for SQLite testing) Allowed: StoredProcedure, Text |
OutputVariable | String | No | spResult | Variable to store the procedure results |
Execute Stored ProcedureExecute Stored Procedure
Execute a stored procedure with parameters on SQL Server or PostgreSQL.
| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
ConnectionVariable | String | Yes | — | Variable name containing an open database connection (from Database Connect) |
ProcedureName | String | Yes | — | Name of the stored procedure to execute (e.g., dbo.GetCustomers) |
Parameters | String | No | — | Parameters in format: @Name=Value;@Age=25;@City={variableName} |
ResultType | String | No | DataSet | How to handle the stored procedure results Allowed: DataSet, Scalar, NonQuery |
CommandKind | String | No | StoredProcedure | Use StoredProcedure for procedure execution, or Text to run SQL text (useful for SQLite testing) Allowed: StoredProcedure, Text |
OutputVariable | String | No | spResult | Variable to store the procedure results |