This skill enables AI agents to help developers build end-to-end data engineering and analytics applications using the Harvard Art Museums API. It covers ETL pipeline design, SQL database schema creation, batch data processing, analytical query implementation, and interactive visualization with Streamlit.
What This Project Does
The Harvard Artifacts Collection app demonstrates a complete data engineering workflow:
Extract
Fetch artifact data from Harvard Art Museums API with pagination
Transform
Parse nested JSON into relational structures (metadata, media, colors)
Load
Batch insert into MySQL/TiDB Cloud with proper schema design
Analyze
Execute 20+ predefined analytical SQL queries
Visualize
Display results through interactive Plotly charts in Streamlit
Installation
Show more
Installs
545
Repository
aradotso/data-skills
GitHub Stars
1
First Seen
May 23, 2026
Security Audits
Gen Agent Trust Hub
Pass
Socket
Warn
Snyk
Warn