Launch the SQLRooms AI example locally with a DuckDB websocket backend and persisted UI state inside the same DuckDB file.

# From the repo root
uvx sqlrooms \
  ./sqlrooms.db \
  --ws-port 4000 \
  --port 4173

What happens:

• Starts the DuckDB websocket backend (from sqlrooms-server) on ws://localhost:4000.
• Serves the AI example UI on http://localhost:4173 and opens your browser (disable with --no-open-browser).
• Drag-and-drop CSV/Parquet/DuckDB files to load them into DuckDB; files are uploaded to a local sqlrooms_uploads folder and referenced by path.
• UI state is stored in the SQLRooms meta namespace (default __sqlrooms) of the selected DuckDB file.

• --db-path (default :memory:): DuckDB file to load/create. The __sqlrooms schema is created automatically.
• DB_PATH (positional): Optional positional alternative to --db-path (e.g. sqlrooms ./my.db).
• --host / --port: HTTP host/port for the UI (default 127.0.0.1:4173).
• --ws-port: WebSocket port for DuckDB queries. If omitted, a free port is chosen automatically.
• --sync: Enable optional sync (CRDT) over WebSocket (Loro).
• --meta-db: Optional path to a dedicated DuckDB file for SQLRooms meta tables (UI state + CRDT snapshots). If omitted, meta tables are stored in the main DB.
• --meta-namespace (default __sqlrooms): Namespace for SQLRooms meta tables. If --meta-db is provided, used as ATTACH alias; otherwise used as a schema in the main DB.
• --no-open-browser: Skip automatically opening the browser tab.
• --ui: Optional path to a custom UI bundle directory (a Vite dist/). If omitted, uses the bundled default UI.
• --config: Path to a SQLRooms TOML config file. Defaults to ~/.config/sqlrooms/config.toml (%APPDATA%\sqlrooms\config.toml on Windows).
• --no-config: Disable config file loading.

Tables created in the selected DuckDB file (or attached meta DB if --meta-db is provided):

• __sqlrooms.ui_state (one row: key='default')
• __sqlrooms.sync_rooms (only used when --sync is enabled)

Uploads go to /api/upload. Runtime config for the UI is exposed at /api/config / /config.json.

sqlrooms reads AI provider and connector settings from a TOML config file:

• macOS / Linux: ~/.config/sqlrooms/config.toml
• Windows: %APPDATA%\sqlrooms\config.toml

Override with --config <path>, or disable with --no-config.

Example config file:

[ai]
default_provider = "openai"
default_model = "gpt-5"

[[ai.providers]]
id = "openai"
base_url = "https://api.openai.com/v1"
api_key_env = "OPENAI_API_KEY"
models = ["gpt-5", "gpt-4.1"]

[[ai.providers]]
id = "anthropic"
base_url = "https://api.anthropic.com"
api_key_env = "ANTHROPIC_API_KEY"
models = ["claude-4-sonnet"]

[[db.connectors]]
id = "postgres-local"
engine = "postgres"
title = "Postgres Local"
host = "localhost"
port = "5432"
database = "postgres"
user = "postgres"
password = "postgres"

[[db.connectors]]
id = "snowflake-prod"
engine = "snowflake"
title = "Snowflake Prod"
account = "your-account"
user = "your-user"
password = "your-password"
warehouse = "your-warehouse"
database = "your-database"
schema = "your-schema"
role = "your-role"
authenticator = "externalbrowser"

[[db.connectors]]
id = "snowflake-dev"
engine = "snowflake"
title = "Snowflake Dev"
account = "your-dev-account"
user = "your-dev-user"
warehouse = "your-dev-warehouse"

If you only want the DuckDB websocket server (no HTTP UI server), install/run sqlrooms-server:

uvx sqlrooms-server --db-path ./sqlrooms.db --port 4000

sqlrooms-server is also available as an alias console script.

Use these modes to run remote queries through backend connectors and materialize results into core DuckDB for downstream notebook cells.

Install optional connector dependencies first:

# From python/sqlrooms-cli
uv sync --extra connectors
# or install just one connector:
uv sync --extra postgres
uv sync --extra snowflake

uvx sqlrooms \
  ./sqlrooms.db \
  --ws-port 4000 \
  --port 4173

uvx sqlrooms \
  ./sqlrooms.db \
  --ws-port 4000 \
  --port 4173

What this enables:

• sqlrooms-cli exposes connector bridge endpoints under /api/db/*.
• Runtime connector metadata is exposed via /api/config, so frontend DbSlice auto-registers available backend connections.
• Notebook SQL cells can select Postgres/Snowflake connectors from the connector dropdown.
• Arrow payloads are materialized into DuckDB and can be queried downstream in the same session.

Notes:

• Configure connectors in sqlrooms.toml using [[db.connectors]] entries.
• Connector libraries are optional extras (postgres, snowflake, or connectors).

Local dev loop for the CLI and UI:

1. Install deps and build the dedicated UI (from repo root):

pnpm install
pnpm --filter sqlrooms-cli-app build
# build outputs directly to python/sqlrooms-cli/sqlrooms/web/static

2. Dev the Python CLI (from repo root or package dir):

cd python/sqlrooms-cli
pnpm dev  # starts uv server and Vite dev UI together

3. Hot reload UI on its own (optional):

cd python/sqlrooms-cli
pnpm dev:ui -- --host --port 4174

Tips:

• Use --no-open-browser if you don’t want the static bundle auto-opened.
• Rebuild the UI (pnpm --filter sqlrooms-cli-app build) when you want the Python server to serve new static assets.
• /api/config reflects runtime config (AI providers/default model, DB bridge metadata, WS URL).