Menü
Create a new dbt Silver model with SQL + YAML contract. Use when adding a new Silver layer model from a raw source table.
Mit Codex oder Claude installieren Kopieren Sie diesen Prompt, fügen Sie ihn in Codex, Claude oder einen anderen Assistant ein und lassen Sie die Skill-Seite prüfen und installieren.
Basierend auf der SOC-Berufsklassifikation
Run the LangSmith evaluation suite and display pass/fail results
Add a new LangChain tool to the Medox ReAct agent. Use when creating a new tool file, registering it in the graph, and writing its test.
Create a git commit with Medox conventions (co-author, conventional type/scope). Invoke manually with /commit — do NOT trigger automatically.
Audit code changes on the current branch and update docs/ + .claude/rules/ to stay in sync. Run before /pr.
Create or update a GitHub pull request following Medox conventions (author spicode-bot, reviewer spideystreet). Invoke manually with /pr — do NOT trigger automatically.
Fetch and display the full status of the current PR — CI checks, GitHub Actions runs, reviews, and code comments — using GitHub MCP tools. Invoke manually with /pr-status.
| name | new-silver-model |
| description | Create a new dbt Silver model with SQL + YAML contract. Use when adding a new Silver layer model from a raw source table. |
| disable-model-invocation | true |
| argument-hint | <source>__<entity> |
Identify the raw source table — check dbt/models/sources.yml; add it if missing.
Create the SQL model at dbt/models/silver/<layer>_<source>__<entity>.sql:
{{ config(materialized='table') }}
SELECT
{{ clean_text('col') }} AS col,
{{ parse_bdpm_date('date_col') }} AS date_col
FROM {{ source('raw', 'table_name') }}
WHERE {{ is_valid_cis('cis') }}
Create the contract at dbt/models/silver/<layer>_<source>__<entity>.yml:
version: 2
models:
- name: <layer>_<source>__<entity>
description: "..."
columns:
- name: <pk>
data_tests: [unique, not_null]
Add a new macro in dbt/macros/ if any transformation is reused across models.
Validate locally:
uv run dotenv -f dbt/.env run -- uv run dbt run --project-dir dbt --profiles-dir dbt --select <model_name>
uv run dotenv -f dbt/.env run -- uv run dbt test --project-dir dbt --profiles-dir dbt --select <model_name>