dbt-project-analyzer

Solid

Analyzes dbt projects for best practices, performance, maintainability, and generates actionable recommendations for improvement.

AI & Automation 1,160 stars 71 forks Updated today MIT

Install

View on GitHub

Quality Score: 99/100

Stars 20%
100
Recency 20%
100
Frontmatter 20%
70
Documentation 15%
100
Issue Health 10%
50
License 10%
100
Description 5%
100

Skill Content

# dbt Project Analyzer Analyzes dbt projects for best practices, performance, and maintainability following dbt Labs recommended patterns. ## Overview This skill examines dbt project structure, model dependencies, test coverage, documentation completeness, and adherence to naming conventions. It provides actionable recommendations for improving project health and maintainability. ## Capabilities - **Model dependency graph analysis** - Visualize and analyze model relationships, detect circular dependencies - **Incremental model optimization** - Evaluate incremental strategies and suggest improvements - **Materialization strategy recommendations** - Recommend optimal materializations based on usage patterns - **Test coverage analysis** - Measure and report on test coverage across models - **Documentation completeness check** - Identify undocumented models, columns, and sources - **Naming convention validation** - Enforce consistent naming patterns (staging, marts, intermediate) - **Ref/source usage validation** - Detect hardcoded references and missing source definitions - **Macro efficiency analysis** - Evaluate macro usage and suggest optimizations - **Slim CI optimization** - Configure efficient CI builds with state comparison - **Model contract validation** - Verify model contracts for type safety ## Input Schema ```json { "projectPath": { "type": "string", "description": "Path to the dbt project root directory", "required": true }, "manifestJson": ...

Details

Author
a5c-ai
Repository
a5c-ai/babysitter
Created
4 months ago
Last Updated
today
Language
JavaScript
License
MIT

Similar Skills

Semantically similar based on skill content — not just same category

AI & Automation Listed

dbt-transformation-patterns

Master dbt (data build tool) for analytics engineering with model organization, testing, documentation, and incremental strategies. Use when building data transformations, creating data models, or implementing analytics engineering best practices.

2 Updated today
Mohammadibrahim55
AI & Automation Solid

dbt-transformation-patterns

Master dbt (data build tool) for analytics engineering with model organization, testing, documentation, and incremental strategies. Use when building data transformations, creating data models, or implementing analytics engineering best practices.

36,222 Updated today
wshobson
Data & Documents Listed

dbt-transformation-patterns

Master dbt (data build tool) for analytics engineering with model organization, testing, documentation, and incremental strategies. Use when building data transformations, creating data models, or implementing analytics engineering best practices.

335 Updated today
aiskillstore
Data & Documents Solid

dbt-transformation-patterns

Production-ready patterns for dbt (data build tool) including model organization, testing strategies, documentation, and incremental processing.

39,350 Updated today
sickn33
Data & Documents Listed

dbt-patterns

dbt model design, ref chains, sources, tests, macros, incremental strategies, materializations, and documentation best practices. Use this skill whenever the user is writing or reviewing dbt models, configuring dbt tests, designing model layers (staging/intermediate/marts), asking about incremental models, choosing materializations, writing macros, setting up sources.yml, or troubleshooting dbt run/test failures. Also trigger when the user mentions dbt refs, lineage graphs, model dependencies, dbt Cloud, the dbt CLI, or when they want to transform data already in the warehouse using SQL. If the project uses dbt at all, this skill should be active for any transformation questions.

0 Updated 5 days ago
Methasit-Pun