Harvard Artifacts Data Engineering Pipeline

This is a full ETL tutorial that walks you through pulling artifact data from Harvard Art Museums API, normalizing it into MySQL tables, and building a Streamlit dashboard with Plotly charts. You get the complete pipeline: API pagination with rate limiting, transforming nested JSON into three relational tables (metadata, media, colors), and 20+ predefined SQL analytics queries. The code is production-oriented with proper error handling and environment variable management. If you're learning data engineering or need a reference implementation for API-to-database workflows, this covers the fundamentals end to end. The Streamlit frontend is basic but functional for exploring the collection data you've loaded.

Install to Claude Code

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