This skill enables AI agents to help developers build end-to-end data engineering and analytics applications using the Harvard Art Museums API. The project demonstrates real-world ETL pipelines, SQL database design, analytical queries, and interactive Streamlit dashboards for artifact collection data.
What This Project Does
The Harvard Artifacts Collection Data Engineering & Analytics App provides:
API Integration
Fetches artifact data from Harvard Art Museums API with pagination and rate limiting
ETL Pipeline
Extracts, transforms, and loads artifact metadata, media, and color data into relational SQL tables
SQL Analytics
Pre-built analytical queries for insights on artifacts by culture, century, department, and media
Interactive Dashboards
Streamlit-based visualization using Plotly for real-time analytics
Database Design
Normalized schema with proper foreign key relationships across artifact metadata, media, and color tables
Installation
Prerequisites
Show more
Installs
593
Repository
aradotso/data-skills
GitHub Stars
1
First Seen
May 28, 2026
Security Audits
Gen Agent Trust Hub
Fail
Socket
Warn
Snyk
Warn