OpenParable
Skip to content
← Back to skills

Dbt Project Analyzer

Testing & Quality
dbt-project-analyzer

Dbt Project Analyzer is an Agent Skill for testing & quality published in the a5c-ai/babysitter repository on GitHub: a SKILL.md instruction file an AI agent can load to do this task.

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

View on GitHub ↗
QUICK START

How to use this skill

Bring this guide into your coding agent with a prompt tailored to the tool you use.

  1. Open your project in Codex.
  2. Copy and paste the prompt below.
  3. Review files and risks before approving any action.
Prompt to paste
Inspect the Agent Skill at https://github.com/a5c-ai/babysitter/blob/HEAD/library/specializations/data-engineering-analytics/skills/dbt-project-analyzer/SKILL.md and all supporting files. Report provenance, permissions, scripts, dependencies, and security risks. Propose an exact installation into .agents/skills/dbt-project-analyzer, but wait for my approval before writing files or running scripts.

Copying this prompt does not install or run the skill. Review third-party files before use.

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

{
  "projectPath": {
    "type": "string",
    "description": "Path to the dbt project root directory",
    "required": true
  },
  "manifestJson": {
    "type": "object",
    "description": "Parsed manifest.json from target/ directory (optional, will be loaded if not provided)"
  },
  "catalogJson": {
    "type": "object",
    "description": "Parsed catalog.json from target/ directory (optional)"
  },
  "runResults": {
    "type": "object",
    "description": "Parsed run_results.json for performance analysis (optional)"
  },
  "analysisDepth": {
    "type": "string",
    "enum": ["quick", "standard", "deep"],
    "default": "standard",
    "description": "Depth of analysis to perform"
  },
  "focusAreas": {
    "type": "array",
    "items": {
      "type": "string",
      "enum": ["performance", "testing", "documentation", "naming", "incremental", "dependencies"]
    },
    "description": "Specific areas to focus analysis on (all if not specified)"
  }
}

Output Schema

{
  "healthScore": {
    "type": "number",
    "description": "Overall project health score (0-100)"
  },
  "issues": {
    "type": "array",
    "items": {
      "severity": "error|warning|info",
      "category": "string",
      "model": "string",
      "message": "string",
      "recommendation": "string",
      "line": "number"
    }
  },
  "metrics": {
    "testCoverage": {
      "type": "number",
      "description": "Percentage of models with tests"
    },
    "docCoverage": {
      "type": "number",
      "description": "Percentage of models/columns documented"
    },
    "incrementalRatio": {
      "type": "number",
      "description": "Percentage of eligible models using incremental"
    },
    "avgModelDepth": {
      "type": "number",
      "description": "Average depth in DAG"
    },
    "totalModels": {
      "type": "number"
    },
    "totalTests": {
      "type": "number"
    }
  },
  "recommendations": {
    "type": "array",
    "items": {
      "priority": "high|medium|low",
      "category": "string",
      "description": "string",
      "effort": "string",
      "impact": "string"
    }
  },
  "dependencyGraph": {
    "type": "object",
    "description": "Simplified dependency graph for visualization"
  }
}

Usage Examples

Basic Project Analysis

# Invoke skill for standard analysis
/skill dbt-project-analyzer --projectPath ./my-dbt-project

Deep Analysis with Focus Areas

{
  "projectPath": "./analytics",
  "analysisDepth": "deep",
  "focusAreas": ["performance", "testing", "incremental"]
}

CI Integration Analysis

{
  "projectPath": "./dbt_project",
  "manifestJson": "./target/manifest.json",
  "runResults": "./target/run_results.json",
  "focusAreas": ["performance"]
}

Analysis Rules

Naming Conventions

LayerPatternExample
Stagingstg_<source>__<entity>stg_stripe__payments
Intermediateint_<entity>_<verb>int_payments_pivoted
Martsfct_<entity> or dim_<entity>fct_orders, dim_customers

Test Coverage Requirements

SeverityCondition
ErrorNo unique/not_null test on primary key
Warning< 50% columns have tests
InfoMissing relationship tests

Materialization Guidelines

Model TypeRecommendedReason
StagingView or EphemeralSource transformations, low compute
IntermediateEphemeralReduce warehouse clutter
MartsTable or IncrementalEnd-user queries, performance
Large tables (>1M rows)IncrementalReduce build time

Integration Points

MCP Server Integration

This skill integrates with the official dbt MCP server for enhanced capabilities:

  • dbt-labs/dbt-mcp - Project metadata discovery, model information, semantic layer querying
  • dbt Remote MCP Server - Cloud-hosted dbt MCP with secure endpoint access

Applicable Processes

  • dbt Project Setup (dbt-project-setup.js)
  • dbt Model Development (dbt-model-development.js)
  • Metrics Layer (metrics-layer.js)
  • Incremental Model Setup (incremental-model.js)

References

Version History

  • 1.0.0 - Initial release with core analysis capabilities