AltFreeStack
Web Analyticsdocker-ready100% FOSSπŸ”΄ Full Β· ~2GB

OpenPanel: Open Source alternative to Mixpanel in 2026

OpenPanel combines web and product analytics (events, funnels, user profiles) in a modern dashboard, as a recent, self-hostable alternative to Mixpanel and Amplitude.

ℹ️ This single-container docker-compose doesn't match OpenPanel's real deployment: the ghcr.io/openpanel-dev/openpanel image isn't publicly pullable. The real project is 3 independent services (dashboard, api, worker β€” see lindesvard/openpanel-* on Docker Hub). We aren't rewriting that topology here without being able to verify each environment variable β€” check OpenPanel's official self-hosting docs.

License AGPL-3.07.1k starsWebsite GitHub Repository

Audit Snapshot

View notes β†’
  • License β€” Matches GitHub

  • GitHub β€” Active

  • Latest release β€” worker

  • Docker Compose β€” Not verified

  • Production β€” Not production-tested by AltFreeStack

OpenPanel vs. Mixpanel

Pros

  • Combines web and product analytics in a single tool

Things to consider

  • Young project, still small community
  • This catalog's docker-compose isn't deployable as-is (see note above) β€” the real deployment is 3 independent services

Quick Docker installation guide

Copy this docker-compose.yml, adjust the example passwords and run docker compose up -d on your server. See the full step-by-step guide β†’

πŸ’‘ Official SaaS or self-hosted with AltFreeStack?

  • On the official cloud: a recurring monthly fee and usage limits on Mixpanel.
  • On your own VPS: 100% free software on your own server, with no artificial row, project or user limits.
docker-compose.yml
version: "3.9"
services:
  openpanel:
    image: ghcr.io/openpanel-dev/openpanel:latest
    restart: unless-stopped
    ports:
      - "3000:3000"
    environment:
      - DATABASE_URL=postgresql://openpanel:change-me-postgres-password@openpanel-db:5432/openpanel # password must match the canonical db password below
      - CLICKHOUSE_URL=http://openpanel-ch:8123
    depends_on:
      - openpanel-db
      - openpanel-ch
  openpanel-db:
    image: postgres:15-alpine
    restart: unless-stopped
    environment:
      - POSTGRES_USER=openpanel
      - POSTGRES_PASSWORD=change-me-postgres-password # REQUIRED: generate a random secret before first run
      - POSTGRES_DB=openpanel
    volumes:
      - openpanel_pg_data:/var/lib/postgresql/data
  openpanel-ch:
    image: clickhouse/clickhouse-server:24-alpine
    restart: unless-stopped
    volumes:
      - openpanel_ch_data:/var/lib/clickhouse
volumes:
  openpanel_pg_data:
  openpanel_ch_data:

πŸš€ Deploy in 1 command

Recommended for beginners

Copy this single command and paste it into your freshly created VPS's console (Vultr, DigitalOcean...). It downloads the script, prints it to your screen so you can see exactly what it's about to do (never a blind direct pipe), and only then installs Docker if needed, writes the files with secrets already generated, and starts everything β€” no nano, no pasting code blocks.

curl -sSL ".../api/deploy?stack=openpanel" -o deploy.sh && cat deploy.sh && bash deploy.sh

This docker-compose corresponds to an actively maintained project β€” last commit today.

This docker-compose not working for you? Report it on GitHub β†’

Technical profile

License
AGPL-3.0
Category
Web Analytics
Replaces
Mixpanel, Amplitude
Tech stack
Next.jsPostgreSQLClickHouse

Under the hood

Database

PostgreSQL + ClickHouse

Language

TypeScript (Next.js)

Platforms

Web

Key features

  • Product events and funnels
  • Unified user profiles
  • Modern, fast dashboard

Preview

OpenPanel interface preview

Public image provided by OpenPanel on its own website.

πŸ’Ύ Backups in 3 steps (Day 2)

As long as the ./data folder (the "volume" mapped into the container) exists on your server, your data survives any restart or container update β€” that's the only thing you need to back up.

1. Create a compressed backup on the server

tar -czvf backup-$(date +%F).tar.gz ./data

2. Download it to your computer

From your computer's terminal (not your server's):

scp root@YOUR_IP:~/app/backup-*.tar.gz ./

3. Restore in case of emergency

tar -xzvf backup-file.tar.gz
🌐 Connect your domain with free SSL

Step 1 β€” Set up the DNS

In your domain registrar's dashboard (Cloudflare, Namecheap, GoDaddy...), create a record:

Type
A
Name/Host
@ (root domain) or a subdomain, e.g. app
Content/Value
Your server's public IP

Wait 5 to 15 minutes for the record to propagate across the internet.

Step 2 β€” Automatic reverse proxy with Caddy

One single file, no Nginx config or manual certificates β€” Caddy issues and renews Let's Encrypt HTTPS on its own.

Create a file called Caddyfile:

yourdomain.com {
    reverse_proxy localhost:3000
}

Start Caddy with this command (pulls the image and runs it in the background):

docker run -d -p 80:80 -p 443:443 --name caddy --restart always -v $PWD/Caddyfile:/etc/caddy/Caddyfile -v caddy_data:/data caddy