### Start or Resume ktx Project Setup

Source: https://github.com/kaelio/ktx/blob/main/docs-site/content/docs/cli-reference/ktx.mdx

Initiate or continue the guided setup process for a new or existing ktx project.

```bash
# Start or resume setup
ktx setup
```

--------------------------------

### Install and Setup KTX CLI

Source: https://github.com/kaelio/ktx/blob/main/README.md

Install the KTX command-line interface globally and run the setup command to initialize a KTX project.

```bash
npm install -g @kaelio/ktx
ktx setup
ktx status
```

--------------------------------

### KTX Setup Output - Testing Connection

Source: https://github.com/kaelio/ktx/blob/main/docs-site/content/docs/getting-started/quickstart.mdx

Example output during the KTX setup process showing a successful database connection test.

```text
Testing warehouse
  Connection test passed

Building schema context for warehouse
  Running database scan
```

--------------------------------

### Full KTX YAML Configuration Example

Source: https://github.com/kaelio/ktx/blob/main/docs-site/content/docs/configuration/ktx-yaml.mdx

A comprehensive example demonstrating the combination of various configuration blocks for KTX, including connections, setup, storage, LLM, ingest, scan, agent, and memory settings.

```yaml
connections:
  warehouse:
    driver: postgres
    url: env:DATABASE_URL
  metabase:
    driver: metabase
    api_url: https://metabase.example.com
    api_key_ref: env:METABASE_API_KEY
    mappings:
      databaseMappings:
        "1": warehouse
      syncMode: ALL
setup:
  database_connection_ids:
    - warehouse
storage:
  state: sqlite
  search: sqlite-fts5
  git:
    auto_commit: true
    author: "ktx <ktx@example.com>"
llm:
  provider:
    backend: claude-code
  models:
    default: sonnet
ingest:
  adapters:
    - live-database
    - metabase
  embeddings:
    backend: openai
    model: text-embedding-3-small
    dimensions: 1536
    openai:
      api_key: env:OPENAI_API_KEY
  workUnits:
    maxConcurrency: 2
scan:
  enrichment:
    mode: llm
  relationships:
    acceptThreshold: 0.85
    reviewThreshold: 0.55
agent:
  run_research:
    enabled: true
memory:
  auto_commit: true
```

--------------------------------

### Run ktx setup interactively

Source: https://github.com/kaelio/ktx/blob/main/docs-site/content/docs/cli-reference/ktx-setup.mdx

Run the ktx setup command in an interactive terminal to start the guided configuration flow for a new or existing ktx project.

```bash
ktx setup
```

--------------------------------

### Install runtime features without prompting

Source: https://github.com/kaelio/ktx/blob/main/docs-site/content/docs/cli-reference/ktx-setup.mdx

Use the --yes flag during setup to automatically install required runtime features without interactive confirmation. This streamlines the setup process.

```bash
ktx setup --yes
```

--------------------------------

### Manual Agent Setup

Source: https://github.com/kaelio/ktx/blob/main/docs-site/content/docs/guides/serving-agents.mdx

Use manual setup for custom agents that can read project-local instructions. This involves installing the universal target and configuring the agent.

```bash
ktx setup --agents --target universal
```

--------------------------------

### Install and Start Local Embeddings Runtime

Source: https://github.com/kaelio/ktx/blob/main/docs-site/content/docs/getting-started/quickstart.mdx

Install and start the managed Python runtime for local sentence-transformers embeddings before running setup.

```bash
ktx admin runtime install --feature local-embeddings --yes
ktx admin runtime start --feature local-embeddings
```

--------------------------------

### Run Scripted Setup for KTX

Source: https://github.com/kaelio/ktx/blob/main/skills/ktx/SKILL.md

Configure a new database connection, LLM backend, and embedding backend for a KTX project. Use --no-input and --yes for non-interactive setup. Rerun setup for each new database connection.

```bash
ktx setup --no-input --yes \
  --project-dir <path> \
  --llm-backend claude-code \
  --embedding-backend sentence-transformers \
  --database <driver> --database-connection-id <id> \
  --database-url '<raw-url | file:/abs/path>' \
  --database-schema <schema> \
  --skip-sources \
  --skip-agents
```

