Harvard Artifacts Data Pipeline

This is a complete reference implementation for building ETL pipelines against the Harvard Art Museums API. You get working code for pagination and rate limiting, transformation logic that normalizes nested JSON into a three-table relational schema (metadata, media, colors), and MySQL insert patterns with proper foreign keys. The included Streamlit dashboard has 20+ prebuilt analytical queries and Plotly visualizations. Use this when you need to see how a full data engineering workflow fits together, from API extraction through SQL analytics. The schema design is sensible and the transformation functions are clean enough to adapt to similar museum or collection APIs. It's educational first, but the patterns are production-adjacent.

Install to Claude Code

npx -y skills add aradotso/data-skills --skill harvard-artifacts-data-pipeline --agent claude-code