First things first, you need Docker on your machine to get Supabase up and running. Head over to the official website to download and install Docker.

Next, let's create a Docker network so Supabase and its buddies can chat with each other:

docker network create supabase-network

Now, we need to set up some environment variables. Create a .env file and pop in the following details:

POSTGRES_PASSWORD=your_postgres_password
POSTGRES_DB=your_database_name
ANON_KEY=your_anon_key
SERVICE_KEY=your_service_key

Make sure this file is in your project directory.

Time to create a docker-compose.yml file in your project directory. Add this content:

version: '3.8'
services:
  db:
    image: postgres:13
    container_name: supabase_db
    restart: unless-stopped
    environment:
      POSTGRES_PASSWORD: ${POSTGRES_PASSWORD}
      POSTGRES_DB: ${POSTGRES_DB}
    networks:
      - supabase-network

  auth:
    image: supabase/gotrue:latest
    container_name: supabase_auth
    restart: unless-stopped
    environment:
      GOTRUE_DATABASE_URL: postgres://postgres:${POSTGRES_PASSWORD}@db:5432/${POSTGRES_DB}
      GOTRUE_SITE_URL: http://localhost:8000
      GOTRUE_API_URL: http://localhost:8000/auth/v1
      GOTRUE_JWT_SECRET: ${SERVICE_KEY}
    networks:
      - supabase-network
    depends_on:
      - db

  api:
    image: supabase/postgrest:latest
    container_name: supabase_api
    restart: unless-stopped
    environment:
      PGRST_DB_URI: postgres://postgres:${POSTGRES_PASSWORD}@db:5432/${POSTGRES_DB}
      PGRST_DB_SCHEMA: public
      PGRST_DB_ANON_ROLE: anon
      PGRST_JWT_SECRET: ${ANON_KEY}
    networks:
      - supabase-network
    depends_on:
      - db

  storage:
    image: supabase/storage-api:latest
    container_name: supabase_storage
    restart: unless-stopped
    environment:
      POSTGREST_URL: http://localhost:3000
      PGRST_JWT_SECRET: ${ANON_KEY}
      DATABASE_URL: postgres://postgres:${POSTGRES_PASSWORD}@db:5432/${POSTGRES_DB}
    networks:
      - supabase-network
    depends_on:
      - db

  realtime:
    image: supabase/realtime:latest
    container_name: supabase_realtime
    restart: unless-stopped
    environment:
      DB_HOST: db
      DB_PORT: 5432
      DB_NAME: ${POSTGRES_DB}
      DB_USER: postgres
      DB_PASSWORD: ${POSTGRES_PASSWORD}
      REALTIME_PORT: 4000
    networks:
      - supabase-network
    depends_on:
      - db

networks:
  supabase-network:
    driver: bridge

This setup includes PostgreSQL, GoTrue, PostgREST, Storage API, and Realtime services for Supabase.

Navigate to your project directory and fire up all the services with Docker Compose:

docker-compose up -d

This command will build and start all the containers in detached mode. Easy peasy!

Let's make sure everything is running smoothly. Check the status of the containers:

docker-compose ps

You should see that all services are "Up". If not, well, time to do some troubleshooting!

Now, let's interact with Supabase:

• PostgreSQL: Use a client like psql or a GUI like pgAdmin to access your PostgreSQL instance.
• GoTrue (Authentication): Access it via http://localhost:8000/auth/v1.
• Realtime: Check Realtime subscriptions at http://localhost:4000.

Make sure you're hitting the right endpoints and managing your containers properly.