Self-host Metabase

copy# Metabase Open Source + PostgreSQL for its own app data — based on the compose example in Metabase's Docker docs, pinned to v0.64.1
echo "MB_DB_PASS=$(openssl rand -hex 16)" > .env
cat > docker-compose.yml <<'EOF'
services:
  metabase:
    image: metabase/metabase:v0.64.1
    restart: unless-stopped
    ports:
      - 3000:3000
    environment:
      MB_DB_TYPE: postgres
      MB_DB_DBNAME: metabaseappdb
      MB_DB_PORT: 5432
      MB_DB_USER: metabase
      MB_DB_PASS: ${MB_DB_PASS}
      MB_DB_HOST: postgres
    depends_on:
      - postgres
    healthcheck:
      test: curl --fail -I http://localhost:3000/api/health || exit 1
      interval: 15s
      timeout: 5s
      retries: 5
  postgres:
    image: postgres:16
    restart: unless-stopped
    environment:
      POSTGRES_USER: metabase
      POSTGRES_DB: metabaseappdb
      POSTGRES_PASSWORD: ${MB_DB_PASS}
    volumes:
      - ./pg_data:/var/lib/postgresql/data
EOF
docker compose up -d
# first start takes a minute or two → http://SERVER_IP:3000 — the setup screen creates the admin account