Execute SQL queries

Introduction

You can easily connect to a database and execute SQL queries in your tests.

The following databases are supported by our engine:

• MySQL
• PostgreSQL
• Microsoft SQL

To establish a new connection, select the Connect to Database option from the Action dropdown.

If you just want to execute an SQL query, use the Execute SQL Query action.

If you need to get the result from an SQL query, just use the Extract result from SQL Query option from the Set Variable action.

Steps

1. Connect to your database with one of the following actions:
   Connect to MySQL Database
Connect to PostgreSQL Database
Connect to Microsoft SQL Database
   
2. Select the Execute SQL Query action.
3. Add your SQL in the SQL Query input.

If you want to get the result from an SQL query, use the Extract result from SQL Query option from the Set Variable action.