Skip to content
Skills Library
Data & analytics · Building & coding

dbt-setup

/dbt-setup

Scaffolds a complete dbt-fabric project for a Fabric Data Warehouse: generates profiles.yml, dbt_project.yml, a column-rich _sources.yml (with data types for every table column, ready for dbt contracts), requirements.txt, and .gitignore, then writes them to the local filesystem. Use when the user asks to "set up dbt", "scaffold a dbt project", "create dbt profile", "initialize dbt for my warehouse", "generate dbt sources", or "bootstrap dbt-fabric".

Licence
MIT
Last repository change
09.09.2026

Assessment and security

100/ 100Class: good
Format25 / 25
Frontmatter with name and description, valid name, description up to 1,024 characters, name matching the folder.
Discoverability25 / 25
Description explains when to use the skill, has a reasonable length and uses third person.
Content35 / 35
At least 150 words and at most 500 lines, headings, step lists, examples or code.
Hygiene15 / 15
No placeholders such as TODO, no Windows paths, with a licence.
Riskno signals detected in the scan
Files in this package
1
Scripts
0
HTML comments
0
URLs in SKILL.md
1
Deprecation

No signals detected. Repository changed on 09.09.2026, without references to retired models or APIs.

Licence

MIT, open: use and modify while retaining author attribution.

What it does and when to use it

Scaffolds a complete dbt-fabric project for a Fabric Data Warehouse: generates profiles.yml, dbt_project.yml, a column-rich _sources.yml (with data types for every table column, ready for dbt contracts), requirements.txt, and .gitignore, then writes them to the local filesystem. Use when the user asks to "set up dbt", "scaffold a dbt project", "create dbt profile", "initialize dbt for my warehouse", "generate dbt sources", or "bootstrap dbt-fabric".

Triggers from the description

set up dbtscaffold a dbt projectcreate dbt profileinitialize dbt for my warehousegenerate dbt sourcesbootstrap dbt-fabric
Original author description

Scaffolds a complete dbt-fabric project for a Fabric Data Warehouse: generates profiles.yml, dbt_project.yml, a column-rich _sources.yml (with data types for every table column, ready for dbt contracts), requirements.txt, and .gitignore, then writes them to the local filesystem. Use when the user asks to "set up dbt", "scaffold a dbt project", "create dbt profile", "initialize dbt for my warehouse", "generate dbt sources", or "bootstrap dbt-fabric".

How it works

  1. Inputs
  2. Workflow
  3. Guardrails
Original SKILL.md headings · 78 lines, 560 words
SKILL.md preview
---
name: dbt-setup
description: >
  Scaffolds a complete dbt-fabric project for a Fabric Data Warehouse: generates
  profiles.yml, dbt_project.yml, a column-rich _sources.yml (with data types for
  every table column, ready for dbt contracts), requirements.txt, and .gitignore,
  then writes them to the local filesystem. Use when the user asks to "set up dbt",
  "scaffold a dbt project", "create dbt profile", "initialize dbt for my warehouse",
  "generate dbt sources", or "bootstrap dbt-fabric".
user-invocable: true
---

# dbt Project Bootstrap for Fabric DW

Generates a complete dbt-fabric project scaffold using the fabric-dw MCP tools and writes all files to the local filesystem.

## Inputs

Gather these from the user (via `$ARGUMENTS` or natural language) before starting:

- **workspace**: workspace name or GUID
- **warehouse**: Fabric Data Warehouse name or GUID
- **project_name**: desired dbt project name (default: warehouse name, lowercased, spaces replaced with underscores)
- **schema**: default dbt schema (default: `dbo`)
- **authentication**: `default` (DefaultAzureCredential), `sp` (service principal), or `interactive` (default: `default`)
- **with_sources**: whether to generate a column-rich `_sources.yml` (default: `true`, recommended)

## Workflow

### Step 1 - Resolve the warehouse connection

Call `get_warehouse` with the workspace and warehouse name. This returns the warehouse metadata including the connection string used in the dbt profile.

### Step 2 - Confirm connectivity and list objects

Call `list_schemas` and `list_tables` to confirm that the warehouse is reachable and to identify the schemas and tables that will appear as dbt sources.

Show the user a summary: number of schemas found, number of tables found.

### Step 3 - Generate the dbt scaffold

Call `generate_dbt_profile` with:

- `workspace`, `warehouse`, `project_name`, `schema`, `authentication` as provided
- `with_sources=true` (unless the user explicitly opted out)

