Analytics cookies only (Google Analytics, PostHog). No ad networks, no cross-site tracking. See our privacy policy.
A BI tool built around dbt: it reads a dbt project's models and metrics, lets analysts and non-technical users explore them in a point-and-click query builder with generated SQL, build charts and dashboards, and schedule deliveries. Metrics and dimensions are defined in the dbt YAML, so definitions live in version control. A Node.js server with a React frontend, backed by PostgreSQL and S3-compatible storage.
Runs on a VPS from $24/mo (Kamatera 8GB, 8 GB RAM) · prices checked Nov 2026
Fits home hardware (894 MB measured idle, RAM only): Raspberry Pi 4 (4 GB) (arm64 untested), Raspberry Pi 5 (8 GB) (arm64 untested), Repurposed laptop (8 GB), Intel N100 mini PC (16 GB), AMD Ryzen mini PC (32 GB).
Pick Lightdash when your warehouse is already modelled in dbt and you want a BI layer that reads those models instead of asking analysts to rebuild them: it is built around dbt projects, so dimensions and metrics are defined in the dbt YAML (in version control), and people then explore them in a point-and-click query builder that generates the SQL, build charts and dashboards, and schedule deliveries. If you do not use dbt, it is the wrong tool. The repository's LICENSE makes everything outside `packages/backend/src/ee` MIT and puts that directory under the Lightdash Source Available License, which requires you to hold a valid Lightdash Enterprise Subscription and comply with Lightdash's terms to use it in production, hence our "MIT core with proprietary enterprise modules". It is TypeScript on Node.js with a React frontend. Our snippet is the repository's Compose file trimmed to the app, a pgvector PostgreSQL and MinIO as the required S3-compatible store, with generated secrets and the image pinned to `3.179.0`. The compose file also builds an optional headless-browser container; we left it out. We did not find an upstream RAM minimum, so our 4096 MB is an estimate. The catalog's Metabase and Redash start from SQL and a database connection and need no dbt project; Superset is the broader, heavier option.
Paid link — we earn a commission if you shop through it.
Run these commands on your server:
# Lightdash — BI on dbt projects, with PostgreSQL and MinIO storage — based on the upstream docker-compose.yml, pinned to 3.179.0
SERVER_IP=$(curl -fsS ifconfig.me)
cat > .env <<EOF
PGPASSWORD=$(openssl rand -hex 16)
LIGHTDASH_SECRET=$(openssl rand -hex 32)
MINIO_PASSWORD=$(openssl rand -hex 16)
SITE_URL=http://$SERVER_IP:8080
EOF
curl -fsSLo init-minio.sh https://raw.githubusercontent.com/lightdash/lightdash/3.179.0/docker/init-minio.sh && chmod +x init-minio.sh
cat > docker-compose.yml <<'EOF'
services:
lightdash:
image: lightdash/lightdash:3.179.0
restart: unless-stopped
depends_on:
- db
- minio
environment:
PGHOST: db
PGPORT: 5432
PGUSER: postgres
PGPASSWORD: ${PGPASSWORD}
PGDATABASE: postgres
LIGHTDASH_SECRET: ${LIGHTDASH_SECRET}
SITE_URL: ${SITE_URL}
PORT: 8080
SECURE_COOKIES: "false"
TRUST_PROXY: "false"
SCHEDULER_ENABLED: "true"
S3_ENDPOINT: http://minio:9000
S3_REGION: us-east-1
S3_BUCKET: default
S3_ACCESS_KEY: minioadmin
S3_SECRET_KEY: ${MINIO_PASSWORD}
S3_FORCE_PATH_STYLE: "true"
ports:
- 8080:8080
db:
image: pgvector/pgvector:pg15
restart: unless-stopped
environment:
POSTGRES_USER: postgres
POSTGRES_PASSWORD: ${PGPASSWORD}
POSTGRES_DB: postgres
volumes:
- db-data:/var/lib/postgresql/data
minio:
image: coollabsio/minio:RELEASE.2025-10-15T17-29-55Z
entrypoint: /init-minio.sh
restart: unless-stopped
environment:
MINIO_ROOT_USER: minioadmin
MINIO_ROOT_PASSWORD: ${MINIO_PASSWORD}
MINIO_DEFAULT_BUCKETS: default
volumes:
- minio-data:/data
- ./init-minio.sh:/init-minio.sh
volumes:
db-data:
minio-data:
EOF
docker compose up -d
timeout 240 bash -c 'until curl -fsS http://localhost:8080/api/v1/health >/dev/null; do sleep 3; done'
# → http://SERVER_IP:8080 — register the first user (it creates the organization), then connect a dbt projectLightdash's repository, compose file and configuration code flag these before you rely on it:
Lightdash used 894 MB of RAM at idle on GCP e2-standard-2 · Ubuntu 26.04 LTS · Docker 29.9.3 (first boot, measured Nov 2026). We list a minimum of 4096 MB.
The Lightdash install snippet is marked verified on Ubuntu 26.04 (Nov 2026).