Retool is a popular low code/no code application builder, and works great with the retool Postgres connector.

You do this by adding a new resource:

1474 2436

Then, pick Postgres as the type:


In the Postgres window, you want:

  • as the host
  • 5432 as the host
  • Your username, database name & password from your database's connect tab
  • Choose Use SSL
  • Leave all of the certificate boxes empty
  • Click test & add connection!
2672 2196

You'll see your resource in the app editor, and you can use whatever SQL you want.