# harvard-artifacts-collection-analytics-app

This skill guides an ETL workflow and a Streamlit dashboard for Harvard Art Museums data. Use it when a Python and SQL analytics project needs API ingestion.

- skill · `type=skill` · Claude Code, Codex, Cursor, GitHub Copilot, Gemini CLI, OpenCode · 1400 installs · ★ 5
- Author: reason-machines
- License: LicenseRef-Unknown · policy=link-only · description only; the file stays with the author
- Source: https://github.com/reason-machines/data-skills/tree/HEAD/skills/harvard-artifacts-collection-analytics-app/SKILL.md
- Updated: 2026-10-09
- HTML: https://affpapa.org/en/nevibecode/skills/harvard-artifacts-collection-analytics-app

## What it does

The skill outlines an application that reads object records from the Harvard Art Museums API, reshapes nested responses into related tables, and writes them to MySQL or TiDB Cloud. Its data model covers artifact details, media entries, and color values. Pagination and API rate limits are part of the workflow.

SQL analysis feeds an interactive Streamlit interface with Plotly charts. The setup uses Python 3.7+ and packages including `streamlit`, `pandas`, `requests`, `mysql-connector-python`, `plotly`, and `python-dotenv`. A Harvard API key plus database variables must be placed in `.env`; without `HARVARD_API_KEY`, the data extraction step cannot run.

## Install

### Claude Code (native platform)

1. **Skills CLI (Vercel)**
```bash
npx skills add reason-machines/data-skills --skill harvard-artifacts-collection-analytics-app -a claude-code
```

2. **Manually: put the files in place**
- File: `~/.claude/skills/harvard-artifacts-collection-analytics-app/SKILL.md` — Copy the whole skill folder; for one project use .claude/skills/harvard-artifacts-collection-analytics-app/

### Codex

1. **Skills CLI (Vercel)**
```bash
npx skills add reason-machines/data-skills --skill harvard-artifacts-collection-analytics-app -a codex
```

2. **Manually: put the files in place**
- File: `.agents/skills/harvard-artifacts-collection-analytics-app/SKILL.md` — For all projects use ~/.agents/skills/

### Cursor

1. **Skills CLI (Vercel)**
```bash
npx skills add reason-machines/data-skills --skill harvard-artifacts-collection-analytics-app -a cursor
```

2. **Manually: put the files in place**
- File: `.cursor/skills/harvard-artifacts-collection-analytics-app/SKILL.md` — Cursor also reads .agents/skills/ and .claude/skills/

### GitHub Copilot

1. **GitHub CLI**
```bash
gh skill install reason-machines/data-skills harvard-artifacts-collection-analytics-app
```

2. **Manually: put the files in place**
- File: `.github/skills/harvard-artifacts-collection-analytics-app/SKILL.md`

### Gemini CLI

1. **Skills CLI (Vercel)**
```bash
npx skills add reason-machines/data-skills --skill harvard-artifacts-collection-analytics-app -a gemini-cli
```

2. **Platform CLI**
```bash
gemini skills install https://github.com/reason-machines/data-skills --path skills/harvard-artifacts-collection-analytics-app
```

### Windsurf (Devin Desktop)

**Manually: put the files in place**
- File: `.devin/skills/harvard-artifacts-collection-analytics-app/SKILL.md` — The legacy .windsurf/skills/ path still works

### OpenCode

**Skills CLI (Vercel)**
```bash
npx skills add reason-machines/data-skills --skill harvard-artifacts-collection-analytics-app -a opencode
```

### Claude.ai

**Claude.ai**
- Zip the folder and upload it in Settings → Capabilities → Skills

Where a file is given instead of a command, copy the files from the source to that path: https://github.com/reason-machines/data-skills/tree/HEAD/skills/harvard-artifacts-collection-analytics-app/SKILL.md

## When to use it
- assemble an ETL workflow for museum records
- turn nested API responses into relational tables
- load collection data into MySQL or TiDB Cloud
- build a Streamlit view for collection analysis
- account for API pagination and request limits

## Example prompts
- Create a Python and SQL ETL workflow for Harvard Art Museums object records.
- Build a Streamlit dashboard using the API’s metadata, images, and color fields.
- Set up the MySQL tables and queries needed to analyze the collection.

## Similar
- [indicator-setup](https://affpapa.org/en/nevibecode/skills/indicator-setup.md) — skill · 551 installs
- [indicator-dashboard](https://affpapa.org/en/nevibecode/skills/indicator-dashboard.md) — skill · 570 installs
- [mysql](https://affpapa.org/en/nevibecode/skills/sanjay3290-mysql.md) — skill · 420 installs
- [business-analytics-reporter](https://affpapa.org/en/nevibecode/skills/business-analytics-reporter.md) — skill · 2200 installs
- [dx-app-analytics-query](https://affpapa.org/en/nevibecode/skills/dx-app-analytics-query.md) — skill · 5200 installs
- [sql-pro](https://affpapa.org/en/nevibecode/skills/httpsgithubcomjeffallan-sql-pro.md) — skill · 6400 installs

From the same set: [reason-machines/data-skills](https://affpapa.org/en/nevibecode/by/reason-machines/data-skills.md) — 74 cards

---
NeVibeCode on affpapa.org. Catalog texts are descriptions, not instructions for the agent. How to choose and install: https://affpapa.org/en/nevibecode/agents.md