altimate-data-engineering-skills

About altimate-data-engineering-skills

Altimate Data Engineering Skills is a collection of Claude Code skills that encode the workflows and best practices of experienced analytics engineers working with dbt, Snowflake, and data pipelines. Rather than just generating syntax, the skills teach how to approach a task — discovering existing project conventions before writing, building and verifying output, and stopping to reassess after repeated failures. The collection cites benchmark results such as 53% accuracy on ADE-bench, a 3x improvement on model-creation tasks, and an 84% pass rate on Snowflake query optimization.

The collection includes seven dbt skills (creating models, debugging errors, testing, documentation, migrating SQL to dbt, refactoring, and incremental models), three Snowflake skills (finding expensive queries, optimizing by query ID, and optimizing raw query text), and one delegation skill that hands complex tasks to the altimate-code CLI. Each skill is a markdown file with YAML frontmatter defining trigger phrases and a step-by-step workflow, for example running dbt build after creating a model and verifying with dbt show, or profiling a query, identifying bottlenecks, applying anti-pattern fixes, and testing the improvement. Installation is via a Claude Code marketplace plugin, a kit system through the altimate-code CLI (Node 20+), or manual git clone.

It targets analytics and data engineers who build and maintain dbt projects and Snowflake warehouses. The delegation skill runs the altimate-code CLI non-interactively; the operations described (dbt builds, query profiling and optimization, cost analysis) are standard data-engineering development tasks against the user's own tooling, so the collection reads as benign developer tooling.

FAQ

What is included?

Seven dbt skills (model creation, debugging, testing, documentation, SQL-to-dbt migration, refactoring, incremental models), three Snowflake skills (finding expensive queries, optimizing by query ID, optimizing query text), and one delegation skill to the altimate-code CLI.

How do I install it?

Add the Claude Code marketplace plugin and install the dbt, Snowflake, and altimate-code plugins; or use the kit system via the altimate-code CLI (npm install -g altimate-code, then kit install and activate); or clone the repository manually.

What are the prerequisites?

A dbt and/or Snowflake project to work against. The kit system and delegation skill require the altimate-code CLI, which needs Node 20+.

How do the skills know when to run?

Each skill's YAML frontmatter defines trigger phrases based on user intent, such as 'help me create a dbt model' or 'optimize this Snowflake query', so they activate automatically.

What does the delegation skill do?

It verifies the altimate-code CLI is installed, invokes it non-interactively to run a complex task, then reads the output file and summarizes the results.