skills.rest
Aradotso
AradotsoOFFICIAL
Explore all skills by this author →
Website𝕏@aradotsoGitHub

harvard-art-museum-data-engineering

Automate ETL from the Harvard Art Museums API into SQL databases with Streamlit dashboards.

5|1|Updated May 16, 2026
Search Tags:#ETL#Streamlit#data engineering#data analytics#Harvard Art Museums
One-click install
npx skills add https://github.com/Aradotso/data-skills --skill harvard-art-museum-data-engineering
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: harvard-art-museum-data-engineering
Source: https://github.com/Aradotso/data-skills/tree/main/skills/harvard-art-museum-data-engineering
Command: npx skills add https://github.com/Aradotso/data-skills --skill harvard-art-museum-data-engineering

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires streamlit, pandas, requests, mysql-connector-python, plotly, python-dotenv, and includes scripts (resource) and references (resource) and assets (resource) components.

What problem does it solve?

This Skill automates the Extract, Transform, Load (ETL) process and provides analytics for the Harvard Art Museums API, streamlining data engineering tasks.

Core Features & Use Cases

  • ETL Pipeline: Extracts artifact data from the API, transforms it into relational tables, and loads it into SQL databases.
  • Analytics Dashboard: Offers interactive analytics dashboards using Streamlit for data visualization.
  • Use Case: Ideal for data engineers and analysts looking to automate the processing of museum collection data and create insightful visualizations.

Quick Start

Use the harvard-art-museum-data-engineering skill to load and analyze the museum artifact data from the Harvard Art Museums API.

Frequently Asked Questions about harvard-art-museum-data-engineering

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I automate the ETL pipeline for Harvard Art Museums API data?▼

The skill uses Python, pandas, and requests to extract data from the Harvard Art Museums API, transform it into relational tables, and load it into a MySQL database using mysql-connector-python.

How do I build a Streamlit analytics dashboard for museum collection data?▼

To build a Streamlit dashboard for museum collection data, the skill uses Streamlit and Plotly to render interactive analytics visualizations from SQL database records loaded via pandas.

What do I need to set up to connect to the Harvard Art Museums API and MySQL database?▼

You need Python with the requests and mysql-connector-python libraries installed, plus a python-dotenv file to manage your Harvard Art Museums API key and MySQL database credentials securely.

How does the ETL process transform API records into relational tables?▼

The ETL process uses pandas to flatten nested JSON responses from the Harvard Art Museums API into structured DataFrames, which are then mapped and loaded into SQL database schemas.

What is the best way to visualize Harvard Art Museums artifact data in Python?▼

The best way to visualize Harvard Art Museums artifact data in Python is by using Streamlit and Plotly to create interactive dashboards that read transformed data directly from SQL databases.

Related Skills

Explore More Data & Analytics Skills→
AradotsoAradotso
5

harvard-artifacts-collection-data-engineering

Automate ETL processes for Harvard Art Museums API data into MySQL.

Official
Advanced
AradotsoAradotso
5

harvard-artifacts-collection-analytics-etl

Extract, transform, and load Harvard Art Museums API data into a SQL database.

Official
Advanced
nesihaver-ILnesihaver-IL

analytics-metrics

Build interactive analytics dashboards and charts in React with Recharts.

Community
Intermediate
AradotsoAradotso
5

harvard-artifacts-etl-streamlit-app

Automates ETL pipelines and Streamlit dashboards for Harvard Art Museums collection data.

Official
Advanced