--------------------------------

### Install KTX Agent Integration

Source: https://github.com/kaelio/ktx/blob/main/skills/ktx/SKILL.md

Install agent integration for KTX and start the Multi-Connection Process (MCP). Agent integration is not usable until `ktx mcp start` is running.

```bash
ktx setup --agents --target <claude-code|claude-desktop|codex|cursor|opencode|universal>
ktx mcp start --project-dir <path>
```

--------------------------------

### Setup LLM Backend and Model Interactively or in Automation

Source: https://github.com/kaelio/ktx/blob/main/docs-site/content/docs/guides/llm-configuration.mdx

During setup, you can choose the LLM backend interactively or pass the model ID directly for automation. This example shows setting the backend to 'claude-code' and the model to 'opus' without user input.

```bash
ktx setup --llm-backend claude-code --llm-model opus --no-input
```

--------------------------------

### Explain KTX Project Setup

Source: https://github.com/kaelio/ktx/blob/main/docs-site/content/docs/ai-resources/prompt-recipes.mdx

Asks the assistant to explain the setup process for KTX in a given repository. It requires reading specific documentation pages and summarizing prerequisites, commands, generated files, and manual credential requirements.

```text
Explain how to set up ktx for this repo. Read /docs/getting-started/quickstart.md and the relevant CLI reference pages. Summarize prerequisites, commands, generated files, and any credentials the user must provide manually.
```

--------------------------------

### Clone and Install KTX Project

Source: https://github.com/kaelio/ktx/blob/main/README.md

Clone the KTX repository, install dependencies using pnpm, sync with uv, and build the project.

```bash
git clone https://github.com/kaelio/ktx.git
cd ktx
pnpm install
uv sync --all-groups
pnpm run build
pnpm run check
```

--------------------------------

### Clone and Install Dependencies

Source: https://github.com/kaelio/ktx/blob/main/docs-site/content/docs/community/contributing.mdx

Clone the ktx repository and install both Node.js and Python dependencies using pnpm and uv.

```bash
git clone https://github.com/kaelio/ktx.git
cd ktx
pnpm install
uv sync --all-groups
```

--------------------------------

### Install and Configure Ktx Skill

Source: https://github.com/kaelio/ktx/blob/main/docs-site/content/docs/getting-started/quickstart.mdx

Use this command to add the Kaelio/ktx skill to your project and then use the ktx skill for installation and configuration.

```bash
Run `npx skills add Kaelio/ktx --skill ktx` and use the ktx skill to install and configure ktx
```

--------------------------------

### Install KTX CLI

Source: https://github.com/kaelio/ktx/blob/main/docs-site/content/docs/getting-started/quickstart.mdx

Install the Kaelio KTX CLI package globally using npm.

```bash
npm install -g @kaelio/ktx
```

--------------------------------

### Klio Setup Status Check

Source: https://github.com/kaelio/ktx/blob/main/docs-site/content/docs/cli-reference/ktx-setup.mdx

Displays the current setup and context readiness status for a Klio project. Useful for verifying configurations after running `ktx setup`.

```text
ktx project: /home/user/analytics
Project ready: yes
LLM ready: yes (claude-sonnet-4-6)
Embeddings ready: yes (text-embedding-3-small)
Databases configured: yes (postgres-warehouse)
Context sources configured: yes (dbt-main)
Runtime ready: yes (core)
ktx context built: yes
Agent integration ready: yes (codex:project)
```

--------------------------------

### Install ktx Agents

Source: https://github.com/kaelio/ktx/blob/main/docs-site/content/docs/guides/serving-agents.mdx

Run the agent install step from a ktx project to set up agents. You can install all agents or a specific target like Codex.

```bash
ktx setup --agents
```

```bash
ktx setup --agents --target codex
```

--------------------------------

### Install only agent configuration and rules

Source: https://github.com/kaelio/ktx/blob/main/docs-site/content/docs/cli-reference/ktx-setup.mdx

