$npx -y skills add AltimateAI/data-engineering-skills --skill altimate-codeDelegates dbt and warehouse work to altimate-code, a specialized CLI agent with 100+ purpose-built data tools. USE THIS SKILL FIRST whenever the task mentions or implies: warehouse access (Snowflake, BigQuery, Redshift, Databricks, Postgres, MySQL, DuckDB), column-level lineage,
| 1 | # altimate-code |
| 2 | |
| 3 | altimate-code is a CLI AI agent that ships with native data engineering tools. This skill delegates work to it via its non-interactive `run` mode and presents the result back to the user. |
| 4 | |
| 5 | ## Prerequisite Check — ALWAYS DO THIS FIRST |
| 6 | |
| 7 | Before invoking altimate-code, verify it is installed and on `PATH`: |
| 8 | |
| 9 | ```bash |
| 10 | command -v altimate-code |
| 11 | ``` |
| 12 | |
| 13 | **If the command returns nothing (exit code 1), STOP and tell the user this exact message — do not proceed:** |
| 14 | |
| 15 | > altimate-code is not installed. Install it with: |
| 16 | > |
| 17 | > ```bash |
| 18 | > npm install -g altimate-code |
| 19 | > ``` |
| 20 | > |
| 21 | > Requires Node.js 20+. Docs: https://docs.altimate.sh · Source: https://github.com/AltimateAI/altimate-code · npm: https://www.npmjs.com/package/altimate-code |
| 22 | > |
| 23 | > After installing, run `altimate-code` once to configure it — this launches the TUI where you set up your LLM provider auth and warehouse connections. Then re-run your request and I'll delegate it. |
| 24 | |
| 25 | Do not attempt to install altimate-code on the user's behalf — they may want a specific version, a different package manager (e.g. pnpm/yarn global), or to opt out entirely. Surface the command and let them decide. |
| 26 | |
| 27 | If `command -v` fails but the user says it is installed, suggest checking `npm bin -g` is on `PATH`, or running `npm config get prefix` to find the global install location. |
| 28 | |
| 29 | ## How to Invoke |
| 30 | |
| 31 | `altimate-code run` is non-interactive — it takes a message, executes the task, prints the final result to stdout, and exits. |
| 32 | |
| 33 | **Minimal invocation:** |
| 34 | |
| 35 | ```bash |
| 36 | altimate-code run "<task description>" --yolo |
| 37 | ``` |
| 38 | |
| 39 | **Recommended invocation** — captures the final response to a file and runs in the right directory: |
| 40 | |
| 41 | ```bash |
| 42 | altimate-code run "<task description>" \ |
| 43 | --yolo \ |
| 44 | --output /tmp/altimate-result.md \ |
| 45 | --dir "$(pwd)" |
| 46 | ``` |
| 47 | |
| 48 | Then read `/tmp/altimate-result.md` and pass it straight back to the user. |
| 49 | |
| 50 | ### Key flags |
| 51 | |
| 52 | | Flag | When to use | |
| 53 | |---|---| |
| 54 | | `--yolo` | Required for non-interactive — auto-approves tool calls. Without this it hangs on the first permission prompt. | |
| 55 | | `--output <path>` | Write the final assistant response to a file. Use `.md` or `.txt`. | |
| 56 | | `--dir <path>` | Run the agent in a specific directory (e.g. a dbt project root). Defaults to cwd. | |
| 57 | | `--model provider/model` | Override the model. Useful for fast/cheap exploration. | |
| 58 | | `--format json` | Emit raw JSON events instead of formatted output. Use only when post-processing programmatically. | |
| 59 | | `--continue` / `--session <id>` | Continue a previous altimate-code session. | |
| 60 | |
| 61 | ### Example invocations |
| 62 | |
| 63 | **Find expensive queries in Snowflake:** |
| 64 | |
| 65 | ```bash |
| 66 | altimate-code run "Find the top 10 most expensive queries from the last 7 days in Snowflake and explain why each is slow." \ |
| 67 | --yolo --output /tmp/expensive.md |
| 68 | ``` |
| 69 | |
| 70 | **Generate column-level lineage for a dbt model:** |
| 71 | |
| 72 | ```bash |
| 73 | altimate-code run "Show column-level lineage for the dim_customers model, including upstream sources and downstream consumers." \ |
| 74 | --yolo --dir "$(pwd)" --output /tmp/lineage.md |
| 75 | ``` |
| 76 | |
| 77 | **Profile a table:** |
| 78 | |
| 79 | ```bash |
| 80 | altimate-code run "Profile the events table — row count, null distribution per column, cardinality, and top 5 values for low-cardinality columns." \ |
| 81 | --yolo --output /tmp/profile.md |
| 82 | ``` |
| 83 | |
| 84 | ## Presenting the Result |
| 85 | |
| 86 | Read the output file with the Read tool and pass the content through to the user as-is. Do not re-summarize, re-format, or interpret — altimate-code has already produced the answer. |
| 87 | |
| 88 | ## Failure Modes |
| 89 | |
| 90 | | Symptom | Likely cause | Fix | |
| 91 | |---|---|---| |
| 92 | | `altimate-code: command not found` | Not installed or not on `PATH` | Run `npm install -g altimate-code` (Node 20+). If installed but not found, check `npm bin -g` is on `PATH`. See https://docs.altimate.sh | |
| 93 | | Hangs after starting | Missing `--yolo`, waiting on a permission prompt | Re-run with `--yolo` | |
| 94 | | Output is empty | Task too vague, agent gave up | Re-run with a more specific prompt | |
| 95 | | "No provider configured" | LLM provider creds missing | Run `altimate-code providers` to set up auth | |
| 96 | | Warehouse errors mid-run | DB credentials not configured for altimate-code | Configure provider/warehouse auth in `~/.confi |