PostgreSQL
This page gives information to connect Appsmith to a PostgreSQL database and to read and write data in your applications.
Connect PostgreSQL
caution
If you are a cloud user, you must configure the pg_hba.conf
file to whitelist the IP addresses 18.223.74.85
and 3.131.104.27
of the Appsmith deployment on your database instance before connecting to a database. See Client Authentication for more details.
Connection parameters
The following section is a reference guide that provides a complete description of all the parameters to connect to a PostgreSQL database.

Connection Mode
- Read Only: This mode permits read-only transactions by default.
- Read/Write: This mode permits both read-write transactions by default.