About Quary
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.
Work is meant to go through version control so teams can test, collaborate and refactor iteratively. The project is Apache-2.0 licensed, and its authors also make SQRUFF, a SQL linter.
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
Good fit for
- Modelling warehouse tables in SQL
- Testing data models
- Charting query results
- Prototyping on a local DuckDB project
Quary: questions and answers
- What is Quary used for?
- Quary is an open source business intelligence tool for engineers, with a Rust CLI and VSCode extension for modelling data in SQL. It is a good fit for modelling warehouse tables in SQL, testing data models and charting query results.
- Is Quary open source?
- Yes. Quary is open source under the Apache-2.0 licence. Its source code is on GitHub at quarylabs/quary and is written mainly in Rust.
- Is Quary free?
- Yes. Quary is open source, so the software itself is free to use.
- What is Quary an alternative to?
- Quary is an open-source alternative to Looker, Holistics and Coalesce. Other open-source alternatives to Looker include dbt, Superset and Metabase.
- Is Quary actively maintained?
- Yes. The most recent commit to Quary was on 9 November 2026, and the latest release is v0.10.1, published on 23 January 2026. The project has 2.4k stars on GitHub, with 5 added in the last 30 days.
Open-source alternatives to Quary
See all
dbt
Data Pipelines & ETL
dbt enables data analysts and engineers to transform their data using the same practices t
Apache-2.0vs Matillion★ 14k
Superset
BI & Dashboards
Apache Superset is a Data Visualization and Data Exploration Platform
Apache-2.0vs Tableau★ 75k
Metabase
BI & Dashboards
The easy-to-use open source Business Intelligence and Embedded Analytics tool that lets ev
OSSvs Tableau★ 50k
Redash
BI & Dashboards
Make Your Company Data Driven. Connect to any data source, easily visualize, dashboard and
BSD-2-Clausevs Data Studio★ 29k
Evidence
BI & Dashboards
Evidence is an open source, code-based alternative to drag-and-drop BI tools. Build polish
MITvs Tableau★ 7.1k
Cube
BI & Dashboards
📊 Cube Core is open-source semantic layer for AI, BI and embedded analytics
OSSvs Looker★ 21k
SaaS alternatives to Quary
See all
Looker
BI & Dashboards
Google Cloud business intelligence platform with a governed semantic modeling layer
SaaS
Holistics
BI & Dashboards
Self-service BI platform with a semantic modeling layer and dashboards
SaaS
Coalesce
Data Pipelines & ETL
Column-aware data transformation platform for building warehouse pipelines
SaaS
Amazon QuickSight
BI & Dashboards
Serverless BI service on AWS with dashboards, ML insights and embedding
SaaS
Omni
BI & Dashboards
BI platform that combines a governed semantic model with spreadsheet-style exploration
SaaS
GoodData
BI & Dashboards
Analytics platform for embedded dashboards and headless BI
SaaS
