mrkeyoor.com_
Wed 16 Sept 19:01 UTC
Dataevaluationupdated 12 Sept 2026

superset review

Apache Superset is a self-hosted business intelligence application for exploring SQL data, writing queries, building charts, and sharing dashboards. It gives analysts a visual workspace while administrators connect database engines, define access, and optionally expose an MCP server to AI clients.

+81stars / 7d
Verdict

Our Superset run installed 162 packages in 88 seconds and built in 13 seconds, but pytest stopped after 200 collection/setup errors because SQLite lacked the css_templates table. Superset is worth the operating cost for a staffed data platform that needs broad SQL connectivity, detailed permissions, and several ways to publish analysis. Pick Metabase for a gentler business-user tool, Lightdash for file-based metric governance, or Grafana for observability.

We ran it

Lab card: what happened when we ran supersetScreenshot of superset (superset.apache.org)
Install✓ · 88s162 packages · 476 MB
Build✓ · 13s
Tests✗ · 86s1 passed · 0 failed · 1 skipped · 200 errors of 201 (pytest)
Known vulns1(pip-audit)
Repo10740 files~1,424,478 lines of source · 288.1 MB · 48 CI workflows · Dockerfile · tests dir

Answers from our run

Does superset build from source?

Dependencies installed in 88 seconds (162 packages), and the build succeeded in 13 seconds. We cloned commit f2610e9 into a clean Debian container with 3 CPUs and no project-specific setup.

Do superset's tests pass?

Yes: 1 of 201 passed when we ran the project's own test command (pytest), with 200 collection errors. Some failures need services or credentials a bare container does not have.

Does superset have known vulnerabilities in its dependencies?

pip-audit flagged 1 known advisory in the dependency tree at the time of our run.

Who should not use superset?

Teams committed to a native Windows deployment: the Docker Compose guide says Windows has no official support.

What are the alternatives to superset?

Metabase, Lightdash, Grafana. Our Superset run installed 162 packages in 88 seconds and built in 13 seconds, but pytest stopped after 200 collection/setup errors because SQLite lacked the css_templates table.

Setup2/5Build passed; test setup stopped at 200 database errors
Docs4/5Wide admin coverage, but PyPI worker setup is left to operators
Community5/574,723 stars, a same-day push, and 169 open issues
Maturity4/56.1.0 has deep features, with current data and MCP regressions

Discussed on

  1. hnApache Superset 1.196 points
  2. hnApache Superset – A Data Visualization and Data Exploration Platform3 points
  3. hnApache Superset – A Data Visualization and Data Exploration Platform3 points
  4. hnApache Superset 1.0 Released3 points

Who it’s for

Data teams that need one shared SQL editor, chart builder, and dashboard catalog across several data engines.
Analysts who want visual chart creation but still need direct SQL for harder questions.
Platform engineers prepared to own database drivers, authentication, caching, workers, backups, and upgrades.
Product teams willing to test Superset's API, embedded dashboards, or MCP tools against their exact roles and datasets.

Who it’s NOT for

Teams committed to a native Windows deployment: the Docker Compose guide says Windows has no official support.
Operators who want the supplied Compose stack to provide highly available production service: Superset explicitly limits that path to a single host and does not recommend it for production use.
Anyone expecting scheduled screenshots and emails after a basic install: alerts and reports are disabled by default and need Celery, a scheduler, message broker, credentials, and a headless browser.
MCP users who need chart edits to preserve every omitted setting today: open issue 44176 reports that update_chart can reset color schemes and row limits to defaults.
Teams displaying identifiers or measurements beyond 64-bit integer range on 6.1.0: open issue 44079 reports failures in SQL Lab and charts, with text casting offered only as a workaround.

Setup reality

Our sandbox install succeeded in 88 seconds, adding 162 packages and using 476 MB; the build succeeded in 13 seconds. Tests exited 1 after 86 seconds: 1 passed, 0 failed, 1 skipped, and 200 collection/setup errors out of 201. The repeated SQLite error was no such table: css_templates.

A useful deployment needs a unique secret key, initialized metadata database, engine-specific drivers and credentials, authentication, and role design. Async queries, caching, alerts, or reports can add Redis, Celery workers, a scheduler, SMTP or Slack credentials, and a headless browser.

Docker Compose creates the supporting services, but Superset documents it as a single-host development route without high availability, not a production stack. The checkout itself was 288.1 MB with 10,740 files and about 1,424,478 source lines. Pip-audit found 1 known vulnerability, which the supplied result did not identify by package or severity.

Superset 6.1.0 covers charts, SQL, dashboards, and MCP

Superset 6.1.0 is a browser-based business intelligence application for teams working with SQL data. Its visual chart builder sits beside SQL Lab, shared dashboards, datasets, a light semantic layer, and an API. Any SQL-speaking store can fit when it has a Python DB-API driver and SQLAlchemy dialect. This is useful when analysts need room to explore but administrators still have to control which data and actions each role can reach.

