# Apache Superset

> A free BI tool in the browser for charts, dashboards and SQL.

**Field:** Data Engineering  
**Category:** Analytics & BI  
**Also known as:** Superset

## Think of it like

It is like a free box of paints for your data. Anyone can use it to draw charts.

## Definition

Apache Superset is a free, open source BI tool that runs in a web browser. It was started at Airbnb and is now an Apache Software Foundation project. It connects to most SQL databases and warehouses. People build charts and dashboards with clicks, or write SQL in its SQL Lab. Teams run it on their own servers or pay for a hosted version.

## Example

A small firm runs Superset on its own server, linked to PostgreSQL. Every team gets dashboards, and no one pays per user.

## Why it matters

It gives teams a full BI tool with no licence cost per seat. That matters when hundreds of people need to see the data.

## Common mistake

Pointing it at the live app database. Heavy charts then slow the app. Point it at a warehouse or a copy.

## Three principles

- **Open source.** Free to run, an Apache project.
- **Clicks or SQL.** Charts by hand, or SQL Lab.
- **Many databases.** Connects to most SQL sources.

## Related terms

- [Metabase](https://learn.benibix.com/term/data/metabase)
- [Business Intelligence (BI)](https://learn.benibix.com/term/data/business-intelligence)
- [Dashboard](https://learn.benibix.com/term/data/dashboard)
- [PostgreSQL](https://learn.benibix.com/term/development/postgresql)

## Told apart from

- [Metabase vs Apache Superset](https://learn.benibix.com/compare/metabase-vs-apache-superset): People think Metabase and Superset are two copies of one free tool, but they are made for two very different kinds of user. In Metabase, anyone can ask a question by clicking, with no SQL. Superset is for people who write SQL, and it has many kinds of chart. Pick Metabase when most users do not code. Pick Superset when most of them write SQL.

![Data flows left to right: an app database and files are loaded into a data warehouse, a semantic layer sits on top of it, and BI tools read from that layer. The tools serve three uses: a dashboard, a quick ad hoc query and a self-service chart that a business user builds alone.](https://learn.benibix.com/diagrams/bi-flow.svg)

---

Source: https://learn.benibix.com/term/data/apache-superset
Author: Behnia Zarei (a developer in Vienna, Austria, who builds and teaches data, AI and business intelligence at BENIBIX)
Publisher: BENIBIX Learn (https://learn.benibix.com/)
Last updated: 2026-11-16
Licence: CC BY 4.0 (https://creativecommons.org/licenses/by/4.0/). Quote freely with attribution.
