Quary

Open source

Quary is an open source business intelligence tool for engineers, with a Rust CLI and VSCode extension for modelling data in SQL.

Open-source alternative to

GitHub stars
2.4k
Last 30 days
+5(+0%)
Last commit
4 days ago
Repository age
2 years
Version
v0.10.1
Licence
Apache-2.0
Self-hosted
Yes

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
Built with
Rust tools
Tags
business-intelligence
sql
data-modeling
duckdb
rust
cli
analytics
vscode

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

SaaS alternatives to Quary

See all