[joshAg]

We really like your product! It's made it super easy to create internal dashboards and admins actions that we can safely trust nonengineers to use without making an entire website for them.

Got a question for the best way to (ab?)use the fact that retool already talks to the db. Say I've got a database that's off in some cloud and i've hooked it up to retool.

What's the best way to use retool as a psql connection, because i'm too lazy to configure and setup and start psql to do that (say, because I'd have to start up a google cloud sql proxy and make sure that's pointing at the right db, and make sure to use a nonstandard port if i've got a dev container up at the time and and and and...)?

Right now I've just got a personal dash that i edit that has an empty table and a query that i can preview, but i feel like there's gotta be a better way that doesn't involve biting the bullet and spending the time to make the bash commands for psql (or pgadmin) just work.

[dvdhsu]

Hi there! Thanks for the comments, and thank you for using Retool!

We have a product in beta that (I think) does what you're looking for: the Query Library (https://docs.retool.com/docs/query-library). This lets you run queries, save them, and share them across your company. LMK if that's what you're looking for?

(In the future, we will be adding more permissions, etc. to it. We are actively developing this right now and would love to get some feedback from you on it if you'd be open to it? I will have our engineer email you!)

[joshAg]

That's pretty close, and would definitely be super useful to us beyond just my personal use case. Saving would be absolutely awesome because right now I "save" queries by doing this [1] in the query editor and saving a giant comment block. Then when i want to run something i edit and uncomment the single query i need.

I just tried playing around with it, and it looks awesome, but I can't fully commit to it yet, because it doesn't have a way to select staging vs prod like my dash does.

I'd be happy to give feedback! My personal email is in my hn profile, but if you'd prefer i can email you from my work account.

[1]:

  -- select 
  -- select
  -- select
  -- update