Supabase SASL: SCRAM-SERVER-FINAL-MESSAGE: server signature is missing

[daBee]

Describe the problem/error/question

I cannot connect to a Supabase postgresql database. I can connect properly using Postico, a postgresql gui client.

What is the error message (if any)?

SASL: SCRAM-SERVER-FINAL-MESSAGE: server signature is missing

Please share your workflow

Credentials inserted that were working less than a month ago. The Supabase dashboard shows that it isn’t turned off. My other gui client (see above) works fine. I cannot connect using the n8n node.

Share the output returned by the last node

Could not load list - Please check your credential

Information on your n8n setup

• n8n version:
  1.79.3

• Database (default: SQLite):
  Postgresql hosted in Supabase

• n8n EXECUTIONS_PROCESS setting (default: own, main):
  No clue what this means.

• Running n8n via (Docker, npm, n8n cloud, desktop app):
  Self-hosted on a server.

• Operating system:
  AlmaLinux 9

[solomon]

To connect to Supabase’s Postgres database, please follow these instructions:

1. Click the connect button on the top of your Supabase dashboard:
   

2. Scroll down to “Transaction pooler” and click “view parameters”
   

   

3. Paste all that information into a new Postgres credential, in n8n
   

   

4. To find your database password, go back to Supabase in Project Settings > Database
   

   
   
   
   

5. Click “Reset Password” to be able to copy the password and paste that into the n8n credential.
   

   

6. Create a new Postres node in your workflow and select the credential. Now you have the “Upsert” option for you database
   

   

.

If my reply answers your question, please remember to mark it as a solution.