Use Retool with YugabyteDB YSQL

Retool is a service for creating internal tools powered by your data. It provides the ability to connect and query your data sources in order to build rich user interfaces. Retool provides support for multiple data sources, including PostgreSQL.

Because YugabyteDB is PostgreSQL-compatible, Retool can connect to YugabyteDB as a PostgreSQL resource.

Connect

Your YugabyteDB cluster should be up and running. Refer to YugabyteDB Prerequisites.

To connect to YugabyteDB, create a new PostgreSQL resource in Retool as follows:

1. Supply a name for your resource.
2. Add the host address of your YugabyteDB instance.
3. Change the port from 5432 to 5433.
4. Change the database name to that of your YugabyteDB instance.
5. Provide the password for your YugabyteDB instance.
6. Optionally, to connect via SSL, provide the CA certificate.

If your cluster is in YugabyteDB Aeon, be sure to add the listed IP addresses to the cluster IP Allow List.

With a valid PostgreSQL resource, you can now query your YugabyteDB instance in Retool.