# SQLBuild

## Docs

- [audit](https://docs.sqlbuild.com/cli/audit.md): Run data quality audits in isolation.
- [build](https://docs.sqlbuild.com/cli/build.md): Execute the full build lifecycle: seeds, tests, models, and audits.
- [clean](https://docs.sqlbuild.com/cli/clean.md): Remove compiled artifacts from the target directory.
- [clone](https://docs.sqlbuild.com/cli/clone.md): Copy models between environments using zero-copy cloning.
- [compile](https://docs.sqlbuild.com/cli/compile.md): Compile models into resolved SQL and write target artifacts.
- [diff](https://docs.sqlbuild.com/cli/diff.md): Compare schemas and data between environments.
- [init](https://docs.sqlbuild.com/cli/init.md): Scaffold a new SQLBuild project.
- [janitor](https://docs.sqlbuild.com/cli/janitor.md): Clean up stale warehouse relations.
- [plan](https://docs.sqlbuild.com/cli/plan.md): Preview what SQLBuild will do before executing.
- [query](https://docs.sqlbuild.com/cli/query.md): Run ad hoc SQL queries against the project database.
- [run](https://docs.sqlbuild.com/cli/run.md): Execute models without tests or audits.
- [seed](https://docs.sqlbuild.com/cli/seed.md): Load seed CSV files into the warehouse.
- [test](https://docs.sqlbuild.com/cli/test.md): Run SQL unit tests in isolation.
- [Audits](https://docs.sqlbuild.com/concepts/audits.md): Data quality checks that run before data reaches the target table.
- [Environment Diffs](https://docs.sqlbuild.com/concepts/environment-diffs.md): Compare schemas and data between environments to validate changes before promotion.
- [Incremental Models](https://docs.sqlbuild.com/concepts/incremental.md): Cursor-based incremental strategies, microbatch execution, and backfill policies.
- [Python Macros](https://docs.sqlbuild.com/concepts/macros.md): Reusable Python functions that generate SQL fragments at compile time.
- [Models](https://docs.sqlbuild.com/concepts/models.md): SQL model definitions, the MODEL() block, materialization types, and how the DAG is built.
- [Project Configuration](https://docs.sqlbuild.com/concepts/project-configuration.md): Configure your SQLBuild project with sqlbuild_project.yml and sqlbuild_local.yml.
- [Seeds](https://docs.sqlbuild.com/concepts/seeds.md): Load static CSV data into your pipeline as tables.
- [Selectors](https://docs.sqlbuild.com/concepts/selectors.md): Target specific models, paths, tags, or DAG subsets with --select and --exclude.
- [Sources](https://docs.sqlbuild.com/concepts/sources.md): Declare external data inputs for your pipeline.
- [Testing](https://docs.sqlbuild.com/concepts/testing.md): SQL unit tests with model chaining, macro support, and multi-model integration testing.
- [Waffle Shop](https://docs.sqlbuild.com/examples/waffle-shop.md): A complete walkthrough of the waffle shop example project.
- [Introduction](https://docs.sqlbuild.com/index.md): Typed, test-first SQL pipelines with change-aware incremental rebuilds.
- [Quickstart](https://docs.sqlbuild.com/quickstart.md): Get a SQLBuild project running locally with DuckDB in under a minute.

## OpenAPI Specs

- [openapi](https://docs.sqlbuild.com/api-reference/openapi.json)