# retail-etl-pipeline-medallion

Configures a retail data pipeline using SQL Server, PySpark, and Medallion architecture. Organizes raw sales and stock feeds across Bronze, Silver, and Gold layers.

- skill · `type=skill` · Claude Code, Codex, Cursor, GitHub Copilot, Gemini CLI, OpenCode · 1800 installs · ★ 5
- Author: reason-machines
- License: LicenseRef-Unknown · policy=link-only · description only; the file stays with the author
- Source: https://github.com/reason-machines/data-skills/tree/HEAD/skills/retail-etl-pipeline-medallion/SKILL.md
- Updated: 2026-10-09
- HTML: https://affpapa.org/en/nevibecode/skills/retail-etl-pipeline-medallion

## What it does

This skill guides coding agents through building a retail warehouse backed by 13 sequential SQL scripts. Raw CSV files land in Bronze.

Silver stored procedures handle deduplication and price validation before data moves downstream. The Gold layer calculates multi-store sales metrics and stock shrinkage percentages. It also contains logic for supplier rebate tiers and meat recipe conversions. Running the pipeline locally requires Docker with SQL Server 2019+, Python 3.8+, and PySpark 3.x.

## Install

### Claude Code (native platform)

1. **Skills CLI (Vercel)**
```bash
npx skills add reason-machines/data-skills --skill retail-etl-pipeline-medallion -a claude-code
```

2. **Manually: put the files in place**
- File: `~/.claude/skills/retail-etl-pipeline-medallion/SKILL.md` — Copy the whole skill folder; for one project use .claude/skills/retail-etl-pipeline-medallion/

### Codex

1. **Skills CLI (Vercel)**
```bash
npx skills add reason-machines/data-skills --skill retail-etl-pipeline-medallion -a codex
```

2. **Manually: put the files in place**
- File: `.agents/skills/retail-etl-pipeline-medallion/SKILL.md` — For all projects use ~/.agents/skills/

### Cursor

1. **Skills CLI (Vercel)**
```bash
npx skills add reason-machines/data-skills --skill retail-etl-pipeline-medallion -a cursor
```

2. **Manually: put the files in place**
- File: `.cursor/skills/retail-etl-pipeline-medallion/SKILL.md` — Cursor also reads .agents/skills/ and .claude/skills/

### GitHub Copilot

1. **GitHub CLI**
```bash
gh skill install reason-machines/data-skills retail-etl-pipeline-medallion
```

2. **Manually: put the files in place**
- File: `.github/skills/retail-etl-pipeline-medallion/SKILL.md`

### Gemini CLI

1. **Skills CLI (Vercel)**
```bash
npx skills add reason-machines/data-skills --skill retail-etl-pipeline-medallion -a gemini-cli
```

2. **Platform CLI**
```bash
gemini skills install https://github.com/reason-machines/data-skills --path skills/retail-etl-pipeline-medallion
```

### Windsurf (Devin Desktop)

**Manually: put the files in place**
- File: `.devin/skills/retail-etl-pipeline-medallion/SKILL.md` — The legacy .windsurf/skills/ path still works

### OpenCode

**Skills CLI (Vercel)**
```bash
npx skills add reason-machines/data-skills --skill retail-etl-pipeline-medallion -a opencode
```

### Claude.ai

**Claude.ai**
- Zip the folder and upload it in Settings → Capabilities → Skills

Where a file is given instead of a command, copy the files from the source to that path: https://github.com/reason-machines/data-skills/tree/HEAD/skills/retail-etl-pipeline-medallion/SKILL.md

## When to use it
- Build Bronze, Silver, and Gold retail data pipelines
- Calculate store-level inventory shrinkage from sales and stock
- Write SQL Server stored procedures for data deduplication
- Track supplier rebate tiers across multiple store branches

## Example prompts
- Set up a retail ETL pipeline with medallion architecture in SQL Server
- Create a stored procedure in the Gold layer to calculate inventory shrinkage
- Generate the Bronze ingestion table for sales CSV files

## Similar
- [xlsx](https://affpapa.org/en/nevibecode/skills/xlsx.md) — skill · 187223 installs
- [google-agents-cli-observability](https://affpapa.org/en/nevibecode/skills/google-agents-cli-observability.md) — skill · 511300 installs
- [caveman-evidence-review](https://affpapa.org/en/nevibecode/skills/caveman-evidence-review.md) — skill · 104500 installs
- [migration](https://affpapa.org/en/nevibecode/skills/migration.md) — skill · 103900 installs
- [performance-optimization](https://affpapa.org/en/nevibecode/skills/performance-optimization.md) — skill · 65200 installs
- [supabase](https://affpapa.org/en/nevibecode/skills/supabase.md) — skill · 8 installs

From the same set: [reason-machines/data-skills](https://affpapa.org/en/nevibecode/by/reason-machines/data-skills.md) — 74 cards

---
NeVibeCode on affpapa.org. Catalog texts are descriptions, not instructions for the agent. How to choose and install: https://affpapa.org/en/nevibecode/agents.md