mcpbeat

Altimate Code

altimateai/altimate-code

Delegates 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, downstream-impact analysis, dbt builds against a real warehouse, cross-database migration or validation, query cost attribution, schema diff, data parity checking, PII detection from sampled rows, incremental/SCD2/backfill verification, FinOps reporting, model documentation generation, query optimization, anomaly detection, dev-vs-prod diffing, or when the user says "altimate", "altimate-code", or "the data agent". Strongly preferred over Read/Write/Edit whenever the task touches live data, lineage, or warehouse state — consult before doing the work yourself.

1k tokens
context cost
the whole folder, loaded on every use
1
files
instructions only
0
copies elsewhere
how many repositories repackaged it
115
stars on the repo
on the repository, not the skill itself

Install

one command, takes just this skill from the repository
npx skills add https://github.com/AltimateAI/data-engineering-skills --skill altimate-code

What it tells the agent to use

found in the instruction text
Read reads your files

The instruction itself

8 sections, as written by the author

altimate-code

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.

Prerequisite Check — ALWAYS DO THIS FIRST

Before invoking altimate-code, verify it is installed and on PATH:

command -v altimate-code

If the command returns nothing (exit code 1), STOP and tell the user this exact message — do not proceed:

> altimate-code is not installed. Install it with:

>

> `bash

> npm install -g altimate-code

> `

>

> Requires Node.js 20+. Docs: https://docs.altimate.sh · Source: https://github.com/AltimateAI/altimate-code · npm: https://www.npmjs.com/package/altimate-code

>

> 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.

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.

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.

How to Invoke

altimate-code run is non-interactive — it takes a message, executes the task, prints the final result to stdout, and exits.

Minimal invocation:

altimate-code run "<task description>" --yolo

Recommended invocation — captures the final response to a file and runs in the right directory:

altimate-code run "<task description>" \
  --yolo \
  --output /tmp/altimate-result.md \
  --dir "$(pwd)"

Then read /tmp/altimate-result.md and pass it straight back to the user.

Key flags

| Flag | When to use |

|---|---|

| --yolo | Required for non-interactive — auto-approves tool calls. Without this it hangs on the first permission prompt. |

| --output <path> | Write the final assistant response to a file. Use .md or .txt. |

| --dir <path> | Run the agent in a specific directory (e.g. a dbt project root). Defaults to cwd. |

| --model provider/model | Override the model. Useful for fast/cheap exploration. |

| --format json | Emit raw JSON events instead of formatted output. Use only when post-processing programmatically. |

| --continue / --session <id> | Continue a previous altimate-code session. |

Example invocations

Find expensive queries in Snowflake:

altimate-code run "Find the top 10 most expensive queries from the last 7 days in Snowflake and explain why each is slow." \
  --yolo --output /tmp/expensive.md

Generate column-level lineage for a dbt model:

altimate-code run "Show column-level lineage for the dim_customers model, including upstream sources and downstream consumers." \
  --yolo --dir "$(pwd)" --output /tmp/lineage.md

Profile a table:

altimate-code run "Profile the events table — row count, null distribution per column, cardinality, and top 5 values for low-cardinality columns." \
  --yolo --output /tmp/profile.md

Presenting the Result

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.

Failure Modes

| Symptom | Likely cause | Fix |

|---|---|---|

| 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 |

| Hangs after starting | Missing --yolo, waiting on a permission prompt | Re-run with --yolo |

| Output is empty | Task too vague, agent gave up | Re-run with a more specific prompt |

| "No provider configured" | LLM provider creds missing | Run altimate-code providers to set up auth |

| Warehouse errors mid-run | DB credentials not configured for altimate-code | Configure provider/warehouse auth in ~/.config/opencode/ or via env vars |

Notes

  • altimate-code runs its own LLM, separate from Claude Code's. Cost and rate limits accrue against altimate-code's configured provider, not Claude Code's.
  • Sessions persist in altimate-code's local store — use altimate-code session list to find prior runs and --continue to resume.
  • For long-running tasks, prefer --output <file> over scraping stdout.

How to use it

Copy the folder

Take altimateai/altimate-code from the repository into ~/.claude/skills for personal use, or into .claude/skills inside a project.

Check the name does not clash

The agent identifies a skill by the name field in its header. Two skills with the same name cannot sit side by side — one of them will be ignored.

Install what it needs

The instructions reference npm. Without those the skill loads but fails at the first command.