SQL Connection

The SQL Сonnection command establishes a connection to the SQL server and saves the connection ID in a variable.

SQL Server
Select the type of SQL server - MySQL or PostgreSQL.

Host
Specify the host of SQL server you want to connect to. If not specified, localhost will be used.

1localhost
2127.0.0.1

Port
Specify the port for connecting to the SQL server. If not specified, then 3306 port for MySQL and 5432 port for PostreSQL will be used.

User name
Provide a username to connect to the server.

Password
Password to connect to the server. For security reasons, do not specify it explicitly.

Database Name
Specify the database name.

Result Variable
Specify the name of the variable to which the connection identifier will be assigned. Use this name in the SQL connection field in other commands for working with the database.