RAG AI Agent with Postgres as Memory

[michalvis]

Has anyone in the community successfully connected n8n to a Supabase PostgreSQL database? If so, could you please share the configuration details or any steps taken to resolve similar authentication issues? Any insights or recommendations would be greatly appreciated.

I’m currently working on integrating a RAG AI Agent into my local n8n setup, which is running in a Dockerized environment. When trying to connect to Supabase, I’m getting:

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

Here’s my n8n setup:

• n8n 1.65.2
• Postgres
• Running n8n via Docker (self-hosted-ai-starter-kit)
• MacOS 15.1

Here’s my RAG Agent Postgres memory setup:

And supabase account setup:

I’ve tried to flip Ignore SSL Issues and also enforce SSL connection (downloaded the cert from supabase and added it to /opt/custom-certificates).
Neither of this worked.

Many thanks!
Michal

[n8n]

It looks like your topic is missing some important information. Could you provide the following if applicable.

• n8n version:
• Database (default: SQLite):
• n8n EXECUTIONS_PROCESS setting (default: own, main):
• Running n8n via (Docker, npm, n8n cloud, desktop app):
• Operating system:

[Jon]

Hey @michalvis,

Welcome to the community

This is something that came up before and when doing a bit of digging it looked like it could be down to something funky with the user account or something Supabase does to the database.

Rather than connect through Supabase do you have an option to connect directly to the database?

[SEO_Butler]

I’m experiencing exactly the same issue. I did a fork update from GitHub (to my n8n on Render) and now everything works.