Our commit f2610e9 checkout contained 10,740 files, about 1,424,478 source lines, and 288.1 MB before installation. The size is visible in the architecture: a Flask backend, React frontend, Webpack assets, chart plugins, migrations, database connectors, and deployment material all live here. A team changing chart behavior or security policy is taking on a large application, with review and upgrade work to match.

Superset 6.1.0 production needs several services

Superset 6.1.0's architecture separates the application from its metadata database, then adds caching and worker or scheduler processes for selected features. A PyPI install creates only the application. The official architecture page says configuration of cache, worker, and beat for that route is not covered there. PostgreSQL and MySQL are the tested metadata stores, while SQLite is discouraged in production for security, scale, and data-integrity reasons.

The 162-package environment used 476 MB before any warehouse driver chosen for a real deployment. Operators still need a unique secret key, database credentials, migrations, users, roles, and backups. Async SQL or scheduled reports can bring Redis, Celery, a scheduler, and a browser into the stack. The supplied Docker Compose files create supporting services, but Superset says that single-host route lacks high availability and is not recommended for production.

What happened when we ran it

Our sandbox installed Superset in 88 seconds and built it in 13 seconds. We cloned commit f2610e9 on August 22, 2026, then used an unprivileged Debian container with 3 CPUs, 8 GB of RAM, no secrets, and the Python 3.12 uv image named in our measurement setup. Installation added 162 packages and completed successfully, so the repository can reach a finished build in that clean environment.

Pytest exited 1 after 86 seconds. It recorded 1 passed, 0 failed, 1 skipped, and 200 collection or setup errors out of 201 before stopping. The log repeatedly showed SQLite querying a missing table named css_templates. That establishes the absent test database state, but it does not explain why the table was absent. Pip-audit also found 1 known vulnerability without naming its package or severity.

Superset 6.1.0 does not replace warehouse permissions

Superset 6.1.0's security guide says the application is not a database firewall. Its secret key signs session cookies and protects stored database credentials, while application roles govern features and datasets. Those controls sit above the actual warehouse account. A broad credential behind a restricted dashboard can still expose more than intended through SQL Lab or another permitted route, so adoption should include least-privilege database users and adversarial role tests.

Our audit's 1 known vulnerability needs package and severity identification before release; the count alone cannot tell an operator whether the affected code ships. Data correctness deserves the same discipline. Open issue 44079 reports that 6.1.0 cannot display a numeric value beyond 64 bits in SQL Lab or a chart, producing a BigInt conversion error. The reporter's workaround is casting the value to text, which is poor consolation if large numeric identifiers are normal data.

Superset 5.0+ gives AI clients a separate MCP process

Superset 5.0+ includes an MCP server that runs beside the main application and can list dashboards, query datasets, execute SQL, and create charts. It requires Python 3.11+ and the fastmcp package. The documented production path validates bearer tokens and maps claims to Superset users; development mode impersonates one configured user. Exposing that mode outside a local machine would give every request the same account's permissions.

The repository contains 48 CI workflow files, yet MCP consumers should still regression-test the exact write tools they enable. Open issue 44176 reports that editing one field through update_chart can replace an omitted color scheme and row limit with defaults. In its reproduction, a row limit of 50 became 10,000. Until that issue is resolved in the version you run, an AI-driven chart edit needs a before-and-after diff and a narrowly scoped user.

September activity shows health and unfinished edges

GitHub showed 74,723 stars, 169 open issues, and 616 open issues plus pull requests on September 12, 2026. The last push was that same day. Release 6.1.0 was published May 13, so the newer code and issue activity are better evidence of ongoing maintenance than the release date alone. The open queue includes fresh reports across charts, semantic views, MCP, and SQL behavior, which fits a project with this much surface area.

The 13-second build makes a source trial inexpensive, while 200 setup errors make a clean database bootstrap a release gate for contributors. Superset is the right choice when a platform team can own those details and analysts need more range than a simpler question builder provides. Smaller teams should start with Metabase; operations teams centered on metrics, logs, and traces should start with Grafana.

Alternatives

ProjectWhat it isPick it when
Metabase gh↗A business intelligence tool with a visual question builder, SQL editor, and dashboards.pick this instead when non-SQL users need the shortest path to asking questions and you can trade away some of Superset's extension depth.
LightdashA BI platform built around governed metrics in dbt projects or Lightdash YAML.pick this instead when analytics definitions should live in files and move through CLI, CI, and pull-request review.
Grafana gh↗A dashboard platform centered on metrics, logs, traces, and operational data.pick this instead when observability and time-series monitoring are the primary jobs.

What people are saying

  1. [github-trending] superset-sh/superset

Sources

  1. Apache Superset README
  2. Apache Superset 6.1.0 release
  3. Apache Superset architecture guide
  4. Apache Superset Docker Compose guide
  5. Apache Superset MCP server guide
  6. Large integer regression issue 44079
  7. MCP chart update issue 44176

More data reviews

dbt · GeoLibre · TradingView-API · os-taxonomy · Lean · bokeh · the whole board →