Self-host ToolJet

copy# ToolJet LTS + PostgreSQL — based on the in-built-PostgreSQL compose file and .env template from ToolJet's Docker Compose docs, pinned to v3.20.246-lts
# TOOLJET_HOST must be the address people will use (docs: public IP or domain, starting with http:// or https://) — replace SERVER_IP
PG_PASS=$(openssl rand -hex 16)
cat > .env <<EOF
TOOLJET_HOST=http://SERVER_IP:80
LOCKBOX_MASTER_KEY=$(openssl rand -hex 32)
SECRET_KEY_BASE=$(openssl rand -hex 64)
PG_DB=tooljet_production
PG_USER=postgres
PG_HOST=postgresql
PG_PASS=$PG_PASS
TOOLJET_DB=tooljet_db
TOOLJET_DB_USER=postgres
TOOLJET_DB_HOST=postgresql
TOOLJET_DB_PASS=$PG_PASS
PGRST_DB_URI=postgres://postgres:$PG_PASS@postgresql/tooljet_db
PGRST_HOST=localhost:3002
PGRST_JWT_SECRET=$(openssl rand -hex 32)
PGRST_SERVER_PORT=3002
PGRST_DB_PRE_CONFIG=postgrest.pre_config
WORKER=true
EOF
cat > docker-compose.yml <<'EOF'
services:
  tooljet:
    image: tooljet/tooljet:v3.20.246-lts
    platform: linux/amd64
    restart: always
    env_file: .env
    ports:
      - 80:80
    depends_on:
      - postgres
    environment:
      SERVE_CLIENT: "true"
      PORT: "80"
    command: npm run start:prod
  postgres:
    container_name: ${PG_HOST}
    image: postgres:16
    restart: always
    volumes:
      - ./postgres_data:/var/lib/postgresql/data
    environment:
      POSTGRES_USER: ${PG_USER}
      POSTGRES_PASSWORD: ${PG_PASS}
EOF
docker compose up -d
# → http://SERVER_IP:80