1. Log in to the Kuika platform and open the project you’ll be working on from the Apps screen.
2. Open the Datasources module from the top menu. In this module, you can view the data sources and actions in your app under the Recently modified and Data sources tabs, search using the Search by name field, and add a new data source.
3. Click the Create a Database card at the top of the screen. This card allows you to connect to MS SQL Server, PostgreSQL, and Oracle databases.
4. From the Databases list that opens, select the PostgreSQL (PostgreSQL database) option. You can use the ↑/↓ keys to navigate the list and the Enter key to make a selection.

1. Enter a name for your data source in the Name field (e.g., userguidepostgre).
2. Click the CREATE button to complete the process. To cancel the operation, use the CANCEL button; to return to the database selection, use the < PostgreSQL link.

Note: You can also start the process of adding a new data source by clicking the + icon next to the Sources heading in the left panel.

After these steps, the PostgreSQL connection settings screen opens. At the top of the screen, you’ll find the back button (←), the data source name (with a pencil icon to edit it), and the CREATE button to save the settings. You can enter the connection information using either the Enter fields or Connection string tabs in the Endpoint section.

To connect to a PostgreSQL database running locally, the PostgreSQL server must be accessible from the internet.

In the Endpoint section, select the Enter fields tab and fill in the following fields.

01 Endpoint

Contains the server information Kuika will connect to.

• Server (required): Enter the address of the server hosting your database (domain name or IP address). Example: myServerAddress
• Database (required): Enter the name of the PostgreSQL database you want to connect to. Example: myDataBase

02 Credentials

These are the credentials that are part of the connection string.

• User ID: Enter the username.
• Password: Enter the user’s password. You can show or hide the password using the eye icon.

03 Parameters

You can enter additional parameters to be added to the connection string in the Key and Value fields. When you fill in a row, a new blank row appears below it; you can delete an added row using the trash can icon.

• Key: The name of the connection parameter.
• Value: The value corresponding to the parameter.

Example parameters:

• Port: 5432
• SSL Mode: Require
• Application Name: KuikaApp
• Timeout: 30 (If a connection cannot be established within the specified time, in seconds, the operation times out.)

1. In the Endpoint section, select the Connection string tab.
2. Enter the connection string information for your PostgreSQL database in the Connection string (required) field. By default, the field uses the following template: Server=;Database=;User Id=;password=

Example format:

Server=myServerAddress;Database=myDataBase;User Id=myUsername;Password=myPassword;

Testing and Saving the Connection

1. Click the Test connection button in the Connection section on the right to check if the connection works.
2. If the connection is successful, click the CREATE button in the top-right corner to create your data source.

After saving, the tables in your database are automatically read and become available in Kuika.

By following these steps, you can connect a PostgreSQL data source to your Kuika applications.