Harvard Art Museums Data Engineering App

This is a complete reference implementation for building an ETL pipeline around the Harvard Art Museums API. It walks you through fetching paginated artifact data, normalizing nested JSON into three related MySQL tables (metadata, media, colors), and surfacing the results through a Streamlit dashboard with Plotly visualizations. The code includes proper rate limiting, batch inserts, and 20+ analytical SQL queries. Use this if you're learning data engineering fundamentals or need a template for similar museum/cultural API integrations. The schema design is clean and the transformation logic handles real world messiness in the JSON responses, making it a solid starting point for adaptation.

Install to Claude Code

npx -y skills add aradotso/data-skills --skill harvard-art-museums-data-engineering-app --agent claude-code