The words Under construction in black text on a yellow background with diagonal black stipes surrounding it
I'm in the process of moving my site. It's still a work in progress. Please excuse the mess and broken links.

Connect Directly To A Supabase Database From DBeaver Or Other Database Clients

TODO: Pull subtitle into page object

It wasn't super obvious to me how to connect directly to a Supabase database from a client like DBeaver. This is how.

After you make a database, go to Settings in the nav (the little gear icon in the lower left at the time of this writing)

Under Project Settings, choose Database

That will reveal a Connection Info section. That's the data to use for connecting with DBeaver and other postgres SQL clients (e.g. from the psql postgres command line tool)

To use SSL, download the certificate from the "SSL Connection" section on the sage page.

Place that file somewhere convienent and then in DBeaver go to the "SSL" tab in the connection configuration (which is what you get when you first create a connection) and check the `Use SSL` to turn it on and then put the path to the certificate file in the `CA Certificate` field.

Debugging Stuff

I'm moving stuff around right now. All this below is helping me figure out where to put stuff

        -- title

Connect Directly To A Supabase Database From DBeaver Or Other Database Clients

-- p

It wasn't super obvious to me how to connect directly to a Supabase database from a client like DBeaver. This is how.

-- p

After you make a database, go to Settings in the nav (the little gear icon in the lower left at the time of this writing)

-- p

Under Project Settings, choose Database

-- p

That will reveal a Connection Info section. That's the data to use for connecting with DBeaver and other postgres SQL clients (e.g. from the psql postgres command line tool)

-- p

To use SSL, download the certificate from the "SSL Connection" section on the sage page.

-- p

Place that file somewhere convienent and then in DBeaver go to the "SSL" tab in the connection configuration (which is what you get when you first create a connection) and check the `Use SSL` to turn it on and then put the path to the certificate file in the `CA Certificate` field.


-- categories
-- SQL
-- Supabase

-- metadata
-- date: 2022-03-09 15:09:58
-- id: 26abdgvj
-- status: scratch
-- type: post
-- SCRUBBED_NEO: false
-- site: aws