Use the --agents flag to install only agent configuration and rules without performing a full project setup. This is useful for preparing agent integrations.

```bash
ktx setup --agents
```

--------------------------------

### Start ktx MCP Server

Source: https://github.com/kaelio/ktx/blob/main/docs-site/content/docs/cli-reference/ktx-mcp.mdx

Starts the ktx MCP HTTP server on the default host and port.

```bash
ktx mcp start
```

--------------------------------

### Run Package Artifact Smoke Checks

Source: https://github.com/kaelio/ktx/blob/main/examples/package-artifacts/README.md

Execute the command to start the package artifact smoke checks from the `ktx/` directory. This process installs the generated public `@kaelio/ktx` tarball and tests installed `ktx` commands.

```bash
pnpm run artifacts:check
```

--------------------------------

### Start MCP Server for Agent Clients

Source: https://github.com/kaelio/ktx/blob/main/README.md

If 'ktx status' indicates, run this command to start the MCP server before launching your agent client.

```bash
ktx mcp start --project-dir ...
```

--------------------------------

### Install ktx runtime

Source: https://github.com/kaelio/ktx/blob/main/docs-site/content/docs/cli-reference/ktx-admin.mdx

Installs the bundled Python runtime wheel. Use --yes to accept prompts and --feature to specify runtime features.

```bash
ktx admin runtime install --yes
ktx admin runtime install --feature local-embeddings --yes
```

--------------------------------

### Example: Add Measure to New Source

Source: https://github.com/kaelio/ktx/blob/main/packages/cli/src/skills/sl_capture/SKILL.md

This example demonstrates the workflow for adding a new measure to a source file that does not yet exist. It involves discovering the source, writing the initial source definition with the measure, and validating the changes.

```bash
sl_discover()
  → orders.yaml does not exist yet
sl_discover({ query: "orders" })
  → see grain, columns, no current overlay
sl_write_source({
  connectionId: "warehouse",
  sourceName: "orders",
  source: {
    name: "orders",
    measures: [{
      name: "avg_order_value",
      expr: "avg(amount)",
      description: "Mean order transaction amount - filter by product_category at query time"
    }]
  }
})
sl_validate({ connectionId: "warehouse" })
  → clean
```

--------------------------------

### Install Managed Runtime

Source: https://github.com/kaelio/ktx/blob/main/docs-site/content/docs/cli-reference/ktx-sl.mdx

If query execution is blocked because the managed Python runtime is needed and prompts are disabled, run `ktx admin runtime install --feature core --yes`.

```bash
ktx admin runtime install --feature core --yes
```

--------------------------------

### Start Postgres and Generate Base Workload

Source: https://github.com/kaelio/ktx/blob/main/examples/postgres-historic/README.md

Manually start the Postgres container using Docker Compose and generate the initial query workload for testing.

```bash
docker compose -f examples/postgres-historic/docker-compose.yml up -d --wait
examples/postgres-historic/scripts/generate-workload.sh base
```

--------------------------------

### Install and Build TypeScript Workspace

Source: https://github.com/kaelio/ktx/blob/main/GEMINI.md

Installs dependencies, builds the project, checks types, runs tests, and performs general checks for the TypeScript workspace.

```bash
pnpm install
pnpm run build
pnpm run type-check
pnpm run test
pnpm run check
```

--------------------------------

### Re-pass Database Flags for Ktx Setup Resumption

Source: https://github.com/kaelio/ktx/blob/main/skills/ktx/troubleshooting.md

Fixes 'KTX cannot work without a database' errors when resuming setup by re-passing the original database flags.

```bash
ktx setup --no-input \
  --database <driver> --database-connection-id <id> \
  --llm-backend claude-code
```

--------------------------------

### CLI and Release Checks

Source: https://github.com/kaelio/ktx/blob/main/CLAUDE.md

Performs development setup, links, artifact verification, and release readiness checks for the CLI.

```bash
pnpm run setup:dev
pnpm run link:dev
pnpm run artifacts:verify
pnpm run release:readiness
pnpm run release:published-smoke
```

