Hello, I am trying to connect to my supabase account through the guide published on YouTube. However, when I click test connection, I get an error like this.
SASL: SCRAM-SERVER-FINAL-MESSAGE: server signature is missing
I also tried it as a string connection and it gave the same error.
Would you mind sharing screenshots of your resource? A lot has changed on the Retool side and the Supabase side since this video was created three years ago.
Are you setting it up using a direction connection or a transaction pooler? I found using the transaction pooler had no issue while the direction connection led to the same error.
Let me know if that works for you or if you have any question on how to find that information.
I just spent way too long banging my head on this, so I figured I’d save someone else time on this.
Here’s what I did:
In Retool I clicked “Autofill from connection string.”
I pasted the Postgres URL that Supabase shows in its dashboard (transaction pooler).
Connection kept failing.
The catch?
Supabase’s connection string sneaks in the placeholder YOUR-PASSWORD instead of your real one. Since Retool masks the password field, it’s almost impossible to notice that you pasted a dummy value.
Fix:
Head to your project Project name → Project Settings → Database → Database Password, copy the actual password, and paste it manually.
feature request for the Retool team:
A little eye icon to show/hide the password next to the field would make this sort of mistake way easier to spot.
Hi @btzo, thanks for coming by with a solution! We always appreciate those who come to share knowledge with other builders and make the community stronger.
I've submitted a feature request for the show/hide eye icon, as I agree that could be a low-lift way to avoid something that is otherwise difficult to debug once the incorrect password is inputted.