Harvard Artifacts Data Engineering App

This is a complete ETL pipeline that pulls artifact data from the Harvard Art Museums API and builds a proper relational database with MySQL or TiDB. It handles the full transformation from nested JSON to normalized tables (metadata, media, colors), then layers on a Streamlit dashboard with 20+ analytical queries and Plotly visualizations. Good for learning data engineering fundamentals with real cultural data, or if you're prototyping museum analytics. The code is straightforward, handles pagination and rate limits, and includes all the SQL setup. It's more educational than production-ready, but that's the point. You get hands-on practice with API integration, database normalization, and building dashboards without wrestling with authentication complexities or messy data cleaning.

Install to Claude Code

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