--------------------------------

### Start the ktx MCP Server

Source: https://github.com/kaelio/ktx/blob/main/docs-site/content/docs/cli-reference/ktx.mdx

Launch the local MCP server, which is used by agent clients.

```bash
# Start the local MCP server for agent clients
ktx mcp start
```

--------------------------------

### Install Ktx with Force Flag

Source: https://github.com/kaelio/ktx/blob/main/skills/ktx/troubleshooting.md

Resolves 'Native CLI binary not found' errors by forcing the installation of optional dependencies, ensuring the native CLI binary is included.

```bash
npm install -g @kaelio/ktx --force
```

--------------------------------

### Start HTTP Compute Server (Code Execution Enabled)

Source: https://github.com/kaelio/ktx/blob/main/python/ktx-daemon/README.md

Starts the HTTP compute server on a specified host and port with code execution explicitly enabled.

```bash
ktx-daemon serve-http --host 127.0.0.1 --port 8765 --enable-code-execution
```

--------------------------------

### Scan Configuration Example

Source: https://github.com/kaelio/ktx/blob/main/docs-site/content/docs/configuration/ktx-yaml.mdx

Configure scan settings including enrichment mode and relationship discovery parameters.

```yaml
scan:
  enrichment:
    mode: llm           # none | deterministic | llm
  relationships:
    enabled: true
    llmProposals: true
    validationRequiredForManifest: true
    acceptThreshold: 0.85
    reviewThreshold: 0.55
    maxLlmTablesPerBatch: 40
    maxCandidatesPerColumn: 25
    profileSampleRows: 10000
    profileConcurrency: 4
    validationConcurrency: 4
    validationBudget: all
```

--------------------------------

### Example debug output for wiki search

Source: https://github.com/kaelio/ktx/blob/main/docs-site/content/docs/cli-reference/ktx-wiki.mdx

This is an example of the debug output generated when the `--debug` flag is used with the `ktx wiki` command. It provides insights into the search process, including the search mode, embedding status, and details about each search lane.

```text
[debug] wiki search mode=sqlite-fts5 embedding=configured results=2
[debug] wiki search lane=lexical status=available returned=1 weight=1.5
[debug] wiki search lane=token status=available returned=1 weight=0.75
[debug] wiki search lane=semantic status=available returned=2 weight=3
```

--------------------------------

### Minimal ktx.yaml Configuration

Source: https://github.com/kaelio/ktx/blob/main/docs-site/content/docs/configuration/ktx-yaml.mdx

A minimal ktx.yaml requires at least one connection entry. This example registers a local Postgres connection.

```yaml
connections:
  warehouse:
    driver: postgres
    url: env:DATABASE_URL
```

--------------------------------

### List all configured connections

Source: https://github.com/kaelio/ktx/blob/main/docs-site/content/docs/cli-reference/ktx-connection.mdx

Use the bare `ktx connection` command to list all configured connections in your project.

```bash
ktx connection
```

--------------------------------

### Build All Configured Connections

Source: https://github.com/kaelio/ktx/blob/main/docs-site/content/docs/guides/building-context.mdx

Ingest context from all configured database and context-source connections. This is useful for a full project context refresh. Ensure `ktx setup` has been run.

```bash
ktx ingest --all
```

--------------------------------

### Initialize a ktx project

Source: https://github.com/kaelio/ktx/blob/main/docs-site/content/docs/cli-reference/ktx-admin.mdx

Initializes a new ktx project directory. Use --force to overwrite existing files.

```bash
ktx admin init
ktx admin init ./my-project
ktx admin init --force
```

--------------------------------

### Setup KTX with Metabase Source

Source: https://github.com/kaelio/ktx/blob/main/skills/ktx/SKILL.md

Set up KTX to connect to Metabase. This requires a Metabase connection ID, URL, API key, warehouse connection ID, and the Metabase database ID.

```bash
ktx setup --no-input --yes --skip-databases --skip-llm --skip-embeddings --skip-agents \
  --source metabase --source-connection-id <id> \
  --source-url <url> --source-api-key-ref file:/abs/path/metabase-api-key \
  --source-warehouse-connection-id <db-connection-id> \
  --metabase-database-id <metabase-db-id>
```

