skills.rest
nrakow
nrakowCOMMUNITY
Explore all skills by this author →
GitHub

dbt-project-setup

Scaffold dbt projects with folder structure, profiles, packages, and CI configuration.

1|1|Updated Feb 27, 2026
Search Tags:#scaffolding#dbt#etl#ci-cd#project-setup#profiles#data-engineering
One-click install
npx skills add https://github.com/nrakow/ae-skills-dev --skill dbt-project-setup
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: dbt-project-setup
Source: https://github.com/nrakow/ae-skills-dev/tree/main/skills/dbt-project-setup
Command: npx skills add https://github.com/nrakow/ae-skills-dev --skill dbt-project-setup

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This skill automates the scaffolding of a production-ready dbt project, including folder structure, configuration files, and CI/CD setup, so analytics teams can start delivering value faster.

Core Features & Use Cases

  • Folder & config scaffolding: Creates a complete dbt project skeleton with dbt_project.yml, profiles.yml, and packages.yml.
  • CI/CD readiness: Generates GitHub Actions workflow and macros skeletons to enable automated validation.
  • Context-aware defaults: Provides guidance on adapter config, models layout (staging, intermediate, marts), and testing strategies for common warehouses.

Quick Start

Run this skill to scaffold a production-ready dbt project in your repository.

Frequently Asked Questions about dbt-project-setup

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

FAQPage Schema
How do I scaffold a production-ready dbt project with CI/CD?▼

Scaffolding a production-ready dbt project involves generating the folder structure, profiles.yml, packages.yml, and a GitHub Actions workflow. This setup provides sensible defaults for automated validation and rapid project initialization.

What files are needed for a production dbt project setup?▼

A production dbt project setup requires dbt_project.yml, profiles.yml, and packages.yml. It also includes macro skeletons and a CI configuration file to enable automated testing and deployment workflows.

Can I use this dbt scaffolding for auditing an existing project structure?▼

Yes, scaffolding applies when starting a new dbt project or auditing an existing project structure. It validates folder layouts, configuration files, and testing strategies to ensure production readiness.

Does dbt project scaffolding include models layout and testing strategies?▼

Yes, dbt project scaffolding provides context-aware defaults for models layout, including staging, intermediate, and marts layers. It also supplies guidance on testing strategies for common data warehouses.

What is the best way to configure GitHub Actions for dbt CI pipelines?▼

The best way to configure GitHub Actions for dbt CI pipelines is generating a workflow file during project scaffolding. This automates validation steps using essential configuration files and macro skeletons.

Related Skills

Explore More Data & Analytics Skills→
astronomerastronomer
419

cosmos-dbt-core

Convert dbt Core projects into Airflow DAGs or TaskGroups using Astronomer Cosmos.

Official
Advanced
duanbiao2000duanbiao2000
3

dbt-transformation-patterns

Automate dbt project setup with staging, intermediate, and marts patterns.

Community
Advanced
borgheiborghei
467

analytics-engineer

Model data and build dbt pipelines from staging to marts.

Community
Advanced
khokskhoks
2

user_custom_strategy_intake

Scaffold custom trading strategy directories and register them in ClaudeTrading configuration.

Community
Intermediate