Apache Superset 6 BI Dashboards

Deploys Apache Superset 6.1 for dashboards, SQL Lab and charts, with a Postgres metadata database, Redis, Celery workers and beat for async queries and scheduled reports, and Postgres, MySQL and ClickHouse drivers.

What you get

  • Superset web UI and API (gunicorn), plus a Celery worker with headless Chromium for reports and thumbnails
  • A Celery beat service, which must stay at one replica, to trigger scheduled reports
  • A one-shot init service that migrates the database, creates the admin and sets up roles
  • Postgres for metadata and Redis for the broker, results and caches
  • Drivers for Postgres, MySQL and ClickHouse; the image runs as a non-root user

Good for

  • Self-service dashboards on a product's Postgres or MySQL database, using a read-only user
  • Analytics on event data stored in ClickHouse
  • SQL Lab as a shared browser-based SQL editor with saved queries
  • Scheduled email reports and threshold alerts for KPIs

Services in this template

  • Postgres · image ghcr.io/railwayapp-templates/postgres-ssl:18
  • superset · from baranberkay96/superset-railway
  • Redis · image redis:8.2
  • superset-init · from baranberkay96/superset-railway
  • superset-worker · from baranberkay96/superset-railway
  • superset-beat · from baranberkay96/superset-railway

Questions people ask

How do I log in?

Wait for superset-init to finish, open the superset domain and sign in with SUPERSET_ADMIN_USERNAME (default admin) and the generated SUPERSET_ADMIN_PASSWORD from the superset service Variables tab. Then add a data source under Settings > Database Connections.

What drives the cost?

Six services run, but the web service and the Celery worker use the most memory; the worker also loads Chromium for reports. More users call for web replicas and heavy async queries or reports call for worker replicas.

Do email reports work out of the box?

No. Add SMTP_HOST, SMTP_PORT, SMTP_USER, SMTP_PASSWORD and SMTP_MAIL_FROM to the superset and superset-worker services. Until then reports run in dry-run mode. Outbound SMTP requires Railway's Pro plan; Slack notifications work on every plan.

How do I upgrade Superset?

The version is the FROM line in services/superset/Dockerfile. Check Superset's UPDATING.md, change the tag and push. The init service applies migrations and the other services wait for the new schema.

Is it an official Apache template?

No. It is a community template, not affiliated with or endorsed by the Apache Software Foundation. Superset is Apache-2.0; some bundled drivers carry other licences, such as mysqlclient under GPL-2.0.

Full template README

Deploy and Host Apache Superset with Railway

Apache Superset is an open-source business intelligence platform for exploring data, writing SQL and building interactive dashboards. This community template runs Superset 6 on Railway with a Postgres metadata database, Redis caching, Celery workers for asynchronous queries and scheduled reports, and drivers for Postgres, MySQL and ClickHouse.

About Hosting Apache Superset

A production Superset setup is more than the web app. Superset keeps its own metadata (users, charts, dashboards, saved queries) in a SQL database, uses Redis for caching and as the Celery broker, runs Celery workers for asynchronous SQL Lab queries, thumbnails and Alerts & Reports, and needs a single Celery beat process to trigger scheduled reports. This template wires those pieces together on Railway's private network. A one-shot init service migrates the metadata database, creates an admin with a generated password and sets up roles. The image extends the official lean image with database drivers and a configuration file driven entirely by Railway variables, and runs as a non-root user.

Common Use Cases

  • Self-service dashboards on top of your product's Postgres or MySQL database (use a read-only user).
  • Fast analytics on event data stored in ClickHouse.
  • SQL Lab as a shared, browser-based SQL editor with saved queries and access control.
  • Scheduled email reports and threshold alerts for KPIs.
  • Replacing per-seat BI licences with a self-hosted tool your team controls.

Dependencies for Apache Superset Hosting

  • Apache Superset 6 (apache/superset lean image plus drivers)
  • PostgreSQL (metadata database)
  • Redis (Celery broker, result backend and caches)
  • Optional: an SMTP server for alerts and email reports

Deployment Dependencies

Implementation Details

Service Role Public
superset Web UI and REST API (gunicorn) HTTPS domain
superset-worker Celery worker: async SQL Lab, reports (with headless Chromium), thumbnails, cache warm-up —
superset-beat Celery beat: triggers scheduled reports and housekeeping —
superset-init One-shot: superset db upgrade, admin user, superset init —
Postgres Metadata database —
Redis Broker, results and caches —

All Superset services build the same image (FROM apache/superset:6.1.0) and differ only by start command.

First login. Wait for superset-init to finish, open the superset domain and sign in with SUPERSET_ADMIN_USERNAME (default admin) and the generated SUPERSET_ADMIN_PASSWORD from the superset service's Variables tab. Then add a data source under Settings → Database Connections, for example postgresql://readonly:password@my-db.railway.internal:5432/app for a database in the same Railway project, or clickhousedb://user:password@clickhouse.railway.internal:8123/default.

Email reports. Add SMTP_HOST, SMTP_PORT, SMTP_USER, SMTP_PASSWORD and SMTP_MAIL_FROM to superset and superset-worker. Until then, reports run in dry-run mode. Outbound SMTP requires Railway's Pro plan; Slack notifications work on every plan.

Scaling. Add replicas to superset for more concurrent users and to superset-worker for more async queries and reports. Keep superset-beat at exactly one replica.

Pinning and upgrades. The Superset version is the FROM line in services/superset/Dockerfile; driver versions are pinned next to it. To upgrade, check Superset's UPDATING.md, change the tag and push. superset-init applies migrations and the other services wait for the new schema.

Why Deploy Apache Superset on Railway?

Railway keeps Superset, its metadata database, Redis and workers on one private network next to the databases you want to analyse, so dashboards query your data without exposing it publicly. Scaling web and worker capacity is a replica setting, and you pay for actual usage rather than per-seat BI pricing.

Guides for this template

View Apache Superset 6 BI Dashboards on railway.com

Similar templates

TemplateCategoryDeploymentsDeploys
Umami
An open source, privacy-focused alternative to Google Analytics
Analytics4,236
Metabase
Fast analytics and integrated tooling for companies exploring their data
Analytics2,642
Plausible Analytics
An easy to use, privacy-friendly, open-source Google Analytics alternative
Analytics915
Formbricks
An open source surveys & experience management solution
Analytics693
SearXNG | Open Source Search API for AI Agents
Self-Host SearXNG. Open source, AI-ready search, 70+ engines combined
Analytics140
PostHog Product Analytics SuiteTracklayer
Self-hosted product analytics, session replay, feature flags and A/B tests.
Analytics14