dbt Model Optimization & Refactoring
Optimize and refactor your dbt models for performance and maintainability
What You Can Do
You can analyze your dbt models to identify performance bottlenecks, redundancies, and design issues, then receive concrete refactoring recommendations with implementation guidance. This skill helps you restructure models following dbt best practices, improve query efficiency, and enhance code maintainability across your entire dbt project.
Features
Identify slow queries, inefficient joins, and materialization strategy issues causing bottlenecks
Detect redundant logic, unmaintainable patterns, and violations of dbt naming conventions
Receive step-by-step refactoring plans with before/after code examples
Review existing tests and generate new test cases for refactored models
Visualize and optimize the DAG structure to reduce model interdependencies
Auto-create or improve YAML documentation for refactored models
Ensure models follow industry standards for staging, intermediate, and mart layers
Example Output
Input: Your dbt project with 50+ models
Output:
### Performance Issues Found
- stg_customers: Cartesian join in customer_transactions (20s execution time)
- fct_orders: Redundant group-by across 3 upstream models
### Refactoring Plan
1. Extract transaction aggregation into int_customer_transactions
2. Replace cartesian join with LEFT JOIN + ROW_NUMBER()
3. Add incremental logic to stg_customers (current: full refresh)
### Code Changes
-- Before
SELECT c.*, t.*
FROM raw_customers c
CROSS JOIN raw_transactions t -- Inefficient!
-- After
SELECT c.*, t.transaction_count
FROM {{ ref('stg_customers') }} c
LEFT JOIN {{ ref('int_customer_transactions') }} t
USING (customer_id)
Expected Gains: 40% query time reduction, 3 fewer dependencies, improved test coverage
What's Included
- SKILL.md: The Claude skill with dbt analysis workflows, optimization templates, and refactoring decision trees
- Model Audit Checklist: Comprehensive list of performance and maintainability criteria
- Refactoring Templates: SQL patterns for common refactoring scenarios (incremental models, staging layers, fact tables)
- Test Generation Snippets: dbt YAML templates for unit tests and model contracts
- DAG Optimization Guide: Best practices for model layering and dependency management
Who It's For
- Analytics Engineers — Refactor legacy dbt projects and improve code quality
- Data Team Leads — Establish optimization standards across your organization
- dbt Project Owners — Reduce query costs and accelerate model execution
- Data Platform Teams — Scale dbt projects while maintaining performance SLAs
Best For
- Identifying and fixing performance bottlenecks in slow-running models
- Restructuring large dbt projects to follow layered architecture (staging, intermediate, marts)
- Eliminating redundant logic and consolidating overlapping models
- Adding test coverage and documentation during refactoring
- Planning incremental materialization strategies to reduce compute costs
You might also like
Turn project descriptions, timelines, and structured data into professional draw.io diagrams instantly. You can generate flowcharts, org charts, Gantt charts, swimlane diagrams, and process flows by describing what you need. Claude creates draw.io XML that you can open directly in the editor or modify further.
by skillslib
You can design culturally appropriate survey instruments tailored to international development contexts, analyze mixed-methods data by integrating quantitative findings with qualitative insights, and implement robust data quality management systems for your field operations. Claude helps you create survey templates with adaptive logic, develop validation protocols, and produce data quality reports that highlight issues before analysis begins.
by skillslib
You can diagnose warehouse bottlenecks using structured data analysis, then generate optimized layouts and flow improvements. The skill models space utilization, labor deployment, and throughput constraints to identify quick wins and long-term improvements, delivering quantified cost savings and performance gains for your specific facility.
by skillslib
You can systematically code qualitative data against your evaluation framework, surface patterns and themes across multiple responses, extract compelling impact stories with supporting evidence, and generate summary matrices that link narrative findings to your outcomes claims. This skill maintains analytical rigor while reducing the 40-60 hours typically spent manually reviewing transcripts and open-ended survey responses per evaluation cycle.
by skillslib
Get complete, ready-to-deploy lead magnets tailored to your ideal customer profile. Claude designs the concept, writes the persuasive copy, builds the email sequences, and creates deployment strategies that attract qualified prospects and build engaged lists fast. You'll capture 3-5x more subscribers with magnetic offers that actually resonate.
by skillslib
You can convert raw discovery call notes into polished, multi-section sales proposals that include executive summaries tailored to buyer personas, needs analysis mapped to your solution architecture, tiered pricing options with competitive positioning, ROI projections with financial justification, and realistic implementation timelines. The skill preserves personalization and strategic positioning while automating structural components, letting you respond to RFPs and time-sensitive opportunities without sacrificing quality or consistency.
by skillslib
This skill analyzes property damage claims to identify viable subrogation opportunities against third-party defendants. It quantifies recovery potential using liability assessment, damages analysis, and comparable settlement benchmarks—then develops negotiation-backed strategies to maximize your recovery. The skill guides you through intake, documentation, negotiation, and settlement workflows to transform claims into recoveries.
by skillslib
This skill generates optimized facility layouts by analyzing material and personnel flow patterns, validating against operational constraints, and comparing multiple design options with quantified metrics. You provide your facility's dimensions, equipment locations, and operational requirements, and Claude produces detailed layouts with flow efficiency scores, space utilization analysis, and cost-benefit comparisons. Each layout option includes specific recommendations for improving throughput, reducing congestion points, and enhancing safety compliance.
by skillslib