CLI reference
sqt dev
Serve the local SQLTide UI for one project and target.
Compile a project, connect to its selected ClickHouse target, and serve the packaged web UI and JSON API until interrupted:
sqt devsqt dev --project-dir examples/orders_demosqt dev --ui-host 127.0.0.1 --ui-port 8000Open http://127.0.0.1:8000 by default. sqt dev accepts the normal project, target, variables, and
ClickHouse connection overrides in addition to:
| Option | Purpose |
|---|---|
--ui-host VALUE | Bind interface; defaults to 127.0.0.1 |
--ui-port VALUE | Bind port; defaults to 8000 |
--auth-mode VALUE | disabled, trusted_proxy, or password |
--control-store-url VALUE | SQLite or PostgreSQL account store |
The UI combines authored definitions with live warehouse state. Detailed guides cover each workflow:
Start with the page map, snapshots, and operating model.
Warehouse HealthInspect ClickHouse capacity, memory context, and current activity.
SourcesInspect landing health, retention, freshness, and Kafka lag.
MessagesSearch records retained in ClickHouse without consuming Kafka.
PlansPreview warehouse changes and launch builds.
RunsInspect durable execution, cancellation, and recovery.
QualityRun tests and audits and monitor the audit scheduler.
Disabled authentication is limited to loopback. See Authentication before exposing the server, then define operational permissions with Access Control.