--------------------------------

### Specify agent target and global scope

Source: https://github.com/kaelio/ktx/blob/main/docs-site/content/docs/cli-reference/ktx-setup.mdx

Configure agent setup by specifying the target agent and whether to install the integration into the global scope. This is useful for specific agent integrations like claude-code or codex.

```bash
ktx setup --target claude-code --global
```

--------------------------------

### Setup KTX Project with Query History Enabled

Source: https://github.com/kaelio/ktx/blob/main/examples/postgres-historic/README.md

Configure a new KTX project, enabling query history collection. This command sets up the necessary database connection and parameters.

```bash
export WAREHOUSE_DATABASE_URL=postgresql://ktx_reader:ktx_reader@127.0.0.1:55432/analytics # pragma: allowlist secret
pnpm --filter @kaelio/ktx run build
node packages/cli/dist/bin.js --project-dir /tmp/ktx-postgres-historic setup \
  --new \
  --skip-agents \
  --skip-llm \
  --skip-embeddings \
  --skip-sources \
  --database postgres \
  --new-database-connection-id warehouse \
  --database-url env:WAREHOUSE_DATABASE_URL \
  --database-schema public \
  --enable-query-history \
  --query-history-min-executions 2 \
  --yes \
  --no-input
```

--------------------------------

### Install ktx Agents Globally

Source: https://github.com/kaelio/ktx/blob/main/docs-site/content/docs/guides/serving-agents.mdx

Claude Code and Codex also support global installs. Use this command to install agents globally for these specific targets.

```bash
ktx setup --agents --target claude-code --global
```

```bash
ktx setup --agents --target codex --global
```

--------------------------------

### Automate project creation with defaults

Source: https://github.com/kaelio/ktx/blob/main/docs-site/content/docs/cli-reference/ktx-setup.mdx

Use the --yes and --no-input flags to automate project creation and runtime installation without interactive prompts. This is ideal for scripted or CI environments.

```bash
ktx setup --project-dir <dir> --no-input --yes
```

--------------------------------

### Snowflake Date Arithmetic Example

Source: https://github.com/kaelio/ktx/blob/main/packages/cli/src/skills/sl_capture/SKILL.md

Example of date arithmetic syntax for Snowflake.

```sql
transaction_date >= dateadd(day, -90, current_timestamp())
```

--------------------------------

### Postgres/Redshift Date Arithmetic Example

Source: https://github.com/kaelio/ktx/blob/main/packages/cli/src/skills/sl_capture/SKILL.md

Example of date arithmetic syntax for Postgres and Redshift.

```sql
transaction_date >= current_date - interval '90 days'
```

--------------------------------

### Configure LLM Backend for Ktx Setup

Source: https://github.com/kaelio/ktx/blob/main/skills/ktx/troubleshooting.md

Addresses missing Anthropic API key errors by either specifying a local backend or providing an environment variable for the API key.

```bash
# Inside Claude Code, prefer the local backend:
ktx setup --no-input --llm-backend claude-code ...other flags...

# Otherwise point at an existing env var:
ktx setup --no-input --llm-backend anthropic \
  --anthropic-api-key-env ANTHROPIC_API_KEY ...other flags...
```

--------------------------------

### Display Help for ktx Commands

Source: https://github.com/kaelio/ktx/blob/main/docs-site/content/docs/cli-reference/ktx.mdx

Use the --help flag to display help information for the main ktx command or specific subcommands like setup or ingest.

```bash
ktx --help
ktx setup --help
ktx ingest --help
```

--------------------------------

### Check ktx Readiness

Source: https://github.com/kaelio/ktx/blob/main/docs-site/content/docs/guides/serving-agents.mdx

Run this command before relying on ktx context. It reports project, provider, connection, context-build, and agent-integration readiness in JSON format.

```bash
ktx status --json
```

--------------------------------

### Install and Build TypeScript Workspace

