Create a new dbt Silver model with SQL + YAML contract. Use when adding a new Silver layer model from a raw source table.
The English summary is being prepared. Showing the original description.
See how to installReview the instructions the agent will receive before you install.
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>
No reviews yet. Tell others what you thought.
No login needed. Share how it worked for you, ask a question, or note where it did not run.
No comments yet. Be the first to write one.
Add a tool function to the Medox agent. Use when creating a tool file, registering it in the API loop, and writing its test.
The English summary is being prepared. Showing the original description.
Add a new E2E test case to tests/e2e/prompts.yaml for LangSmith evaluation. Use when adding interaction pairs to test, covering new ANSM drug classes, or rebalancing eval coverage.
The English summary is being prepared. Showing the original description.
Create a git commit with Medox conventions (co-author, conventional type/scope). Invoke manually with /commit — do NOT trigger automatically.
The English summary is being prepared. Showing the original description.
Audit code changes on the current branch and update docs/ + .claude/rules/ to stay in sync. Run before /pr.
The English summary is being prepared. Showing the original description.
Run all project linters (ruff, mypy, sqlfluff) and report results. Invoke with /lint.
The English summary is being prepared. Showing the original description.
Add a new Dagster asset to the pipeline. Use when creating a Bronze, Silver, or Gold layer asset.
The English summary is being prepared. Showing the original description.