Menu
Create a new dbt Silver model with SQL + YAML contract. Use when adding a new Silver layer model from a raw source table.
Install with Codex or Claude Copy this prompt, paste it into Codex, Claude, or another assistant, and let it review the skill page and install it for you.
Based on SOC occupation classification
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>