Source: https://github.com/kaelio/ktx/blob/main/AGENTS.md

Installs dependencies, builds the TypeScript project, and performs type checking for the entire workspace.

```bash
pnpm install
pnpm run build
pnpm run type-check
```

--------------------------------

### Setup Configuration for Primary Warehouses

Source: https://github.com/kaelio/ktx/blob/main/docs-site/content/docs/configuration/ktx-yaml.mdx

Configure which connections are treated as primary warehouses by the ingest layer. This is captured by the setup wizard.

```yaml
setup:
  database_connection_ids:
    - warehouse
```

--------------------------------

### BigQuery Date Arithmetic Examples

Source: https://github.com/kaelio/ktx/blob/main/packages/cli/src/skills/sl_capture/SKILL.md

Examples of date arithmetic syntax for BigQuery when dealing with TIMESTAMP and DATE column types.

```sql
transaction_date >= TIMESTAMP_SUB(CURRENT_TIMESTAMP(), INTERVAL 90 DAY)
```

```sql
event_date >= DATE_SUB(CURRENT_DATE(), INTERVAL 90 DAY)
```

--------------------------------

### Setup KTX with Notion Source

Source: https://github.com/kaelio/ktx/blob/main/skills/ktx/SKILL.md

Configure KTX to integrate with Notion. You need a Notion connection ID, an authentication token, and specify the crawl mode and root page ID(s).

```bash
ktx setup --no-input --yes --skip-databases --skip-llm --skip-embeddings --skip-agents \
  --source notion --source-connection-id <id> \
  --source-auth-token-ref file:/abs/path/notion-token \
  --notion-crawl-mode selected_roots --notion-root-page-id <page-id>
```

--------------------------------

### Install KTX CLI Globally

Source: https://github.com/kaelio/ktx/blob/main/skills/ktx/SKILL.md

Install the KTX CLI globally if not in the KTX monorepo. Requires Node.js version 22 or higher.

```bash
node --version    # require >= 22; stop and ask the user if older
ktx --version || npm install -g @kaelio/ktx
```

--------------------------------

### Run Tests and CLI Help

Source: https://github.com/kaelio/ktx/blob/main/python/ktx-sl/AGENTS.md

Commands to run all tests and display help for the semantic layer CLI.

```bash
uv run pytest -q                    # run all tests
uv run python -m semantic_layer.cli --help
```

--------------------------------

### Example Profiling Headline

Source: https://github.com/kaelio/ktx/blob/main/docs-site/content/docs/cli-reference/ktx-ingest.mdx

An example of the summary headline generated when ingest profiling is enabled, providing a quick diagnosis of performance bottlenecks.

```text
Slowest phase: reconciliation (2m 05s, 48% of wall time). 2 work units (1 failed), ~88% model generation vs ~12% tools.
```

--------------------------------

### Skip embedding setup

Source: https://github.com/kaelio/ktx/blob/main/docs-site/content/docs/cli-reference/ktx-setup.mdx

Use the --skip-embeddings flag to leave the embedding setup incomplete. This is useful if embedding capabilities are not immediately required.

```bash
ktx setup --skip-embeddings
```

--------------------------------

### Example KTX Status Output

Source: https://github.com/kaelio/ktx/blob/main/README.md

This output shows the readiness status of the KTX project, including LLM, embeddings, database, and agent integration.

```text
ktx project: /home/user/analytics
Project ready: yes
LLM ready: yes (claude-sonnet-4-6)
Embeddings ready: yes (text-embedding-3-small)
Databases configured: yes (warehouse)
Context sources configured: yes (dbt_main)
ktx context built: yes
Agent integration ready: yes (codex:project)
```

--------------------------------

### Install Project-Scoped Agent Integration for Codex

Source: https://github.com/kaelio/ktx/blob/main/docs-site/content/docs/cli-reference/ktx-setup.mdx

Installs a project-scoped agent integration specifically for Codex. This enables Codex to interact with the project's context.

```bash
ktx setup --agents --target codex
```

--------------------------------

### Build and Test All Packages

