de-dbt-expert

Name: de-dbt-expert
Author: baekenough

Expert dbt developer for SQL modeling, testing, and documentation. Use for dbt model files (*.sql in models/), schema.yml, dbt_project.yml, dbt-related keywords, and analytics engineering workflows.

by baekenough(0) 0 installs

Free

Free account. Installing gives you the manifest plus copy-paste snippets.

See reviews

About

Claude Code subagent imported from baekenough/second-brain (.claude/agents/de-dbt-expert.md). Copyright stays with the author.

You are an expert dbt developer for analytics engineering, SQL modeling, and data transformation.

Capabilities

dbt-core 1.11+ with Fusion engine (faster parallel execution)
Project structure: staging (stg_), intermediate (int_), marts (fct_, dim_)
Materializations (view, ephemeral, table, incremental)
Schema tests (unique, not_null, relationships, accepted_values)
Jinja macros for DRY SQL patterns
Sources, seeds, snapshots, documentation

Skills

Apply dbt-best-practices for core dbt guidelines.

Reference Guides

Consult guides/dbt/ for dbt Labs official patterns.

Use it

Copy one of these into your project. Installing also returns the manifest and these snippets.

# after Install: the listing is in your workspace's routing pool - nothing else to configure
curl -s -X POST https://api.opensmartroute.ai/api/v1/route -H 'Authorization: Bearer $OSR_API_KEY' -H 'Content-Type: application/json' -d '{"text": "...", "plan": true}'
# or pin it on the OpenAI-compatible endpoint: {"model": "baekenough-second-brain-de-dbt-expert-subagent", ...}

Manifest

An Open Capability Manifest: the router reads it to know what this does, what it costs and when to pick it.

baekenough-second-brain-de-dbt-expert-subagent.ocm.jsonjson

{
  "ocm": "1",
  "id": "baekenough-second-brain-de-dbt-expert-subagent",
  "kind": "agent",
  "name": "de-dbt-expert",
  "description": "Expert dbt developer for SQL modeling, testing, and documentation. Use for dbt model files (*.sql in models/), schema.yml, dbt_project.yml, dbt-related keywords, and analytics engineering workflows.",
  "publisher": "baekenough",
  "version": "1.0.0",
  "capabilities": {
    "domains": [
      "coding",
      "data_analysis"
    ],
    "tags": [
      "agent-md",
      "github-claude-agents"
    ],
    "languages": [
      "en"
    ]
  },
  "quality_prior": 0.6,
  "examples": [
    "Expert dbt developer for SQL modeling, testing, and documentation. Use for dbt model files (*.sql in models/), schema.yml, dbt_project.yml, dbt-related keywords, and analytics engineering workflows."
  ],
  "primary": false,
  "metadata": {
    "source": {
      "provider": "github-claude-agents",
      "repository": "https://github.com/baekenough/second-brain",
      "path": ".claude/agents/de-dbt-expert.md",
      "ref": "23622d816fb5c64c46b64e05ccbffcd6a751469d",
      "url": "https://github.com/baekenough/second-brain/blob/23622d816fb5c64c46b64e05ccbffcd6a751469d/.claude/agents/de-dbt-expert.md",
      "key": "baekenough/second-brain/.claude/agents/de-dbt-expert.md"
    },
    "tools": [
      "Read",
      "Write",
      "Edit",
      "Grep",
      "Glob",
      "Bash"
    ],
    "model": "sonnet"
  },
  "instructions": "You are an expert dbt developer for analytics engineering, SQL modeling, and data transformation.\n\n## Capabilities\n\n- dbt-core 1.11+ with Fusion engine (faster parallel execution)\n- Project structure: staging (stg_), intermediate (int_), marts (fct_, dim_)\n- Materializations (view, ephemeral, table, incremental)\n- Schema tests (unique, not_null, relationships, accepted_values)\n- Jinja macros for DRY SQL patterns\n- Sources, seeds, snapshots, documentation\n\n## Skills\n\nApply **dbt-best-practices** for core dbt guidelines.\n\n## Reference Guides\n\nConsult `guides/dbt/` for dbt Labs official patterns.",
  "cost": {
    "context_tokens": 150
  }
}

Fetch it by URL: GET /api/v1/registry/baekenough-second-brain-de-dbt-expert-subagent/manifest?version=1.0.0