Skip to main content
affpapa.org
RU EN
skill CX Codex

harvard-art-museum-etl-analytics — Claude Code skill

Sets up an ETL workflow for the Harvard Art Museums API, organizes museum items into MySQL tables, and renders Streamlit visualizations.

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

What harvard-art-museum-etl-analytics does

This skill guides a coding assistant through reading catalog entries from the Harvard Art Museums API and structuring raw JSON into relational storage. The schema defines tables for core artifact records, associated media links, and color metrics connected by foreign keys.

The extraction script handles rate limiting with sleep intervals and traverses paginated API responses. Downstream steps load normalized records into MySQL or TiDB Cloud, preparing SQL queries by century, medium, and department alongside Plotly charts inside Streamlit.

Execution breaks without a valid HARVARD_API_KEY from the museum portal and an active MySQL-compatible endpoint. Your environment also requires Python 3.8+ together with the mysql-connector-python package.

What it helps with

  • extract museum artifacts from the Harvard API with rate-limited pagination
  • define relational MySQL schemas for metadata and color attributes
  • assemble a Streamlit dashboard with Plotly charts for collection analytics
  • write SQL queries to inspect artifacts across cultures and time periods

Example prompts for the agent

  • Set up an ETL pipeline to pull artifact records from the Harvard Art Museums API into MySQL
  • Generate a Streamlit dashboard displaying color distributions and centuries of museum items
  • Write the database migration script to store Harvard collection metadata and image links

How to install harvard-art-museum-etl-analytics

1Skills CLI (Vercel)

npx skills add reason-machines/data-skills --skill harvard-art-museum-etl-analytics -a claude-code

2Manually: put the files in place

~/.claude/skills/harvard-art-museum-etl-analytics/SKILL.md

Copy the whole skill folder; for one project use .claude/skills/harvard-art-museum-etl-analytics/

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

Questions about harvard-art-museum-etl-analytics

How do I install harvard-art-museum-etl-analytics in Claude Code?

Run npx skills add reason-machines/data-skills --skill harvard-art-museum-etl-analytics -a claude-code in your terminal.

What does harvard-art-museum-etl-analytics do?

It directs the AI to build an end-to-end data pipeline fetching museum records via API, saving them into relational tables, and presenting metrics in Streamlit.

Which database backends are supported?

The setup connects to standard MySQL instances or TiDB Cloud accounts using the default port 3306.

Similar skills

All skills for Data and databases →
indicator-setup marketcalls Creates a venv, installs the libraries OpenAlgo indicator scripts rely on, and prepares project folders plus a .env with your API key. CX Codex +1 551installs etl-connector-strategy Samuel Berthe Walks a SaaS vendor through whether, where and how to appear as a source in customers' ETL/ELT pipelines, and what that costs to maintain. CX Codex +1 8,000installs indicator-dashboard marketcalls Creates technical analysis dashboards with Plotly Dash or Streamlit. Generates live multi-timeframe charts and market scanners. CX Codex +1 570installs ETL Pipeline Claude Office Skills A skill for designing and automating ETL pipelines: pull from databases and APIs, transform, load into warehouses. Useful when you need a recurring data flow. CX Codex +1 4,800installs pyspark-etl-best-practices-cursorrules-prompt-file PatrickJS A Cursor rule that sets PySpark code style: F.col(), explicit joins, select over withColumn, and Iceberg-aware ETL structure. ★ 41,024repo stars mysql sanjay3290 This skill runs SELECT queries against several MySQL databases and blocks every write. Handy when you want to inspect a schema or pull data without touching production. CX Codex +1 420installs

From the same set74

harvard-artifacts-data-engineering-app A skill that walks an agent through an ETL pipeline on Harvard Art Museums API data, SQL storage and a Streamlit dashboard with Plotly charts. CX Codex +1 2,000installs harvard-art-museum-data-pipeline Guides data pipeline setup for the Harvard Art Museums API. It normalizes artifact records into MySQL and renders a Streamlit dashboard. CX Codex +1 2,000installs harvard-artifacts-data-engineering-analytics Builds an ETL workflow for Harvard Art Museums records and a Streamlit analytics dashboard. It fits projects that combine the museum API, Python, and SQL. CX Codex +1 2,000installs harvard-artifacts-data-engineering-pipeline Pulls artifact records from the Harvard Art Museums API, loads them into SQL tables, and renders a Streamlit dashboard on top. CX Codex +1 2,000installs harvard-art-museums-etl-analytics This skill pulls Harvard Art Museums records through the API, stores structured data in SQL, and supports Streamlit dashboards for collection analysis. CX Codex +1 2,000installs harvard-artifacts-etl-analytics A skill that walks your agent through building an ETL pipeline and an analytics dashboard on Harvard Art Museums API data. Useful when you want a set route from API calls to Streamlit charts. CX Codex +1 2,000installs realtime-cinema-data-engineering-pipeline Instructions for assembling a streaming pipeline that routes simulated ticket transactions through message queues and warehouse layers. CX Codex +1 2,000installs harvard-art-museums-data-pipeline Builds a museum-artifact data flow from the Harvard API to SQL analysis and a Streamlit dashboard. Useful for collection data projects. CX Codex +1 2,000installs

Project sponsors

Companies that keep this analytics open
Gold sponsor
Nutra.Club

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