Assistance Needed with Supabase and n8n Integration on Local Docker Setup
Hi everyone! 👋
I'm currently working on a project where I'm hosting Supabase locally using Docker and trying to integrate it with n8n for automation purposes. However, I’ve run into a bit of a roadblock and would really appreciate any guidance or tips from those who might have faced a similar challenge.
Here's what I've done so far:
Successfully started Supabase locally using supabase start via the CLI.
n8n is set up through docker as well and I'm trying to link it to my Supabase database. n8n is working on other flows.
The Issue:
n8n is asking for a host URL and a secret key to connect to the database. I believe I’ve correctly identified the host URL from the Supabase CLI output, but I'm unsure about the correct secret key to use, or if there’s something specific I’m missing in the configuration. On cloud there is a gear icon where I can get details of the API. In the local system, there is no gear icon. 😳
What I’ve Tried:
Using the API URL, and any and all of the secret keys, but not one of these seem to work. These are the ones I found after pressing "Supabase start"
My Questions:
Has anyone successfully linked n8n to a locally hosted Supabase instance? If so, what did your setup look like?
Are there any common pitfalls or additional configuration steps I might be overlooking?
Any advice, tips, or resources would be immensely helpful! 🙏
Thanks in advance to anyone who can help out. I'm really excited to get this integration working and would love to learn from this awesome community.
Cheers! 🎉
5 Replies
I see that selfhosting options is not pulling much support on the discord channel, enven form other posts. If I can find a solution I will post it here. 😉
Did you manage to get this to work? Got the Service role secret and correct address but still gives me unauthorised error
@Data Swami @WernerLouw did either of u fix this issue? Im currently dealing with the same problem.
I tried these urls:
http://supabase:this_password_is_insecure_and_should_be_updated@kong:8000/
http://supabase-kong:8000/rest/v1/users
http://supabase-kong:8000
The output for all was unauthorized but when running curl on this url (
http://supabase-kong:8000/rest/v1/users) from inside the n8n shell to try forming a connection i get a successful connection. The curl command contains the my supabase api key.
when running
(http://supabase:this_password_is_insecure_and_should_be_updated@kong:8000/) i get a 307 status code from the site as a redirect but still registers.
What was your approach to filling in the host category without having issues whether its misplaced tags placed by n8n in the url or its unauthorization issues.
Haven't managed to so I switched to using qdrant for my vector store
@Data Swami @BC
I eventually did get it to work. I removed the n8n instance from Docker, and then got it to work. Other than this, I was not able to get it to work.
@Data Swami apologies I missed your message. 😳
@Data Swami apologies I missed your message. 😳