Create a Database Connection

User Role: Administrator, Workspace manager, Editor

You establish Connections by using a connection string, which includes information such as the type of database, the server name, the database name, user credentials, and other configuration details necessary for authentication and communication.

The database connection enables communication between Liquibase.io and the target database.

Procedure

1.       Select the Connections tab in the left navigation.

2.       Click the Add Connection button.

3.       Select the database platform of your choice. This example uses PostgreSQL.

You cannot edit the URL string if it does not match the Platform selected.

4.       Fill in your database Connection name and select the URL or Host radio option.

URL option

1. Type in your Database URL.

Host Option

1. Fill in the Hostname, Port, and Database Name.

The Database URL field cannot be edited but dynamically updates based on entries in the required fields.

Both URL and Host options

1.       Specify your database credentials in the Username and Password fields, and select the Save button.

Liquibase.io does not accept a database connection password that contains asterisks after the first character. Once your URL is entered, your Port and Database name will auto-populate.

Result

The database connection is successfully created.