Source: https://github.com/kaelio/ktx/blob/main/GEMINI.md

Builds and tests all packages within the workspace, filtering by the './packages/*' path.

```bash
pnpm --filter './packages/*' run build
pnpm --filter './packages/*' run test
pnpm --filter './packages/*' run type-check
```

--------------------------------

### sl_query Input Shape Example

Source: https://github.com/kaelio/ktx/blob/main/packages/cli/src/skills/sl/SKILL.md

An example of the structured JSON input for the `sl_query` tool, specifying measures, dimensions, filters, segments, ordering, and limit.

```json
{
  "connectionId": "uuid-of-the-connection",
  "measures": ["orders.total_revenue", "sum(orders.amount)"],
  "dimensions": ["customers.segment", { "field": "orders.created_at", "granularity": "month" }],
  "filters": ["orders.status != 'cancelled'", "orders.total_revenue > 10000"],
  "segments": ["orders.paid_non_refunded"],
  "order_by": [{ "field": "orders.created_at", "direction": "desc" }],
  "limit": 1000
}
```

--------------------------------

### Manage ktx runtime daemon

Source: https://github.com/kaelio/ktx/blob/main/docs-site/content/docs/cli-reference/ktx-admin.mdx

Starts, stops, or checks the status of the ktx daemon. Use --feature to specify runtime features for start.

```bash
ktx admin runtime status
ktx admin runtime start
ktx admin runtime start --feature local-embeddings
ktx admin runtime stop
```

--------------------------------

### Setup KTX with dbt Source

Source: https://github.com/kaelio/ktx/blob/main/skills/ktx/SKILL.md

Configure KTX to use dbt as a data source. Ensure you provide the connection ID, Git URL, and branch for your dbt project.

```bash
ktx setup --no-input --yes --skip-databases --skip-llm --skip-embeddings --skip-agents \
  --source dbt --source-connection-id <id> \
  --source-git-url <url> --source-branch <branch>
```

--------------------------------

### Execute Query Without Prompting for Runtime Installation

Source: https://github.com/kaelio/ktx/blob/main/docs-site/content/docs/cli-reference/ktx-sl.mdx

Execute a semantic query, automatically installing the managed Python runtime if required, without interactive prompts.

```bash
ktx sl query \
  --connection-id my-warehouse \
  --measure orders.count \
  --execute \
  --yes
```

--------------------------------

### Ingest all configured connections

Source: https://github.com/kaelio/ktx/blob/main/docs-site/content/docs/cli-reference/ktx-ingest.mdx

This command ingests every configured connection. It is equivalent to running `ktx ingest` without any arguments or the `--all` flag.

```bash
ktx ingest
```

--------------------------------

### Skip LLM setup

Source: https://github.com/kaelio/ktx/blob/main/docs-site/content/docs/cli-reference/ktx-setup.mdx

Use the --skip-llm flag to leave the LLM setup incomplete. This is useful if LLM capabilities are not immediately required or will be configured later.

```bash
ktx setup --skip-llm
```

--------------------------------

### Perform Full Refresh with KTX

Source: https://github.com/kaelio/ktx/blob/main/docs-site/content/docs/guides/building-context.mdx

Execute a full refresh of your project's context after initial setup. This involves checking status, ingesting all data, and checking status again.

```bash
ktx status
ktx ingest --all
ktx status
```

--------------------------------

### Start HTTP Compute Server (Code Execution Disabled)

Source: https://github.com/kaelio/ktx/blob/main/python/ktx-daemon/README.md

Starts the HTTP compute server on a specified host and port with code execution disabled by default.

```bash
ktx-daemon serve-http --host 127.0.0.1 --port 8765
```

--------------------------------

### Build and Test KTX Project

Source: https://github.com/kaelio/ktx/blob/main/docs-site/content/docs/community/contributing.mdx

Commands to build, type-check, and test the Kaelio KTX project using pnpm. These are essential steps before submitting changes.

```bash
pnpm --filter @kaelio/ktx run build
pnpm --filter @kaelio/ktx run type-check
pnpm --filter @kaelio/ktx run test
```