Harvard Art Museum Data Pipeline Skill

Skill by ara.so — Data Skills collection.

This skill enables AI coding agents to help developers build end-to-end data engineering and analytics applications using the Harvard Art Museums API. The project demonstrates ETL pipelines, SQL database design, analytics queries, and interactive Streamlit dashboards for museum artifact data.

What This Project Does

The Harvard Artifacts Collection Data Engineering Analytics App provides:

• API Integration: Fetch artifact data from Harvard Art Museums API with pagination and rate limiting
• ETL Pipeline: Extract, transform, and load nested JSON into relational database tables
• SQL Analytics: 20+ predefined analytical queries for artifact insights
• Interactive Dashboard: Streamlit-based visualization with Plotly charts
• Database Design: Normalized schema with artifact metadata, media, and color tables

Installation