data-engineering-skills

In the author's own words, from each skill's SKILL.md.

• 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 att…

  skills/altimate-code/SKILL.md on GitHub (opens in a new tab)

• optimizing-databricks-sql

  Analyze DBSQL queries, including SQL embedded in notebooks (`spark.sql(...)`, `%sql` cells), for anti-patterns, lint issues, and performance problems, using Databricks-specific dialect and platform knowledge (Delta, Photon, Unity Catalog) layered on top of altimate-code's generic SQL engine. Use when a user asks to optimize, review, or lint DBSQL queries on Databricks, whether standalone or embed…

  skills/databricks/optimizing-databricks-sql/SKILL.md on GitHub (opens in a new tab)

• creating-dbt-models

  Creates dbt models following project conventions. Use when working with dbt models for: (1) Creating new models (any layer - discovers project's naming conventions first) (2) Task mentions "create", "build", "add", "write", "new", or "implement" with model, table, or SQL (3) Modifying existing model logic, columns, joins, or transformations (4) Implementing a model from schema.yml specs or expect…

  skills/dbt/creating-dbt-models/SKILL.md on GitHub (opens in a new tab)

• dbt-model-enhancement

  Scoped enhancement of ONE existing dbt model from a ticket, with a validated PR as the deliverable. Use when: (1) User says "update <model> per JIRA-123", "add column X to this model", "enhance <model> based on this ticket" (2) Task is a scoped change to a specific existing model — one model, one ticket, one PR (3) User expects dbt build + self-review + PR open at the end (4) The change can be de…

  skills/dbt/dbt-model-enhancement/SKILL.md on GitHub (opens in a new tab)

• debugging-dbt-errors

  Debugs and fixes dbt errors systematically. Use when working with dbt errors for: (1) Task mentions "fix", "error", "broken", "failing", "debug", "wrong", or "not working" (2) Compilation Error, Database Error, or test failures occur (3) Model produces incorrect output or unexpected results (4) Need to troubleshoot why a dbt command failed Reads full error, checks upstream first, runs dbt build (…

  skills/dbt/debugging-dbt-errors/SKILL.md on GitHub (opens in a new tab)

• developing-incremental-models

  Develops and troubleshoots dbt incremental models. Use when working with incremental materialization for: (1) Creating new incremental models (choosing strategy, unique_key, partition) (2) Task mentions "incremental", "append", "merge", "upsert", or "late arriving data" (3) Troubleshooting incremental failures (merge errors, partition pruning, schema drift) (4) Optimizing incremental performance…

  skills/dbt/developing-incremental-models/SKILL.md on GitHub (opens in a new tab)

• documenting-dbt-models

  Documents dbt models and columns in schema.yml. Use when working with dbt documentation for: (1) Adding model descriptions or column definitions to schema.yml (2) Task mentions "document", "describe", "description", "dbt docs", or "schema.yml" (3) Explaining business context, grain, meaning of data, or business rules (4) Preparing dbt docs generate or improving model discoverability Matches exist…

  skills/dbt/documenting-dbt-models/SKILL.md on GitHub (opens in a new tab)

• migrating-sql-to-dbt

  Converts legacy SQL to modular dbt models. Use when migrating SQL to dbt for: (1) Converting stored procedures, views, or raw SQL files to dbt models (2) Task mentions "migrate", "convert", "legacy SQL", "transform to dbt", or "modernize" (3) Breaking monolithic queries into modular layers (discovers project conventions first) (4) Porting existing data pipelines or ETL to dbt patterns Checks for…

  skills/dbt/migrating-sql-to-dbt/SKILL.md on GitHub (opens in a new tab)

• mssql-to-snowflake-dbt-migration

  Convert MS SQL Server source code (stored procs, views, T-SQL scripts) into dbt models targeting Snowflake, with build-first-then-parity, isolated-schema deployment, and a migration dashboard. Use when: (1) User says "migrate this T-SQL to dbt on Snowflake", "convert these stored procs end-to-end", "move <schema> from SQL Server to Snowflake" (2) Source lives in a repo as `.sql` dumps OR behind a…

  skills/dbt/mssql-to-snowflake-dbt-migration/SKILL.md on GitHub (opens in a new tab)

• refactoring-dbt-models

  Safely refactors dbt models with downstream impact analysis. Use when restructuring dbt models for: (1) Task mentions "refactor", "restructure", "extract", "split", "break into", or "reorganize" (2) Extracting CTEs to intermediate models or creating macros (3) Modifying model logic that has downstream consumers (4) Renaming columns, changing types, or reorganizing model dependencies Analyzes all…

  skills/dbt/refactoring-dbt-models/SKILL.md on GitHub (opens in a new tab)

• testing-dbt-models

  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…

  skills/dbt/testing-dbt-models/SKILL.md on GitHub (opens in a new tab)

• end-to-end-snowflake-pipeline

  Build an end-to-end Snowflake pipeline — ticket → dbt models + orchestration DAG → PR → self-review → ticket comment. Use when: (1) User says "build a pipeline for X **end-to-end**", "create an end-to-end flow", "set up the <X> pipeline per JIRA-123" (2) Scope spans dbt models AND orchestration AND a PR — not just one of them (3) Target warehouse is Snowflake and the dbt project already exists (4…

  skills/snowflake/end-to-end-snowflake-pipeline/SKILL.md on GitHub (opens in a new tab)

• finding-expensive-queries

  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…

  skills/snowflake/finding-expensive-queries/SKILL.md on GitHub (opens in a new tab)

• optimizing-query-by-id

  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…

  skills/snowflake/optimizing-query-by-id/SKILL.md on GitHub (opens in a new tab)

• optimizing-query-text

  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…

  skills/snowflake/optimizing-query-text/SKILL.md on GitHub (opens in a new tab)

• snowflake-dbt-model-refactoring

  Refactor a bloated dbt model on Snowflake safely and produce a quantified before/after report that explains **which qualities improved and why** — not just raw deltas. Extends the standard refactor flow with (1) downstream impact analysis via `dbt-analyze`, (2) row-count + column-hash parity validation via `data-parity`, (3) a report that lands a Bottleneck Summary and an "Outcome axes improved"…

  skills/snowflake/snowflake-dbt-model-refactoring/SKILL.md on GitHub (opens in a new tab)

• snowflake-query-optimization

  End-to-end Snowflake query optimization — fetch, rewrite, prove parity, benchmark, report. Use when: (1) User wants an **end-to-end flow** (fetch + rewrite + parity + benchmark + report), not just a rewrite (2) Input is a `.sql` file path in the repo (optionally `:L10-L80` line range), OR a Snowflake `query_id` (UUID) (3) User expects a correctness proof (row-count + per-column signature + multip…

  skills/snowflake/snowflake-query-optimization/SKILL.md on GitHub (opens in a new tab)

No skill matches that filter.

Similar skills

• planning-with-filesby OthmanAdi Persistent file-based planning for AI coding agents and long-running tasks. Crash-proof markdown plans, session recovery after /clear and c… 27.9k stars · 6 skills
• AI-Research-SKILLsby Orchestra-Research Comprehensive open-source library of AI research and engineering skills for any AI model. Package the skills and your claude code/codex/gem… 14.3k stars · 30 skills
• claude-skillsby Jeffallan 67 Specialized Skills for Full-Stack Developers. Transform Claude Code into your expert pair programmer. 12.2k stars · 30 skills
• open-seo-mcp-skillsby Ryze-AI-Adgent Free SEO MCP server + open-source SEO and GEO skills for Claude: keyword research, rank tracking, audits, backlinks, AI visibility on your… 8.9k stars · 8 skills
• replica-skillby Jakeschincariol Eleven free Claude skills that clone any app: reverse-engineer it, rebuild it, test it for bugs, then fix what its users hate. Free, MIT. 7.8k stars · 11 skills
• appllama-skillsby Appllama A builder, not just a researcher. Agent skills that turn top-grossing app patterns into native-quality mobile screens. 4.9k stars · 2 skills