skills/altimate-code/SKILL.md
Delegates data engineering tasks to altimate-code, a specialized CLI agent with 100+ purpose-built data tools — SQL analysis, column-level lineage, dbt build/test/run, warehouse profiling, FinOps, and connectivity to Snowflake, BigQuery, Redshift, Databricks, Postgres, MySQL, DuckDB. Use this skill when the task needs live warehouse access, column lineage, multi-step data exploration, dbt builds against a real warehouse, or when the user explicitly invokes "altimate", "altimate-code", or "the data agent".
npx skillsauth add altimateai/data-engineering-skills altimate-codeInstall this skill globally with one command. Works with Claude Code, Cursor, and Windsurf.
3 of 9 scanners reported clean
Some scanners were skipped, did not run, or reported a non-clean status. Review each row below.
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.
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:
npm install -g altimate-codeRequires 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-codeonce 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.
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.
| 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. |
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
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.
| 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 |
altimate-code session list to find prior runs and --continue to resume.--output <file> over scraping stdout.testing
Optimizes Snowflake SQL query performance from provided query text. Use when optimizing Snowflake SQL for: (1) User provides or pastes a SQL query and asks to optimize, tune, or improve it (2) Task mentions "slow query", "make faster", "improve performance", "optimize SQL", or "query tuning" (3) Reviewing SQL for performance anti-patterns (function on filter column, implicit joins, etc.) (4) User asks why a query is slow or how to speed it up
development
Optimizes Snowflake query performance using query ID from history. Use when optimizing Snowflake queries for: (1) User provides a Snowflake query_id (UUID format) to analyze or optimize (2) Task mentions "slow query", "optimize", "query history", or "query profile" with a query ID (3) Analyzing query performance metrics - bytes scanned, spillage, partition pruning (4) User references a previously run query that needs optimization Fetches query profile, identifies bottlenecks, returns optimized SQL with expected improvements.
data-ai
Finds and ranks expensive Snowflake queries by cost, time, or data scanned. Use when: (1) User asks to find slow, expensive, or problematic queries (2) Task mentions "query history", "top queries", "most expensive", or "slowest queries" (3) Analyzing warehouse costs or identifying optimization candidates (4) Finding queries that scan the most data or have the most spillage Returns ranked list of queries with metrics and optimization recommendations.
development
Adds schema tests and data quality validation to dbt models. Use when working with dbt tests for: (1) Adding or modifying tests in schema.yml files (2) Task mentions "test", "validate", "data quality", "unique", "not_null", or "accepted_values" (3) Ensuring data integrity - primary keys, foreign keys, relationships (4) Debugging test failures or understanding why dbt test failed Matches existing project test patterns and YAML style before adding new tests.