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

retail-etl-medallion-pipeline — Claude Code skill

This skill helps build a retail ETL pipeline with Bronze, Silver, and Gold layers. Use it for sales, inventory, and supplier data flows.

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

What retail-etl-medallion-pipeline does

The skill lays out an end-to-end retail data pipeline. Bronze lands CSV records with little change, Silver cleans and standardizes them, and Gold produces analytics-ready aggregates and models. The workflow covers branch sales, product recipes and yields, stock tracking, and supplier rebate calculations.

The project includes TSQL scripts for the bronze, silver, gold, and staging schemas, a Retail-Data-Warehouse layout, SQL Server container setup, and source CSV files. The description also names PySpark and Airflow as parts of the ETL stack.

You need SQL Server 2017+ or the container defined in docker-compose.yml; database setup uses $SQL_SA_PASSWORD, and the CSV files must be placed where the database can access them.

What it helps with

  • build a retail ETL flow across Bronze, Silver, and Gold
  • load sales, product, and stock CSV files
  • clean and standardize records before analysis
  • calculate inventory turnover and shrinkage metrics
  • prepare aggregated data for BI dashboards

Example prompts for the agent

  • Build a retail warehouse with Bronze, Silver, and Gold data layers.
  • Set up SQL Server ingestion for sales, product, and stock CSV files.
  • Organize the ETL scripts and produce Gold-level retail analytics tables.

How to install retail-etl-medallion-pipeline

1Skills CLI (Vercel)

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

2Manually: put the files in place

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

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

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

Questions about retail-etl-medallion-pipeline

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

Run npx skills add reason-machines/data-skills --skill retail-etl-medallion-pipeline -a claude-code. The skill file will be at ~/.claude/skills/retail-etl-medallion-pipeline/SKILL.md.

What does retail-etl-medallion-pipeline do?

It guides a retail ETL design that lands raw CSV data in Bronze, applies cleaning and business rules in Silver, and prepares analytics data in Gold.

What must be ready before using the pipeline?

Use SQL Server 2017+ or the Docker setup from docker-compose.yml. Database initialization needs $SQL_SA_PASSWORD, and SQL Server must be able to read the CSV files.

Similar skills

All skills for Data and databases →
ETL Pipeline Claude Office Skills A skill for designing and automating ETL pipelines: pull from databases and APIs, transform, load into warehouses. Useful when you need a recurring data flow. CX Codex +1 4,800installs pyspark-etl-best-practices-cursorrules-prompt-file PatrickJS A Cursor rule that sets PySpark code style: F.col(), explicit joins, select over withColumn, and Iceberg-aware ETL structure. ★ 41,024repo stars retail-expert personamanagmentlayer This skill gives an agent retail-system context for POS, inventory, e-commerce, CRM, and omnichannel work. Use it for design and analysis tasks. CX Codex +1 526installs spark-engineer https://github.com/Jeffallan Writes PySpark jobs and digs into why they crawl: DataFrame transforms, Spark SQL, skewed keys, streaming. Useful when a job burns itself on shuffle or runs out of memory. CX Codex +1 3,800installs airflow-dag-patterns Seth Hobson This skill helps design Apache Airflow DAGs, connect tasks, and test pipelines. Use it for ETL workflows, batch jobs, and failed-run debugging. CX Codex 11,000installs etl-connector-strategy Samuel Berthe Walks a SaaS vendor through whether, where and how to appear as a source in customers' ETL/ELT pipelines, and what that costs to maintain. CX Codex +1 8,000installs

From the same set74

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-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. 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 iac-data-engineering-terraform A skill with ready Terraform patterns for data engineering: S3 buckets, EC2 instances and IAM roles. Useful when you need to stand up pipeline infrastructure declaratively. 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