SKILL.md
Harvard Art Museums ETL Analytics
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 real-world ETL pipelines, SQL analytics, and interactive data visualization using Streamlit.
What This Project Does
The Harvard-Artifacts-Collection-Data-Engineering-Analytics-App provides:
- API Integration: Collect artifact data from Harvard Art Museums API with pagination and rate limiting
- ETL Pipeline: Extract, transform, and load artifact metadata, media details, and color data
- SQL Storage: Store structured data in MySQL/TiDB Cloud with proper relational schema
- Analytics Engine: Execute 20+ predefined analytical SQL queries
- Interactive Dashboards: Visualize query results using Streamlit and Plotly
The architecture follows: API → ETL → SQL → Analytics → Visualization
Installation
Harvard Art Museums ETL Analytics
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 real-world ETL pipelines, SQL analytics, and interactive data visualization using Streamlit.
What This Project Does
The Harvard-Artifacts-Collection-Data-Engineering-Analytics-App provides:
- API Integration: Collect artifact data from Harvard Art Museums API with pagination and rate limiting
- ETL Pipeline: Extract, transform, and load artifact metadata, media details, and color data
- SQL Storage: Store structured data in MySQL/TiDB Cloud with proper relational schema
- Analytics Engine: Execute 20+ predefined analytical SQL queries
- Interactive Dashboards: Visualize query results using Streamlit and Plotly
The architecture follows: API → ETL → SQL → Analytics → Visualization