skip to Main Content

I am following this guide to use Supabase locally with Datagrip: https://supabase.com/docs/guides/getting-started/local-development#why-develop-locally. However, I could not connect to local db using Datagrip in my MacBook Apple Silicon M1. While the Docker instance is running, I used postgres username with both anon and service_role keys as passwords but nothing seem to be working. Here is the status in my Terminal:
enter image description here

This is the connection setting and error I get in Datagrip:
enter image description here

Any help would be appreciated.

2

Answers


  1. Chosen as BEST ANSWER

    I have solved the issue. The password that works is "postgres". The Supabase document link above does not contain this info. I found it after looking at the KeyChain password in another MacBook where I had previously used Supabase local with Datagrip.


  2. The password for local Supabase is postgres. It shows up in the DB URL in the screenshot. In connection strings like these the username and password are separated by a colon (:). So here we can see postgres:postgres.

    Login or Signup to reply.
Please signup or login to give your own answer.
Back To Top
Search