Does it provide SQL refactoring suggestions?

Absolutely. It identifies inefficient JOIN orders, unnecessary columns, and complex subqueries, suggesting modern CTE-based alternatives for better performance.

Does this skill run actual dbt commands?

Yes, it can execute core dbt commands like 'dbt compile', 'dbt show', and 'dbt debug' to verify project health and analyze model performance.

What is the dbt Model Optimizer skill?

It is a specialized capability for Claude Code that helps analyze, refactor, and optimize dbt models for better performance and efficiency.

Can it help with incremental materialization?

Yes, it provides specific guidance and implementation patterns for moving large tables to incremental models to save time and compute resources.

How does it handle very large dbt projects?

For projects with over 50 models, the skill suggests focusing on specific models and utilizes batch processing strategies to prevent memory timeouts.

dbt Model Optimizer

Name: dbt Model Optimizer
Author: nerver111

bynerver111

0•

数据库管理

Optimizes and refactors dbt models to improve SQL performance and data transformation efficiency.

The dbt Model Optimizer is a specialized Claude Code skill designed to streamline data engineering workflows by analyzing and enhancing dbt (data build tool) projects. It provides expert guidance on refactoring complex SQL, implementing efficient materialization strategies like incremental models, and optimizing database infrastructure through indexing and partitioning. By automating diagnostic commands and providing performance-focused code reviews, this skill helps developers maintain scalable data pipelines while avoiding common pitfalls like memory-intensive operations on large data structures.

主要功能

01Performance analysis for JOIN orders, CTEs, and WHERE clauses

02SQL query refactoring for performance and readability

030 GitHub stars

04Database partitioning and indexing recommendations

05Incremental model implementation and materialization strategy optimization

06Automated execution of dbt show, compile, parse, and debug commands

使用场景

01Troubleshooting slow-running data transformation pipelines

02Migrating large tables from full-refresh to incremental materialization

03Refactoring legacy dbt models to reduce cloud data warehouse costs

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add nerver111/git-skill-test dbt-model-optimizer

For use in Claude.ai and ChatGPT

主要功能

01Performance analysis for JOIN orders, CTEs, and WHERE clauses

02SQL query refactoring for performance and readability

030 GitHub stars

04Database partitioning and indexing recommendations

05Incremental model implementation and materialization strategy optimization

06Automated execution of dbt show, compile, parse, and debug commands

使用场景

01Troubleshooting slow-running data transformation pipelines

02Migrating large tables from full-refresh to incremental materialization

03Refactoring legacy dbt models to reduce cloud data warehouse costs

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add nerver111/git-skill-test dbt-model-optimizer

For use in Claude.ai and ChatGPT