New: 97,000+ skills indexed from GitHub repos with 100+ stars · every skill safety-checkedBrowse top skillsTop skills
Esc to closeBrowse all skills
Submit a skillBrowse skills
Submit a skillBrowse skills

Agent skill

Altimate Data Warehouse Delegate

by AltimateAI in AltimateAI/data-engineering-skills

Delegates dbt and warehouse tasks such as lineage, migrations and cost attribution to the altimate-code CLI agent and relays its answer back.

MITAuto-check passedDatabases

Install Altimate Data Warehouse Delegate

skills CLI
$ npx skills add AltimateAI/data-engineering-skills --skill altimate-code -a claude-code

Project install by default; add -g for ~/.claude/skills/.

GitHub CLI
$ gh skill install AltimateAI/data-engineering-skills altimate-code --agent claude-code

Project scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).

Manual copy
$ git clone --depth 1 https://github.com/AltimateAI/data-engineering-skills.git skills-src && mkdir -p .claude/skills && cp -r skills-src/skills/altimate-code .claude/skills/altimate-code && rm -rf skills-src

Use ~/.claude/skills/ instead of .claude/skills for a personal install. The folder must contain SKILL.md.

Claude Code skills documentation · loads skills from .claude/skills/

Facts

Skill name
altimate-code
GitHub stars
127
Token cost
~1.4k tokens
SKILL.md length
516 words
Files
1
Skills in repo
12
Repo updated
First seen
Licence
MIT

At a glance

Delegates dbt and warehouse tasks such as lineage, migrations and cost attribution to the altimate-code CLI agent and relays its answer back.

  • Running a dbt build or migration against a live warehouse
  • SKILL.md covers Prerequisite Check — ALWAYS DO…, How to Invoke, Presenting the Result and Failure Modes, plus 1 more section
  • Calls npm
  • Tracing column-level lineage or downstream impact for a model

What it does

Before anything else, it checks that `altimate-code` is installed and on PATH; if it is missing, it gives the user the exact npm install command and the Node.js 20+ requirement rather than installing it on their behalf, since they may want a different version or package manager.

It invokes the tool non-interactively through its `run` command, passing the task description as the message and adding the `--yolo` flag, which is required to auto-approve tool calls and avoid hanging on a permission prompt. The recommended form also writes the final response to a file, can target a specific directory such as a dbt project root, override the model for faster exploration, or emit raw JSON events for later processing. It is meant to be consulted before doing warehouse or lineage work directly, whenever a task touches a real warehouse such as Snowflake, BigQuery, Redshift, Databricks, Postgres, MySQL or DuckDB.

When your agent uses it

  • Running a dbt build or migration against a live warehouse
  • Tracing column-level lineage or downstream impact for a model
  • Checking query cost attribution or detecting PII in sampled rows

Example prompts

  • “Ask altimate-code for the column-level lineage of our orders model.”
  • “Have altimate-code diff this table's schema between dev and prod.”
  • “Delegate a cross-database migration check to altimate-code and save the output.”

Requirements

  • altimate-code CLI installed and on PATH
  • Node.js 20 or newer

What it can do on your machine

Read from SKILL.md and the folder at commit 705c68b. It shows what the files ask for, not the result of running them.

  • Tool permissions

    Pre-approves nothing: there is no allowed-tools line, so your agent's usual permission prompts apply.

    From allowed-tools in the SKILL.md frontmatter.

  • Runs code

    Shell commands in SKILL.md call:

    • npm

    From the folder's file list and the shell code blocks in SKILL.md.

  • Network

    Links to these hosts (documentation or services it may open):

    • docs.altimate.sh
    • github.com
    • npmjs.com

    From URLs in SKILL.md, links to its own repository left out.

  • Credentials

    Names no API keys, tokens, secrets or passwords.

    From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.

Context cost

Altimate Data Warehouse Delegate loads about 1.4k tokens when it runs. Until then it costs about 215 tokens; SKILL.md has 516 words of instructions outside code blocks.

Always · name and description, kept in context so the agent knows when to use it
~215
When it runs · the whole SKILL.md, loaded when a task matches
~1.4k

Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.

Safety

Auto-check passed

The automated check found no risky patterns in SKILL.md.

Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); files beside SKILL.md are not scanned.

SKILL.md

The full file from AltimateAI/data-engineering-skills at commit 705c68b, republished under its MIT licence (© AltimateAI). 516 words, ~1,351 tokens.

