ForkFree

Data and analytics

dbt

by dbt-labs

dbt is a command-line tool that turns SQL select statements into tables and views inside a data warehouse. This version is a Rust rewrite (v2.0) that parses and runs data projects faster and ships as a single binary.

Proof level: ReadWorth a lookApache-2.0

Get it on GitHubProject websiteCompare

No demo yet

Proof level: Read. We read its README and licence and ran our automatic checks. We have not run it yet. So this page is based on its README and our automatic checks.

The catch

Worth a lookEstablished, with a few things to check (listed below).

Check this first: The official dbt distribution is released under a separate dbt product licence, not Apache 2.0.

Things to check

  • The official dbt distribution is released under a separate dbt product licence, not Apache 2.0
  • v2.0 is a ground-up rewrite, so behaviour may differ from v1 and some platforms are unsupported (Windows ARM)
  • Needs an existing data warehouse, which may carry its own costs
  • The v1 Python version now lives on a different branch

Can you use dbt commercially?

Free to use, change and sell, including in paid products. Keep the copyright notice.

Not legal advice. Read the project's licence file before building a product on it.

What can you do with dbt?

  • Write SQL select statements as models that build tables and views in your data warehouse
  • Manage dependencies between models and test the quality of your transformed data
  • Generate local documentation and queryable Parquet artifacts describing your project

How do you get dbt running?

Install it as a single self-contained binary by following the official install guide, then connect it to your data warehouse.

Follow the official instructions in the project README.

Make money with it

A freelancer could offer paid data-modelling and reporting setup for small businesses that already use a cloud data warehouse.

An idea, not financial advice. Check the licence before charging for anything built on it.

Ways a business could use it

  • Build reliable, tested reporting tables from raw sales and marketing data without paying for a managed transformation service
  • Offer clients a documented, version-controlled data pipeline in place of ad hoc spreadsheets

Checked 06 Nov 2026. Summary drafted by AI from the project's README. Proof level 1 of 4, Read: we read its readme and licence and ran our automatic checks. we have not run it yet.

Similar tools in Data and analytics

Scrapling D4Vinci
Worth a look

Scrapling is a Python library for collecting data from websites, covering single page requests, JavaScript-heavy sites and large crawls. It is used to pull out text, prices, listings and other information and save it as JSON, CSV or Markdown.

Proof level: Read 104.5k stars +586 a day BSD-3-Clause
Worth a look

A Python system that uses large language models to analyse a personal watchlist of shares across several markets, including China, Hong Kong, the US, Japan, Korea and Taiwan. It gathers market data and news, then sends a daily "decision dashboard" report to chat apps or email.

Proof level: Read 73.5k stars +257 a day MIT
metabase metabase
Check the licence

Metabase is a business intelligence tool that connects to your databases so people can ask questions, build dashboards and share reports without needing to write SQL. It can be self-hosted or used as a paid cloud service, and it can also be embedded in other apps.

Instead of Tableau, Microsoft Power BIUp to $900 a year

Proof level: Read 50.4k stars +23 a day Unclear