Skip to content

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 dev
sqt dev --project-dir examples/orders_demo
sqt dev --ui-host 127.0.0.1 --ui-port 8000

Open http://127.0.0.1:8000 by default. sqt dev accepts the normal project, target, variables, and ClickHouse connection overrides in addition to:

OptionPurpose
--ui-host VALUEBind interface; defaults to 127.0.0.1
--ui-port VALUEBind port; defaults to 8000
--auth-mode VALUEdisabled, trusted_proxy, or password
--control-store-url VALUESQLite or PostgreSQL account store

The UI combines authored definitions with live warehouse state. Detailed guides cover each workflow:

Disabled authentication is limited to loopback. See Authentication before exposing the server, then define operational permissions with Access Control.