Harvard Art Museums Etl Pipeline

This is a practical reference for building a complete ETL pipeline against the Harvard Art Museums API. You get working code for paginated extraction, JSON normalization into three relational tables (metadata, media, colors), and a Streamlit dashboard with Plotly visualizations. The schema design is sensible with proper foreign keys, and the transformation logic handles nested API responses cleanly. Good if you're learning data engineering patterns with real cultural data or need a template for similar API-to-database projects. The code shows batch inserts and upsert logic, though you'll need your own Harvard API key and MySQL instance to run it.

Install to Claude Code

npx -y skills add aradotso/data-skills --skill harvard-art-museums-etl-pipeline --agent claude-code