Connecting Retool Postgresql database to third party database manager

💬 External Apps
1

Good morning,

I have been attempting to connect the Retool database with a third party database manager, specifically EMS SQL Manager for PostgreSQL without any luck.

Can anyone explain to me how to do that. It doesn't have to be EMS. If you use another program, please let me know.

Thank you.

2

Hey Tom,

So I don't have a direct answer to your question, but may I ask the reason to connect the retool db to a third party database manager?

3

Hey Miguel,

To be perfectly honest, I don 't like the Retool database manager. That is the only reason.

4

Yeah, that was my guess. I don't use it either. I'm very happy using Supabase, which it's free for your first 2 projects. You can easily migrate your tables by exporting/importing csv, and the connection to retool should be quite straightforward.

1 Like
5

I'll have to look into that.

6

Hi @tomm - I connect to the Retool DB with pgAdmin (pgAdmin 4 — pgAdmin 4 9.0 documentation). It's pretty simple to set it up; just get the connection info from the drop down at the top of the database page:

image
image702×650 22.6 KB

Are you running into a specific challenge setting it up?

2 Likes
7

@jg80, I have gotten everything set up and it appears to have connected, but I am not seeing any databases.

Here is a screenshot of what I am seeing. Does this look correct?

Screenshot 2025-03-05 063346
Screenshot 2025-03-05 063346332×871 37.1 KB

Is there a way to see a list of databases?

8

I believe you just need to expand “schemas” and you should be able to find it there.

1 Like
9

Yep, I got it now. Thanks.

1 Like