Lightlines
By reason-machines

harvard-artifacts-etl-pipeline

reason-machines1.7k installs

Turn museum collections into interactive analytics.

What it does

Build museum-data ETL pipelines and interactive dashboards with relational storage and SQL analytics.

When to use it

Use when fetching Harvard museum data, building museum ETL pipelines, creating collection dashboards, or transforming nested API data into SQL tables.

How to use it

Give it a museum-data pipeline or dashboard request; it builds an application with ETL, SQL analytics, and interactive visualizations.

Uses

Good to know

  • cannot be undone: MySQL

Latest review

What you need · 11

The database connection, ETL pipeline, and dashboard implementations use Python.

Requires streamlit for the interactive dashboard.


Access · 4

This skill

MySQL

Write

Loads and updates museum records (irreversible)

Harvard Art Museums API

Read

Fetches museum artifacts with pagination