Harvard Artifacts ETL Analytics Skill

Skill by ara.so — Data Skills collection.

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

What This Project Does

The Harvard Artifacts Collection application:

• Extracts artifact data from the Harvard Art Museums API with pagination support
• Transforms nested JSON into normalized relational tables
• Loads data into MySQL/TiDB Cloud databases with batch inserts
• Executes analytical SQL queries on artifact metadata, media, and color data
• Visualizes results through interactive Plotly charts in a Streamlit interface

Architecture: API → ETL → SQL → Analytics → Visualization

Installation