How to access retool hosted postgres db on a 3rd party?

Queries and Resources
1

Hey All,

I'm using Retool's self hosted postgres db for an app I'm building. Is there a way to connect to that DB from another app? E.g pgAdmin 4 for example?

When I go view the db connection details I can't view the pass

image
image1144×154 3.87 KB

Thanks,
Dimitri

2

Hey @Dimitri_Lianoudakis, yes there is a way! Here is one of our docs that explains how to set it up.

3

Thanks for the link @Blake_Reed . However, I don;t see that option when I follow the instructions. I was speaking with a dev I hired for this project and they're telling me that the db they setup in retool is a managed db and not a retool database.

4

Hey! Would you mind sharing more about how you're self-hosting Retool?

If you're referring storage database that stores app and user information for your instance, then the way to connect to that depends on whether you've externalized it. If not, you should be able to enter the container running the Postgres database to access it, though how you do so depends on your particular deployment.

If you're not referring to the storage database at all and it's something else let us know!

5

Hi @Dimitri_Lianoudakis,

If you're selfhosting using Docker of K8's and you're using the postgres container that shipped with Retool On-prem, you would need to expose the Postgres container to public to be able to access it or add a pgadmin container within the same environment where Retool is running.

As you dev said it is using a managed db, I suspect it is an external database in eg. Azure, AWS or Supabase. You should be able to connect to that db using the credentials your dev probably setup.