Data Store - Postgresql
Navigate to the integration section located in the left-hand menu and find the Data Store PostgreSQL option.
Create free account
You can create a free account at: ElephantSQL - PostgreSQL as a Service
Once you have created your account, navigate to the Instance section at https://customer.elephantsql.com/instance and select
Once you open your instance, navigate to the "Details" section and copy the connection details.
Filling in Connection Details
Obtain the necessary information for your PostgreSQL database, such as host, username, password, and database name.
Paste the host server address, username, and database name into their respective fields.
Enter the password for your PostgreSQL database.
No need to specify a port or schema name, SSL mode, or CA certificate for this instance.
Don't need to Whitelist the IP Address.
Verifying Connection
Once you filled up all the details press “Save”. Now you can see the status is verified and also you can Sync and Create your records.
Creating a New Data Store
If you don't have existing data stores, press the sync button to fetch available data stores.
Alternatively, create a new data store by providing a name (e.g., "chatbot_data") and defining fields (e.g., Name, Email, Gender).
A new table has been successfully created. You can edit or view the record by clicking on "Browse."
You can view the records within the table and make edits, as well as add new ones as needed.
The same record has been successfully generated and stored in the database.
Accessing Database in Flow Builder
Inside the Flow Builder, access the database through an action block.
Select 'Integrations' and then 'Data Store' to edit the action.
Add a new record by specifying the data store, filling in relevant data, and saving the record ID.
You can use different functions as per your needs.
After using any of the functions, you can proceed to view and edit the data as needed.
Video Tutorials