This skill enables you to build end-to-end data engineering pipelines using the Harvard Art Museums API. Extract artifact metadata, transform nested JSON into relational tables, load into SQL databases, and create interactive analytics dashboards with Streamlit.
What It 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
Transform nested JSON into normalized relational tables
SQL Storage
Store artifacts, media, and color data in MySQL/TiDB Cloud
Analytics Queries
20+ predefined SQL queries for insights
Interactive Visualization
Streamlit dashboards with Plotly charts
Architecture Flow
:
API → ETL → SQL → Analytics → Visualization
Installation
Show more
Installs
563
Repository
aradotso/data-skills
GitHub Stars
1
First Seen
May 23, 2026
Security Audits
Gen Agent Trust Hub
Warn
Socket
Pass
Snyk
Pass