This skill enables AI agents to build and work with end-to-end data engineering pipelines using the Harvard Art Museums API. It demonstrates ETL workflows, SQL database design, analytics queries, and interactive Streamlit dashboards with Plotly visualizations.
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 museum artifact data into relational SQL databases
SQL Database
Store artifacts metadata, media details, and color information with proper relationships
Analytics Queries
20+ predefined SQL queries for insights on culture, century, media, colors, and departments
Interactive Dashboard
Streamlit-based UI with Plotly visualizations for real-time analytics
Installation
Show more
Installs
692
Repository
aradotso/data-skills
GitHub Stars
2
First Seen
Jun 7, 2026
Security Audits
Gen Agent Trust Hub
Pass
Socket
Warn
Snyk
Warn