#1
A web-based business intelligence platform from the Apache project with a no-code chart builder, SQL editor and dashboards that connects to most SQL databases.
- GitHub stars
- 75k
- Last commit
- today
- Latest release
- 6.1.0
- Licence
- Apache-2.0
- Self-hosted
- Yes
superset.apache.org
Apache Superset is a data exploration and visualization platform that runs as a web application. Analysts and business users can connect it to a database, build charts without code, assemble them into dashboards and share them, so it can augment or replace proprietary business intelligence tools for many teams.
The no-code chart builder sits next to a web-based SQL editor for advanced queries, and a lightweight semantic layer lets teams define reusable dimensions and metrics. Visualizations range from simple bar charts to geospatial views. Superset can query any SQL datastore or engine provided a matching Python database driver and SQLAlchemy dialect exist, including Presto, Trino and Athena. A configurable caching layer reduces database load, and security roles and authentication options are extensible.
The stack is Python with Flask on the back end and React on the front end, under the Apache-2.0 license. A REST API and extension framework allow programmatic control and customization. Documentation is split into guides for users, administrators and developers, and it is a typical choice for organizations that want a self-managed BI layer.
Key features
- No-code chart builder
- Web-based SQL editor
- Shareable interactive dashboards
- Lightweight semantic layer for metrics
- Connects to any SQL database with a driver
- Caching layer and security roles
- REST API for programmatic customization
Pricing: Free and open source under the Apache-2.0 license.
#2
An open-source BI and embedded analytics tool for exploring data, building dashboards and asking questions without SQL, self-hosted or through Metabase Cloud.
- GitHub stars
- 50k
- Last commit
- today
- Latest release
- v0.65.3
- Self-hosted
- Yes
- Hosted version
- Available
metabase.com
Metabase is an open-source business intelligence and embedded analytics tool meant for everyone in a company, not only analysts. People can ask questions about their data without knowing SQL, while an SQL editor is available for more complex queries. Written in Clojure, it connects to databases such as PostgreSQL and MySQL.
Its features include interactive dashboards with filters, auto-refresh and custom click behavior, plus documents for long-form analysis that colleagues can comment on. An AI assistant called Metabot helps answer questions and write queries, and you can build your own AI agent against your data. Data Studio supports transforming raw data into analytics-ready tables and defining canonical metrics. Alerts and scheduled dashboard subscriptions go to email, Slack or a webhook, and a Library plus Git integration help version your work.
Metabase can also be embedded in your own product with components for charts, dashboards, a data browser and AI chat, and granular permissions work for internal teams and embedded customers. You can self-host it or use Metabase Cloud, which the project says includes support, backups, upgrades and a free trial. The repository license is listed as 'Other', so review its terms.
Key features
- Question builder that needs no SQL
- SQL editor for complex queries
- Interactive dashboards with filters and auto-refresh
- Alerts and scheduled subscriptions to email or Slack
- Embedding of charts and dashboards in apps
- Granular permissions for teams and customers
- Metabot AI assistance for queries
Pricing: The open-source edition is free. Cloud Starter is $100 per month and Pro $575 per month with a 14-day trial; extra users cost $6 or $12 per month. Enterprise starts at $20,000 per year.
#3
An open-source, headless semantic layer where you define metrics and access rules once in code and expose them to BI tools, apps and AI agents through SQL, REST and GraphQL.
- GitHub stars
- 21k
- Last commit
- today
- Latest release
- v1.8.22
- Self-hosted
- Yes
- Hosted version
- Available
cube.dev
Cube Core is an open-source semantic layer. You describe your metrics, dimensions, joins and permissions a single time, as code, and Cube exposes that model through SQL, REST and GraphQL APIs to whatever sits downstream: BI tools, custom applications or AI agents. It is headless, meaning it ships no user interface of its own, which leaves you free to design the analytics experience your product needs.
The project argues that every BI tool already relies on a semantic layer to hide data complexity, but most are proprietary and tied to a single platform. Cube aims to make that layer reusable. It connects to any SQL data source, including warehouses such as BigQuery, Snowflake and Databricks, engines such as Amazon Athena and Presto, and application databases such as Postgres. A built-in relational caching engine delivers fast responses and high concurrency for API requests.
The core is written in Rust and JavaScript, and its license is listed as 'Other' on GitHub, so review the terms for commercial use. Cube can be self-hosted, and the company also offers Cube Cloud. It suits data teams building embedded analytics or wanting consistent metric definitions across tools.
Key features
- Metrics and dimensions defined as code
- SQL, REST and GraphQL APIs
- Headless design with no built-in UI
- Connects to Snowflake, BigQuery and Databricks
- Built-in caching engine
- Access rules for governed data
Pricing: Free forever plan for hobby projects. Starter costs $40 and Premium $80 per developer per month; Enterprise is custom via a demo request.
#4
A browser-based tool for querying databases, visualizing results and sharing dashboards, with scheduled refreshes and alerts across many data sources.
- GitHub stars
- 29k
- Last commit
- 3 days ago
- Latest release
- v26.9.0
- Licence
- BSD-2-Clause
- Self-hosted
- Yes
redash.io
Redash is an open-source business intelligence and data exploration tool that works entirely in the browser. SQL users connect it to a data source, write queries, turn results into visualizations and share them, so that colleagues without SQL skills can use the results too.
The query editor accepts both SQL and NoSQL queries and offers a schema browser plus auto-complete. Visualizations are built by drag and drop and can be combined into dashboards, and every chart or query has a shareable URL that supports collaboration and peer review. Charts and dashboards can refresh on a schedule, and alerts can notify you when results cross a threshold. Topics mention many sources, including Redshift, BigQuery, Athena, MySQL, PostgreSQL and Databricks.
Redash is written in Python and JavaScript and licensed under BSD-2-Clause. You deploy it on your own infrastructure, commonly with Docker, and it is aimed at analysts and engineers who want a lightweight, query-first dashboard tool rather than a heavy BI suite.
Key features
- Query editor for SQL and NoSQL sources
- Schema browser with auto-complete
- Drag-and-drop chart building
- Shareable dashboards and queries
- Scheduled dashboard refreshes
- Alerts on query results
Pricing: Free and open source under the BSD-2-Clause license.
#5
A data transformation framework that lets analysts and engineers build analytics models with software-engineering practices; v2.0 is a ground-up rewrite in Rust.
- GitHub stars
- 14k
- Last commit
- today
- Latest release
- v1.12.7
- Licence
- Apache-2.0
- Self-hosted
- Yes
- Hosted version
- Available
getdbt.com
dbt is a framework for transforming data in a warehouse using the same practices that software engineers apply to applications. Analysts and analytics engineers write models, and dbt parses, compiles and runs the project so that transformations are version-controlled and repeatable.
The repository now holds the Apache 2.0 source of dbt v2.0, a ground-up rewrite in Rust. According to its README, v2.0 parses and compiles projects much faster than v1, enforces a stricter language specification at parse time, produces Parquet artifacts alongside the existing JSON ones, and ships as one standalone executable, so no Python installation is needed. The local documentation experience was rebuilt around those artifacts to handle large projects.
The Apache 2.0 code is available to everyone, while the packaged dbt distribution adds dbt-specific customizations under a separate dbt product license. v2.0 supports macOS and Linux on x86-64 and ARM. The v1 Python implementation continues on the 1.latest branch. dbt Labs also offers dbt as a commercial cloud platform.
Key features
- Data transformation using software engineering practices
- Faster parsing and compiling in v2.0
- Strict language specification checks at parse time
- Parquet artifacts for querying project metadata
- Single binary without a Python runtime
- Rebuilt local documentation experience
Pricing: A single-seat Developer plan to start free. Starter costs $100 per user per month; Enterprise and Enterprise+ are custom. A trial is available and add-ons are billed on usage.
#6
A code-based business intelligence tool where reports are written in SQL and Markdown, an alternative to drag-and-drop BI that can be self-hosted or published on Evidence Studio.
- GitHub stars
- 7.1k
- Last commit
- today
- Latest release
- @evidence-dev/evidence@40.1.8
- Licence
- MIT
- Self-hosted
- Yes
- Hosted version
- Available
evidence.dev
Evidence is a code-first business intelligence tool, released as open source, offered in place of drag-and-drop BI products. Reports and dashboards are written as Markdown with SQL queries, which keeps them in version control and lets analysts build interactive data visualizations without a point-and-click builder.
The README calls it agent-ready: you can develop with Evidence's own agent, or locally with coding assistants such as Claude Code or Cursor. Topics mention dbt, DuckDB, Svelte, Tailwind CSS, WebAssembly and self-hosting. A project is created from an installer for macOS, Linux or Windows, and the result can be published on Evidence Studio for hosted reports, or built as a static site and self-hosted on your own infrastructure.
Evidence is written in TypeScript with Svelte and licensed under MIT, and has a Slack community for help. It suits data teams and analysts who are comfortable with SQL and want reports reviewed and deployed like software, rather than assembling dashboards in a GUI.
Key features
- Reports written in SQL and Markdown
- Interactive charts and visualizations
- Works with coding agents like Claude Code
- Static site output for self-hosting
- Publishing via Evidence Studio
- Version-controlled analytics code
Pricing: Evidence Cloud has one flat price for unlimited users: Team is $2,500 per month with a 30-day trial. Enterprise is custom on an annual contract.
#7
Lightdash is an open-source BI platform that defines metrics as code, with dashboards, AI agents and data apps built on a shared context layer.
- GitHub stars
- 6.2k
- Last commit
- yesterday
- Latest release
- 3.219.0
- Self-hosted
- Yes
- Hosted version
- Available
lightdash.com
Lightdash is an open-source business intelligence platform that it describes as agentic BI, meant for data teams that want analytics to be shipped like software. Metrics, joins, permissions, business logic and caching are defined once in a context layer, and that layer feeds MCP, SDKs, embedded analytics, data apps, AI agents and dashboards.
Analytics can be built as code: metrics, charts and dashboards live as files that you can edit with coding agents, preview from the Lightdash CLI, validate in CI and review in pull requests. Business users can pose questions in plain English, browse dashboards or build custom data apps, all while governance stays in place. Agents answer from the context layer rather than guessing from raw tables, respect permissions and return queries that can be inspected. The repository topics mention dbt.
Lightdash is written in TypeScript. The vendor recommends starting with Lightdash Cloud, which needs no infrastructure to run, and also offers a live demo, documentation and a sales call. The repository lists its licence as other, so check the terms before self-hosting.
Key features
- Context layer for metrics and permissions
- BI as code with CLI and CI validation
- AI agents that answer from governed metrics
- Dashboards and custom data apps
- Embedded analytics, SDKs and MCP
- dbt-based workflow
Pricing: Self-hosted Open Source edition with community support. Cloud Pro is $3000 per month with unlimited users and a 21-day trial; Enterprise is quoted.
#8
Quary is an open source business intelligence tool for engineers, with a Rust CLI and VSCode extension for modelling data in SQL.
- GitHub stars
- 2.4k
- Last commit
- 4 days ago
- Latest release
- v0.10.1
- Licence
- Apache-2.0
Quary describes itself as business intelligence for engineers. Projects connect to a database, and the work happens in code: SQL queries transform, organise and document tables, and the finished models are deployed back to the database.
Four kinds of asset are defined as code. Sources describe external data such as database tables, flat files or APIs through DuckDB. Models use SQL to turn raw sources into analysis-ready datasets. Charts are built from SQL. Dashboards and reports are marked as work in progress.
It is delivered as a Rust-based CLI plus a VSCode extension, and the extension depends on the CLI being installed. A new project is created with quary init, which sets up a DuckDB demo with sample data; quary compile checks structure without a database, quary build runs models and seeds, and quary test runs the defined tests.
Key features
- Connect to an existing database
- Write SQL to transform and document tables
- Charts built from SQL
- Version-controlled testing and refactoring
- Deploy models back to the database
- Sources include files and APIs via DuckDB
- Compile step validates models without a database
#9
Dremio OSS is a free, Apache-licensed, open-source data lakehouse platform in Java that provides fast SQL analytics directly on data stored in warehouses and lakes.
- GitHub stars
- 1.5k
- Last commit
- 1 yr ago
- Licence
- Apache-2.0
- Self-hosted
- Yes
dremio.com
Dremio is a data analytics platform aimed at organizations that want to query and analyze large volumes of data without first moving or copying it into a separate, dedicated analytics database. It positions itself as filling a gap between raw data storage and the tools people need to get value out of that data.
The open-source edition can be built and run locally, exposing a web UI at localhost:9047 once started, or installed as a production tarball for server deployment, with an embedded mode also available. Building it requires a specific combination of JDK versions (21 as default, with 17 and 11 configured in the Maven toolchain for certain tests) plus Maven, reflecting a substantial, enterprise-grade Java codebase.
The README notes that to provide the best possible experience, the build includes some dependencies distributed under non-open-source licenses, so the fully open-source experience may differ slightly depending on build configuration. Dremio is written in Java and the open-source edition is released under the Apache-2.0 license, with full documentation hosted separately.
Key features
- SQL analytics directly on lake and warehouse data
- Web-based query interface
- Local and production deployment modes
- Built on a Java codebase with Maven tooling
- No data duplication required for analytics
Pricing: Dremio Cloud is pay-as-you-go at $0.20 per compute unit, with a 30-day trial that includes $400 in credit. Dremio Enterprise, which can be self-hosted, is priced through sales.
Holistics alternatives: questions
- What is the best open-source alternative to Holistics?
- Superset is the top-ranked open-source alternative to Holistics on Enlisted: A web-based business intelligence platform from the Apache project with a no-code chart builder, SQL editor and dashboards that connects to most SQL databases. Other strong options are Metabase, Cube, Redash and dbt.
- What are the best commercial alternatives to Holistics?
- Preset, Omni, Looker, Amazon QuickSight and Bold BI are among the hosted, closed-source alternatives to Holistics listed on Enlisted, which lists 22 in total. Compare their pricing and features on each tool page.
- Are these Holistics alternatives free?
- All 9 are open source, so the code is free to use under its licence, and all of them can be self-hosted on your own server or computer. 5 also offer a paid or managed cloud version if you'd rather not host it yourself.
- How is this list of Holistics alternatives ranked?
- By a score built from GitHub stars, star growth over the last 30 days and how recently the code changed. 8 of these projects shipped code in the last 30 days. Data is refreshed daily, and nobody can pay to move up.