dbt

Enforce dbt model naming, tests, and YAML documentation standards.

Updated Aug 23, 2026
One-click install
npx skills add https://github.com/acrulopez/dotfiles --skill dbt-acrulopez
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: dbt
Source: https://github.com/acrulopez/dotfiles/tree/main/.claude/skills/dbt
Command: npx skills add https://github.com/acrulopez/dotfiles --skill dbt-acrulopez

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

dbt modeling projects often suffer from inconsistent conventions, making pipelines harder to maintain and audit. This Skill standardizes modeling practices around naming, tests, and YAML declarations to improve reliability and governance.

Core Features & Use Cases

  • Naming & Folder Conventions: Enforces consistent model names, directory structure, and ref usage.
  • Testing & Quality: Ensures critical tests (e.g., unique and not_null) exist for primary keys and key fields.
  • Documentation & YAML: Requires per-model YAML with description and proper doc blocks to improve discoverability.

Quick Start

Enforce dbt modeling standards across a project and generate a compliant, well-documented model structure.

Frequently Asked Questions about dbt

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I enforce naming conventions in dbt models for BigQuery pipelines?

Enforce naming conventions in dbt models by standardizing model names, directory structures, and proper ref usage across analytics pipelines to ensure cleaner and more maintainable BigQuery environments. This standardization improves pipeline reliability and governance.

How do I add unique and not_null tests to dbt model primary keys?

Add unique and not_null tests to dbt model primary keys by ensuring critical tests exist for key fields within your YAML configurations. This testing practice automates SQL quality checks and validates primary key integrity across your analytics pipelines.

Does this dbt modeling standardization work with BigQuery environments?

Yes, this dbt modeling standardization applies directly to analytics pipelines in BigQuery environments. It enforces dbt-compatible configurations, proper ref usage, and YAML descriptions tailored for BigQuery data modeling workflows.

What is the best way to generate YAML descriptions for dbt models?

The best way to generate YAML descriptions for dbt models is by enforcing per-model YAML files with descriptions and proper doc blocks. This practice improves model discoverability and ensures each model includes dbt-compatible configurations.

Why do dbt projects suffer from inconsistent modeling conventions?

dbt projects suffer from inconsistent modeling conventions when naming, tests, and YAML declarations are not standardized. This inconsistency makes analytics pipelines harder to maintain, audit, and govern over time without automated quality checks.

How to standardize dbt folder structure and ref usage across a project?

Standardize dbt folder structure and ref usage by applying consistent directory conventions and proper source referencing across all models. This ensures dbt syntax compliance and generates a well-documented, auditable model structure.