Skip to main content
skill CX Codex

harvard-artifacts-collection-data-engineering-analytics skill

Sets up an end-to-end data pipeline fetching Harvard Art Museums records, loading them into MySQL, and visualising trends in Streamlit.

Install into Claude Code · Skills CLI (Vercel) All methods and platforms ↓
npx skills add reason-machines/data-skills --skill harvard-artifacts-collection-data-engineering-analytics -a claude-code
Open on GitHub

What harvard-artifacts-collection-data-engineering-analytics does

This skill guides the agent through an entire pipeline for museum artifact analytics. It extracts records from the Harvard Art Museums API, handling request pacing and multi-page responses. The transformation step unpacks nested JSON into relational tables covering object metadata, images, and color hex percentages.

Data lands in MySQL or TiDB Cloud across foreign-keyed tables. On top of the database, the project supplies over 20 SQL queries along with interactive charts built via Streamlit and Plotly.

The pipeline fails immediately if HARVARD_API_KEY or the database credentials in .env are omitted.

What it helps with

  • extract museum artifacts from the Harvard API with rate limiting
  • transform nested JSON into relational schemas for metadata, images, and colors
  • launch a Streamlit dashboard with Plotly charts on top of MySQL or TiDB Cloud
  • run analytical SQL queries across art collection datasets

Example prompts for the agent

  • Set up an ETL pipeline to load Harvard Art Museums records into MySQL.
  • Create a Streamlit dashboard with Plotly charts for museum collection data.
  • Generate SQL schema and queries to analyze Harvard artifact colors and metadata.

How to install harvard-artifacts-collection-data-engineering-analytics

1Skills CLI (Vercel)

npx skills add reason-machines/data-skills --skill harvard-artifacts-collection-data-engineering-analytics -a claude-code

2Manually: put the files in place

~/.claude/skills/harvard-artifacts-collection-data-engineering-analytics/SKILL.md

Copy the whole skill folder; for one project use .claude/skills/harvard-artifacts-collection-data-engineering-analytics/

Step by step, with commands for each platform: How to install skills in Claude Code: five ways

Questions about harvard-artifacts-collection-data-engineering-analytics

How to install harvard-artifacts-collection-data-engineering-analytics in Claude Code?

Run npx skills add reason-machines/data-skills --skill harvard-artifacts-collection-data-engineering-analytics -a claude-code. You can also configure it directly in ~/.claude/skills/harvard-artifacts-collection-data-engineering-analytics/SKILL.md.

What does this skill do?

It builds an automated workflow that fetches Harvard Art Museums data, writes structured tables to MySQL or TiDB Cloud, and presents analytics in Streamlit.

Which Python libraries are required?

The pipeline relies on streamlit, pandas, requests, mysql-connector-python, plotly, and python-dotenv.

Similar skills

All skills for Data and databases →

From the same set74

data-engineering-medallion-pipeline This skill helps agents build ELT pipelines with MinIO, Airbyte, PostgreSQL, DBT, and Airflow. Use it for Bronze, Silver, and Gold data layers. CX Codex +1 2,000installs options-analytics-agent-langgraph Builds a LangGraph agent that pulls options data from Polygon.io, caches it in ChromaDB and keeps memory across sessions. Useful when you want your own trading assistant. CX Codex +1 2,000installs harvard-artifacts-collection-data-engineering This skill pulls Harvard Art Museums data into MySQL and renders it in Streamlit. Useful when you want a working ETL example from API to dashboard. CX Codex +1 1,900installs harvard-artifacts-etl-streamlit-analytics Walks your agent through building an ETL pipeline and an analytics dashboard on Harvard Art Museums API data with Python, SQL and Streamlit. CX Codex +1 1,900installs harvard-artifacts-collection-etl-analytics A skill for building an ETL pipeline and analytics dashboard on Harvard Art Museums API data with Python, SQL and Streamlit. CX Codex +1 1,900installs harvard-artifacts-collection-analytics-pipeline A skill that walks your agent through a full Harvard Art Museums API pipeline: ETL, SQL storage and a Streamlit dashboard. CX Codex +1 1,900installs harvard-art-museums-data-engineering-pipeline A skill for building an ETL pipeline on Harvard Art Museums API data: JSON into normalized SQL tables, analytical queries, and a Streamlit dashboard. CX Codex +1 1,800installs retail-etl-pipeline-medallion Configures a retail data pipeline using SQL Server, PySpark, and Medallion architecture. Organizes raw sales and stock feeds across Bronze, Silver, and Gold layers. CX Codex +1 1,800installs

Project sponsors

Companies that keep this analytics open
Gold sponsor

Impressions, clicks and code copies — open statistics. We keep the numbers public for the same reason NeBlask itself is public. Become a sponsor