baekenough/dbt-best-practices
.claude/skills/dbt-best-practices/SKILL.md
dbt best practices for SQL modeling, testing, and analytics engineering workflows
$ install --global
skillsauthnpx skillsauth add baekenough/oh-my-customcode dbt-best-practicesInstall this skill globally with one command. Works with Claude Code, Cursor, and Windsurf.
Security Scan Results
3 of 9 scanners reported clean
Some scanners were skipped, did not run, or reported a non-clean status. Review each row below.
3
Scanners Passed
9
Scanners in report
Clean
TrivyContainer and dependency vulnerability scanner
95%
Clean
SemgrepStatic code analysis for vulnerabilities
95%
Clean
mcp-scan (Snyk)Model Context Protocol security validation
95%
Skipped
Snyk (dep)Open source security scanning
50%
Skipped
Socket.devSupply chain security analysis
50%
Skipped
VirusTotalMulti-engine malware detection
50%
Skipped
CrowdStrikeAdvanced threat intelligence
50%
Skipped
OSV-ScannerOpen Source Vulnerability database check
50%
Skipped
OWASP Dep-Check
50%
Last scanned: Apr 3, 2026, 8:17 PM5.5s1 file scanned
SKILL.md
- name:
- dbt-best-practices
- description:
- dbt best practices for SQL modeling, testing, and analytics engineering workflows
- scope:
- core
- user-invocable:
- false
dbt Best Practices
Project Structure
Layer Organization (CRITICAL)
- Staging: 1:1 with source tables (
stg_{source}__{entity}) - Intermediate: Business logic composition (
int_{entity}_{verb}) - Marts: Final consumption models (
fct_{entity},dim_{entity})
Materialization Strategy
- Staging:
view(lightweight, always fresh) - Intermediate:
ephemeralorview - Marts:
tableorincremental
Modeling Patterns
Naming Conventions
- Staging:
stg_source__table - Intermediate:
int_entity_verb - Facts:
fct_entity - Dimensions:
dim_entity
Incremental Models
- Use
is_incremental()macro - Define
unique_keyfor merge strategy - Choose strategy: append, merge, delete+insert
Testing
Schema Tests
unique,not_nullfor primary keysrelationshipsfor foreign keysaccepted_valuesfor enums- Custom data tests
Source Freshness
- Configure
loaded_at_field - Set freshness thresholds
Documentation
- Add descriptions to models
- Document column definitions
- Use
docblocks for reusable text - Generate and host dbt docs
References
- dbt Best Practices
Related Skills
baekenough/wiki
development
VerifiedTrustedCommunity
Generate and maintain a persistent codebase wiki — LLM-built interlinked markdown knowledge base (Karpathy LLM Wiki pattern)
15SKILL.mdUpdated Apr 16, 2026
baekenough/wiki-rag
development
VerifiedTrustedCommunity
Use the project wiki as RAG knowledge source — search wiki pages to answer codebase questions before exploring raw files
15SKILL.mdUpdated Apr 16, 2026
baekenough/skill-extractor
tools
VerifiedTrustedCommunity
Analyze task trajectories to propose reusable SKILL.md candidates from successful patterns
15SKILL.mdUpdated Apr 16, 2026
baekenough/hada-scout
data-ai
VerifiedTrustedCommunity
hada.io RSS feed monitoring for AI agent/harness articles with automated /scout analysis
15SKILL.mdUpdated Apr 16, 2026