harvard-artifacts-collection-etl-analytics - Build ETL analytics for Harvard Art Museums data
Build Python ETL pipelines, SQL databases, analytical queries, and Streamlit visualizations for Harvard Art Museums API data.
Tags
Updated: 2026-09-28Capabilities
Typical Inputs
Typical Outputs
What this skill does
- Fetch paginated artifact data
- Transform nested JSON data
- Create relational database tables
- Load data into SQL
- Execute analytical SQL queries
- Generate Streamlit visualizations
Inputs
- Harvard API key
- Database connection credentials
- Harvard Art Museums API data
- Artifact collection query parameters
Outputs
- Artifact metadata tables
- Artifact media tables
- Artifact color tables
- Analytical query results
- Interactive Streamlit dashboards
- Plotly visualizations
Requirements
- Python environment
- Python package dependencies
- Harvard Art Museums API access
- MySQL or TiDB database
- Streamlit and Plotly support