DEV Community

Cover image for Self Hosting Supabase with Docker - Guide
Jasper
Jasper

Posted on

Self Hosting Supabase with Docker - Guide

Self Hosting Supabase

This is a quick guide for self hosting Supabase, of course.
If I'm being honest the official guide is pretty bad so I'm going to try to make this better.

Prerequisites

  • A knowledge of how to use the terminal
  • A server with at least 2GB of RAM
  • A knowledge of your server's IP address

Installing Supabase

I assume you can login to your server via SSH and have docker and git installed.
If not check your distribution's documentation for how to install them.

# Change into your home directory
cd ~

# Clone the supabase repo
git clone --depth 1 https://github.com/supabase/supabase ~/temp-supabase

# Make your project directory
mkdir ~/supabase-project

# Copy over the docker stuff
cp -rf ~/temp-supabase/docker/* ~/supabase-project
cp -rf ~/temp-supabase/docker/.env.example ~/supabase-project/.env


# Change into the supabase directory
cd ~/supabase-project

# Download the docker images
docker compose pull
Enter fullscreen mode Exit fullscreen mode

Now we need to modify the .env file to setup JWT secrets and studio credentials.

Head to Generate JWT Secrets and generate a 32 or 64 character secret.
Copy the secret into the JWT_SECRET field in the ~/supabase-project/.env file.

Now go to this link and switch to the decoded tab. Change the token under verify signature to you JWT token you just generate earlier. Save the output on the left as SERVICE_ROLE_KEY in your .env file.

Now for the ANON_KEY go to this link and repeat the step before, replace your-secret-key-HERE with the JWT key you generated before, and put the generate string for the value ANON_KEY in the .env.

Generate 1 more JWT key that is 32 chars for the POSTGRES_PASSWORD on Generate JWT Secrets and put the generated string for the value POSTGRES_PASSWORD in the .env.

Last thing before we start the docker containers is to setup a username and password for the studio page.

Do this by changing DASHBOARD_USERNAME and DASHBOARD_PASSWORD in the .env file.

Now we can start the docker containers.

# Start the supabase instance in the background
cd ~/supabase-project
docker compose up -d

# Stop the supabase instance
docker compose down
Enter fullscreen mode Exit fullscreen mode

Now you can access the studio at http://your-server-ip:3000 and login with the username and password you set in the .env file.

Accessing the Database

If your using a ORM like Prisma or Drizzle you will probably want to access the database directly.
To do these use the following URL:

Note:
POSTGRES_DB defaults to postgres

postgres://postgres:[your-POSTGRES_PASSWORD]@[your-server-ip]:5432/[POSTGRES_DB]
Enter fullscreen mode Exit fullscreen mode

Top comments (2)

Collapse
 
yuricodesbot profile image
Yuri

Hello! Yuri from Supabase here! Nice observations! Would love for you to make a PR to our self-hosting doc

Collapse
 
jasper-clarke profile image
Jasper

Hello @yuricodesbot, I'd love to make a PR I'll work on it soon.
Biggest thing that needs fixing is the secret generator which unless it has been updated recently sadly doesn't work.