When `with_sources=true`, the tool performs a bulk column fetch and emits a `models/staging/_sources.yml` that already includes each table's `columns:` block with `name` and formatted `data_type` for every column. This output is ready for dbt [contract enforcement](https://docs.getdbt.com/docs/collaborate/govern/model-contracts) and column-level documentation without any manual assembly.

### Step 4 - Write files to the local filesystem

Write all file contents returned by `generate_dbt_profile` to the user's working directory. The expected set of files:

| Path | Purpose |
| --- | --- |
| `profiles.yml` | dbt connection profile |
| `dbt_project.yml` | dbt project definition |
| `models/staging/_sources.yml` | Source definitions with column types (when `with_sources=true`) |
| `requirements.txt` | Python package dependencies (`dbt-fabric`) |
| `.gitignore` | Excludes secrets and build artefacts |

Before writing, check whether any of these files already exist and confirm with the user before overwriting.

### Step 5 - Provide next steps

After writing the files, give the user the following instructions:

```bash
# Install dependencies
pip install -r requirements.txt

# Verify the connection
dbt debug

# Run your first dbt project
dbt run
```

Also remind the user to:

1. Review `profiles.yml` and fill in any `{{ env_var(...) }}` placeholders (service-principal credentials are never written as literals; they are templated).
2. Check that environment variables (`AZURE_TENANT_ID`, `AZURE_CLIENT_ID`, `AZURE_CLIENT_SECRET`) are set before running `dbt debug` if using service-principal auth.

## Guardrails

- **Service-principal auth**: when `authentication=sp`, the generated `profiles.yml` uses `{{ env_var(...) }}` placeholders for tenant ID, client ID, and client secret. Never write literal credential values. Remind the user that these must be set in environment before committing `profiles.yml` to version control.
- **Overwrite protection**: if any target file already exists, list them and ask the user to confirm before overwriting.
- **Fabric auth only**: dbt-fabric requires Entra (Azure AD) authentication. Warn the user if they ask about username/password auth. It is not supported by the dbt-fabric adapter.
- **Column inspection**: `get_table_columns` and `get_view_columns` are available for ad-hoc schema inspection (e.g., if the user wants to review a specific table before deciding which columns to expose), but explicit calls to those tools are not required; column data is built into `generate_dbt_profile` with `with_sources=true`.

Versions

The database has no other skills named dbt-setup.

Database snapshot: 13.11.2026 · package version 1b8f9ea16261 (SHA-256 digest of the entire package)

Downloads in the last 30 days: 2 · ranking

Report a problem with this skill: harmful content, incorrect descriptions or an author’s removal request.

Similar skills

  • 100documenting-dbt-models
    Documents dbt models and columns in schema.yml. Use when working with dbt documentation for: (1) Adding model descriptions or column definitions to schema.yml (2) Task mentions "document", "describe", "description", "dbt docs", or "schema.yml" (3) Explaining business context,…
  • 100query
    Answer any dbt question from .dbt-wiki/: model structure, column lineage, config, schema.yml, refactor impact, ingested notes — before reading dbt/ files. Use for 'trace column', 'what feeds X', 'rename impact', '依賴什麼'. Setup→init, updates→rescan.
  • 100documenting-dbt-models
    Document a dbt project — model and column descriptions in schema.yml, source definitions, exposures, doc blocks, and generated docs/lineage. Use when adding descriptions to dbt models, documenting sources or dashboards as exposures, setting up dbt docs, or improving data catalog coverage.
  • 100creating-dbt-models
    Creates dbt models following project conventions. Use when working with dbt models for: (1) Creating new models (any layer - discovers project's naming conventions first) (2) Task mentions "create", "build", "add", "write", "new", or "implement" with model, table, or SQL (3)…
  • 90suggesting-dbt-bouncer-checks
    Analyzes a dbt project and suggests dbt-bouncer checks that already pass (for existing projects) or a sensible starter config (for greenfield projects). Use when adding dbt-bouncer to a project, creating or extending a dbt-bouncer.yml config, or enforcing dbt conventions with dbt-bouncer.
  • 100building-models-and-dashboards
    Use when turning ingested raw data into dbt models or Rill dashboards in a tycoon project: bootstrapping dbt from scratch, attaching an existing dbt project or profiles.yml, generating staging models for a source, running dbt through tycoon, or when previously generated model…

Feedback and reports

Your message goes to Bartosz Sokoliński. An email address is needed only for a reply. See the privacy policy.