Lightlines
By reason-machines

harvard-artifacts-data-pipeline

reason-machines1.8k installs

Turn museum collection data into interactive analytics.

What it does

Builds a museum-data ETL pipeline with relational storage, SQL analytics, and an interactive dashboard.

When to use it

Use when building an ETL pipeline, querying Harvard museum collection data, or creating a dashboard for artifact analytics.

How to use it

Give it a museum-data pipeline request; it builds an ETL project with SQL analytics and a Streamlit dashboard.

Uses

Good to know

  • cannot be undone: MySQL

Latest review

What you need · 10

Requires streamlit for the interactive dashboard.

Requires pandas for DataFrames and SQL query results.


Access · 4

This skill

MySQL

Write

Inserts and updates database records (irreversible)

Harvard Art Museums API

Read

Fetches museum artifact records