Download SKILL.mdSave it as .claude/skills/altimate-code/SKILL.md (or your agent's skills folder).
name
altimate-code
description
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.

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:

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

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

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

bash
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
FlagWhen to use
--yoloRequired 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/modelOverride the model. Useful for fast/cheap exploration.
--format jsonEmit raw JSON events instead of formatted output. Use only when post-processing programmatically.
--continue / --session <id>Continue a previous altimate-code session.
Show full SKILL.md (195 more words)Show less
Example invocations

Find expensive queries in Snowflake:

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

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

bash
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

SymptomLikely causeFix
altimate-code: command not foundNot installed or not on PATHRun 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 startingMissing --yolo, waiting on a permission promptRe-run with --yolo
Output is emptyTask too vague, agent gave upRe-run with a more specific prompt
"No provider configured"LLM provider creds missingRun altimate-code providers to set up auth
Warehouse errors mid-runDB credentials not configured for altimate-codeConfigure 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.

© AltimateAI, MIT. Rendered from Markdown: HTML in the file is shown as text, images as links, and headings moved down two levels. Raw file

Files

Just SKILL.md in skills/altimate-code of AltimateAI/data-engineering-skills.

Open the folder on GitHubat commit 705c68b

Compare with similar skills

Altimate Data Warehouse Delegate next to the 5 skills that share the most tags, products or categories with it. Stars are the repository's; “used in” counts other GitHub owners with a copy.

Altimate Data Warehouse Delegate compared with similar skills
SkillStarsUsed inTokensAuto-checkLicenceRepo updated
Altimate Data Warehouse Delegate this skillAltimateAI/data-engineering-skills127—~1.4kAutomated safety check: PassMIT
Mfs Findzilliztech/mfs150—~4kAutomated safety check: PassApache-2.0
Mfs Ingestzilliztech/mfs150—~4.7kAutomated safety check: PassApache-2.0
Semantic Analystsidequery/sidemantic129—~982Automated safety check: PassAGPL-3.0
SQL Queriesw95/awesome-claude-corporate-skills2353 repos~2.8kAutomated safety check: PassMIT
Connecting To Data Sourceaws/agent-toolkit-for-aws2.8k1 repos~2.2kAutomated safety check: PassApache-2.0

Similar skills

  • Mfs Find

    zilliztech/mfs

    Search, grep, browse, and read across registered MFS data sources via the mfs CLI — codebases, docs, PDFs, web crawls, databases (postgres/mysql/mongo/snowflake/bigquery), issue trackers…

    150 GitHub stars~4k tokensUpdated 2 mo ago
    DatabasesAuto-check passed

  • Mfs Ingest

    zilliztech/mfs

    Register, update, or re-sync data sources for MFS so they become searchable — postgres / mysql / mongo / snowflake / bigquery, github / jira / linear / notion / hubspot / zendesk, slack / discord /…

    150 GitHub stars~4.7k tokensUpdated 2 mo ago
    DatabasesAuto-check passed

  • Semantic Analyst

    sidequery/sidemantic

    Answer analytical, KPI, metric, trend, cohort, and business-performance questions through a Sidemantic semantic layer.

    129 GitHub stars~982 tokensUpdated today
    DatabasesAuto-check passed

  • SQL Queries

    w95/awesome-claude-corporate-skills

    Write correct, performant SQL across all major data warehouse dialects (Snowflake, BigQuery, Databricks, PostgreSQL, etc.).

    235 GitHub starsUsed in 3 repos~2.8k tokens
    DatabasesAuto-check passed

  • Connecting To Data Source

    aws/agent-toolkit-for-aws

    Official

    Create and troubleshoot AWS Glue connections to JDBC databases (Oracle, SQL Server, PostgreSQL, MySQL, RDS), Redshift, Snowflake, and BigQuery.

    2.8k GitHub starsUsed in 1 repo~2.2k tokens
    DatabasesAuto-check passed

  • SQL Queries

    phuryn/pm-skills

    Generate SQL queries from natural language descriptions. An agent skill from phuryn/pm-skills.

    27k GitHub stars~907 tokensUpdated 23 days ago
    DatabasesAuto-check passed

More from AltimateAI/data-engineering-skills

All 12 skills in this repo

  • dbt Model Builder

    AltimateAI/data-engineering-skills

    Creates or modifies dbt models in line with a project's own conventions, then runs dbt build and dbt show to check the output instead of stopping at compile.

    127 GitHub stars~890 tokensUpdated 6 days ago
    Auto-check passed

  • dbt Error Debugging

    AltimateAI/data-engineering-skills

    Walks through fixing dbt compilation, database and test errors: read the full error, check upstream models, apply a fix, then verify with dbt build and a data preview.

    127 GitHub stars~1.1k tokensUpdated 6 days ago
    Auto-check passed

  • dbt Incremental Models

    AltimateAI/data-engineering-skills

    Helps choose an incremental strategy, design a reliable unique_key and debug failing dbt incremental models, and says when a plain table is the better choice.

    127 GitHub stars~2.3k tokensUpdated 6 days ago
    Auto-check passed

  • dbt Model Documentation

    AltimateAI/data-engineering-skills

    Writes model and column descriptions in dbt schema.yml files, matching the project's existing documentation style and recording grain, business rules and caveats.

    127 GitHub stars~1.2k tokensUpdated 6 days ago
    Auto-check passed

  • Expensive Snowflake Query Finder

    AltimateAI/data-engineering-skills

    Ranks the costliest, slowest or heaviest-scanning Snowflake queries from query history and suggests how to optimize them.

    127 GitHub stars~662 tokensUpdated 6 days ago
    Auto-check passed

  • Migrating SQL To Dbt

    AltimateAI/data-engineering-skills

    Converts legacy SQL to modular dbt models. An agent skill from AltimateAI/data-engineering-skills.

    127 GitHub stars~762 tokensUpdated 6 days ago
    Auto-check passed

Works with

Categories

Questions about Altimate Data Warehouse Delegate

What does Altimate Data Warehouse Delegate do?

Delegates dbt and warehouse tasks such as lineage, migrations and cost attribution to the altimate-code CLI agent and relays its answer back. js 20+ requirement rather than installing it on their behalf, since they may want a different version or package manager.

When should I use Altimate Data Warehouse Delegate?

Altimate Data Warehouse Delegate fits situations like: running a dbt build or migration against a live warehouse; tracing column-level lineage or downstream impact for a model; checking query cost attribution or detecting PII in sampled rows.

How do I install Altimate Data Warehouse Delegate in Claude Code?

Run `npx skills add AltimateAI/data-engineering-skills --skill altimate-code -a claude-code`. Or copy the skill folder (skills/altimate-code in AltimateAI/data-engineering-skills) into .claude/skills/altimate-code in your project. Claude Code loads it when a task matches its description.

How do I install Altimate Data Warehouse Delegate in Codex?

Run `npx skills add AltimateAI/data-engineering-skills --skill altimate-code -a codex`. Or copy the skill folder (skills/altimate-code in AltimateAI/data-engineering-skills) into .agents/skills/altimate-code in your project. Codex loads it when a task matches its description.

Can I use Altimate Data Warehouse Delegate in Cursor, Gemini CLI or GitHub Copilot?

Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add AltimateAI/data-engineering-skills --skill altimate-code -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/altimate-code, .gemini/skills/altimate-code, .github/skills/altimate-code and .opencode/skills/altimate-code in your project.

What does Altimate Data Warehouse Delegate need to run?

Going by SKILL.md and its folder, Altimate Data Warehouse Delegate needs the command-line tools its instructions call (npm). Our summary lists: altimate-code CLI installed and on PATH; Node.js 20 or newer.

Does Altimate Data Warehouse Delegate access the network?

SKILL.md names 3 domains. As links in the text: docs.altimate.sh, github.com and npmjs.com. This is read from the text; nothing was executed.

Is Altimate Data Warehouse Delegate safe to install?

Our automated static check of SKILL.md found no risky patterns, such as piping downloads into a shell, reading credential files or hidden Unicode. It is not a guarantee. Review the folder before installing.

What licence does Altimate Data Warehouse Delegate use?

Altimate Data Warehouse Delegate is published under the MIT licence (the repository's licence). It allows redistribution, so the full SKILL.md is shown on this page.

How many tokens does Altimate Data Warehouse Delegate use?

About 1.4k tokens (SKILL.md is roughly 5.4k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full.

What are the alternatives to Altimate Data Warehouse Delegate?

Skills that share tags, products or a category with Altimate Data Warehouse Delegate: Mfs Find (zilliztech/mfs, 150 stars), Mfs Ingest (zilliztech/mfs, 150 stars), Semantic Analyst (sidequery/sidemantic, 129 stars) and SQL Queries (w95/awesome-claude-corporate-skills, 235 stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.

Who maintains Altimate Data Warehouse Delegate?

AltimateAI (a GitHub organization) maintains it in AltimateAI/data-engineering-skills, which has 127 GitHub stars. The repository holds 12 skills in this directory. The repository was last updated on October 1, 2026.

Source: AltimateAI/data-engineering-skills on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.