Skip to main content
affpapa.org
RU EN
skill CX Codex

retail-etl-pipeline-medallion — Claude Code skill: setup & use

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

Install into Claude Code · Skills CLI (Vercel) All methods and platforms ↓ 
npx skills add reason-machines/data-skills --skill retail-etl-pipeline-medallion -a claude-code
Open on GitHub

What retail-etl-pipeline-medallion 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.

What it helps with

  • 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 for the agent

  • 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

How to install retail-etl-pipeline-medallion

1Skills CLI (Vercel)

npx skills add reason-machines/data-skills --skill retail-etl-pipeline-medallion -a claude-code

2Manually: put the files in place

~/.claude/skills/retail-etl-pipeline-medallion/SKILL.md

Copy the whole skill folder; for one project use .claude/skills/retail-etl-pipeline-medallion/

Step by step, with commands for each platform: How to install skills in Claude Code: five ways

Questions about retail-etl-pipeline-medallion

How do I install retail-etl-pipeline-medallion in Claude Code?

Run npx skills add reason-machines/data-skills --skill retail-etl-pipeline-medallion -a claude-code in your terminal.

What does retail-etl-pipeline-medallion do?

It provides structured patterns and SQL procedures to build a three-layer retail data warehouse. The pipeline handles data cleansing, sales consolidation, and inventory shrinkage tracking.

What are the prerequisites to run this pipeline?

You need Docker, SQL Server 2019+, Python 3.8+, and PySpark 3.x. Apache Airflow can also be used if workflow orchestration is required.

Similar skills

All skills for Data and databases →
xlsx official anthropics Creates, reads, edits, and converts spreadsheet files. Use it when the requested deliverable is an Excel workbook or another tabular file. 187,223installs google-agents-cli-observability official Google This skill guides you through tracing and monitoring AI agents, including ADK agents. Use it when you need to inspect agent execution or monitor a deployed agent. CX Codex +1 511,300installs caveman-evidence-review JuliusBrussee A read-only skill reviews Caveman Cloud evidence on LLM spend, traces, and routing. Use it to see where a project’s model budget goes. CX Codex +1 104,500installs migration JuliusBrussee Enforces reversible, compatibility-safe transitions for schema, data, and API updates. Useful whenever data loss or rollout downtime is unacceptable. CX Codex +1 103,900installs performance-optimization addyosmani An agent skill that measures before it changes code: Core Web Vitals budgets, N+1 queries, missing indexes and slow endpoints. CX Codex +1 65,200installs supabase official supabase Guides the agent through database configuration and strict RLS policies in Supabase. CX Codex GP ChatGPT 8installs

From the same set74

harvard-artifacts-collection-data-engineering-analytics Sets up an end-to-end data pipeline fetching Harvard Art Museums records, loading them into MySQL, and visualising trends in Streamlit. CX Codex +1 1,900installs harvard-artifacts-collection-etl-analytics A skill for building an ETL pipeline and analytics dashboard on Harvard Art Museums API data with Python, SQL and Streamlit. CX Codex +1 1,900installs harvard-artifacts-collection-analytics-pipeline A skill that walks your agent through a full Harvard Art Museums API pipeline: ETL, SQL storage and a Streamlit dashboard. CX Codex +1 1,900installs harvard-art-museums-data-engineering-pipeline A skill for building an ETL pipeline on Harvard Art Museums API data: JSON into normalized SQL tables, analytical queries, and a Streamlit dashboard. CX Codex +1 1,800installs retail-etl-medallion-pipeline This skill helps build a retail ETL pipeline with Bronze, Silver, and Gold layers. Use it for sales, inventory, and supplier data flows. CX Codex +1 1,800installs iac-terraform-data-engineering A skill for Claude and other AI agents that helps describe AWS data infrastructure in Terraform: S3 buckets, EC2 instances, IAM roles. CX Codex +1 1,800installs terraform-data-engineering-iac Provisions AWS infrastructure for data engineering workloads with Terraform. Generates configurations for S3 data lakes, EC2 processing nodes, and IAM roles. CX Codex +1 1,800installs harvard-artifacts-data-pipeline A skill that walks your agent from Harvard Art Museums API extraction to a Streamlit dashboard backed by SQL analytics. CX Codex +1 1,800installs

Project sponsors

Companies that keep this analytics open
Gold sponsor
Nutra.Club

Impressions, clicks and code copies — open statistics. We keep the numbers public for the same reason NeBlask itself is public. Become a sponsor