# StreamBuild

> Declarative streaming data pipelines for ClickHouse.

## Docs

- [stb audit](https://docs.streambuild.dev/cli/audit.md): Run data-quality audits against live or staged relations.
- [stb backfill](https://docs.streambuild.dev/cli/backfill.md): Create and populate a virtual-environment deployment.
- [stb build](https://docs.streambuild.dev/cli/build.md): Rebuild models directly and replay retained history.
- [stb compile](https://docs.streambuild.dev/cli/compile.md): Compile the project into canonical SQL, DDL, graph, and workflow artifacts.
- [stb discover](https://docs.streambuild.dev/cli/discover.md): List the pipelines discovered in a project.
- [stb doctor](https://docs.streambuild.dev/cli/doctor.md): Diagnose active virtual-environment view bindings.
- [stb janitor](https://docs.streambuild.dev/cli/janitor.md): Preview and remove stale deployment objects after a retention window.
- [stb plan](https://docs.streambuild.dev/cli/plan.md): Preview direct rebuilds or virtual-environment deployments without writing.
- [stb publish](https://docs.streambuild.dev/cli/publish.md): Replace stable view bindings with one staged deployment.
- [stb reconcile](https://docs.streambuild.dev/cli/reconcile.md): Adopt structurally compatible live objects into the metadata baseline.
- [stb repair active-view](https://docs.streambuild.dev/cli/repair.md): Re-point one stable view to an explicit deployment table.
- [stb test](https://docs.streambuild.dev/cli/test.md): Execute SQL-native model and macro tests against ClickHouse.
- [ClickHouse Architecture](https://docs.streambuild.dev/concepts/architecture.md): Managed source objects, model relations, deployment names, and metadata.
- [Audits](https://docs.streambuild.dev/concepts/audits.md): Live and staged data-quality checks using singular and generic SQL audits.
- [Virtual Environments](https://docs.streambuild.dev/concepts/deployments.md): Opt-in staged backfills, assessment, publishing, and lifecycle operations.
- [Direct Mode](https://docs.streambuild.dev/concepts/direct-mode.md): The default rebuild workflow without staged views or a publish step.
- [Python Macros](https://docs.streambuild.dev/concepts/macros.md): Invocation-scoped Python functions that generate SQL at compile time.
- [Models](https://docs.streambuild.dev/concepts/models.md): Typed SQL models, references, storage settings, and graph semantics.
- [Sources and Pipelines](https://docs.streambuild.dev/concepts/pipelines.md): Reusable streaming sources and the pipelines that consume them.
- [Project Configuration](https://docs.streambuild.dev/concepts/project-configuration.md): TOML targets, local overrides, variables, connections, and mode selection.
- [Replay and Lineage](https://docs.streambuild.dev/concepts/replay-lineage.md): Replay boundaries, inclusive cutoffs, anchors, and virtual-environment policies.
- [SQL Testing](https://docs.streambuild.dev/concepts/testing.md): Model-chain tests, zero-row assertions, macro tests, and bag comparison.
- [Orders Demo](https://docs.streambuild.dev/examples/orders-demo.md): Run a ten-model Kafka-to-ClickHouse project with tests, audits, replay, and publish.
- [Introduction](https://docs.streambuild.dev/index.md): Declarative streaming data pipelines for ClickHouse.
- [Direct-mode Quickstart](https://docs.streambuild.dev/quickstart.md): Build a direct-mode pipeline from an adopted ClickHouse stream table.