A Tauri desktop app for exploring and querying data with SQL, built on ClickHouse, with optional LLM integration and a web mode.
apache/superset
Apache Superset is an open-source, web-based business intelligence platform for exploring data, building charts and dashboards, and querying SQL databases.
Open-source alternative to:Tableau
Microsoft Power BI
Looker
- Stars
- 75,205
- Forks
- 18,488
- Open issues
- 599
- Last commit
- 6 hours ago
What is it?
Apache Superset is a data exploration and visualization platform aimed at analysts and business users who want to answer questions from their data without writing code for every chart. It offers a no-code chart builder, dashboards, and a web-based SQL Editor for more advanced querying. A lightweight semantic layer lets teams define custom dimensions and metrics once and reuse them across charts.
Superset connects to nearly any SQL-speaking database or data engine that has a Python DB-API driver and a SQLAlchemy dialect. The README lists supported systems including Trino, Presto, Athena, ClickHouse, Snowflake, BigQuery, and many others. Its visualizations range from simple bar charts to geospatial views, and a configurable caching layer reduces load on the underlying databases.
The project also includes role-based security and authentication options, a REST API for programmatic customization, and an extension framework for building on the platform. It is written in Python with a React frontend and is deployable through Docker and Helm.
Key features
- 01No-code chart builder for creating visualizations quickly
- 02Web-based SQL Editor for advanced querying
- 03Lightweight semantic layer for defining custom dimensions and metrics
- 04Connects to many SQL databases and data engines via SQLAlchemy
- 05Configurable caching layer to reduce database load
- 06Role-based security and authentication options with a REST API
Use cases
- Building shared dashboards for business teams on top of a data warehouse
- Giving analysts a web SQL editor to explore data in Trino or Presto
- Self-hosting a BI tool as an alternative to proprietary dashboard products
- Embedding a data exploration layer in internal analytics platforms via its API
Things to know
- Self-hosting requires installing, configuring and operating the platform, including database drivers, security and scaling, as described in the Administrator Guide.
Topics
FAQ
- What is superset?
- Apache Superset is an open-source, web-based business intelligence platform for exploring data, building charts and dashboards, and querying SQL databases. Apache Superset is a data exploration and visualization platform aimed at analysts and business users who want to answer questions from their data without writing code for every chart. It offers a no-code chart builder, dashboards, and a web-based SQL Editor for more advanced querying. A lightweight semantic layer lets teams define custom dimensions and metrics once and reuse them across charts.
- Is superset free to use? What license does it have?
- superset is open source under the Apache-2.0 license. Check the license terms before using it in commercial products.
- Is superset still maintained?
- Actively maintained. The last commit to superset was on Oct 19, 2026.
- What can I use superset for?
- Building shared dashboards for business teams on top of a data warehouse Giving analysts a web SQL editor to explore data in Trino or Presto Self-hosting a BI tool as an alternative to proprietary dashboard products Embedding a data exploration layer in internal analytics platforms via its API
- Where can I get superset?
- The source code and installation instructions are on GitHub: https://github.com/apache/superset
Summary generated by AI from the project's README. GitHub stats refresh daily.
Related projects
Open-source, privacy-first analytics for mobile, desktop and web apps, offered as an alternative to Firebase and Google Analytics.
Open-source product platform combining product analytics, session replay, feature flags, experiments, error tracking, logs, and data pipelines, with AI agent access.
A declarative engine that generates and renders SVG infographics from a concise text syntax, designed for AI-driven generation.
Generates interactive, easy-to-read ER diagrams from your database schema, with zero configuration for public or private repos.
A Python library for building styled display tables from pandas or Polars DataFrames, rendered to HTML or image files.