Harvard Artifacts Etl Analytics

This is a practical teaching project that walks you through building a complete data pipeline from the Harvard Art Museums API. You're extracting artifact metadata with pagination, normalizing nested JSON into three relational tables (metadata, media, colors), loading it into MySQL, and visualizing 20+ predefined queries in a Streamlit dashboard. It's solid for learning ETL fundamentals with a real API, though the analytical queries are prebuilt rather than dynamic. The code patterns are clear and the museum data is interesting to work with. Good starter project if you're moving from scripts to structured data engineering workflows, less useful if you need production-grade error handling or streaming updates.

Install to Claude Code

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