skill CX Codex

harvard-artifacts-etl-analytics — Claude Code skill

Q: How do I install harvard-artifacts-etl-analytics in Claude Code?

Run `npx skills add reason-machines/data-skills --skill harvard-artifacts-etl-analytics -a claude-code`. The skill file lands at `~/.claude/skills/harvard-artifacts-etl-analytics/SKILL.md`.

Q: What do I need before running it?

A `HARVARD_API_KEY` and connection details in `.env`: `DB_HOST`, `DB_PORT`, `DB_USER`, `DB_PASSWORD`, `DB_NAME`. The table schema comes from the SQL script in the skill.

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.

Install into Claude Code · Skills CLI (Vercel) All methods and platforms ↓

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

Open on GitHub

What harvard-artifacts-etl-analytics does

The skill lays out the whole data path: pulling objects from the Harvard Art Museums API page by page, flattening nested JSON into three normalized tables, loading them into MySQL or TiDB Cloud, then querying the result. Code samples use requests, pandas and mysql-connector-python. The schema is fixed up front — artifactmetadata, artifactmedia and artifactcolors, joined by artifact_id.

You need a HARVARD_API_KEY and database credentials before anything runs. Host, port, user, password and database name go into .env. Requests to https://api.harvardartmuseums.org/object fail without the key, so registering on the museum site comes first. The dashboard starts with streamlit run app.py and serves at http://localhost:8501.

More than twenty ready-made analytical SQL queries ship with the skill, plus Plotly charts. Your agent leans on those templates when you ask for collection metrics by culture or century.

What it helps with

pull objects from the Harvard Art Museums API across pages
split nested JSON into metadata, media and color tables
load normalized rows into MySQL or TiDB Cloud
run ready-made SQL queries for collection metrics
build a Streamlit dashboard with Plotly charts

Example prompts for the agent

Build an ETL pipeline for Harvard Art Museums API data with paginated extraction
Split the API response into artifactmetadata, artifactmedia and artifactcolors tables
Create a Streamlit dashboard with Plotly charts by culture and century

How to install harvard-artifacts-etl-analytics

1Skills CLI (Vercel)

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

2Manually: put the files in place

~/.claude/skills/harvard-artifacts-etl-analytics/SKILL.md

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

1Skills CLI (Vercel)

npx skills add reason-machines/data-skills --skill harvard-artifacts-etl-analytics -a codex

2Manually: put the files in place

.agents/skills/harvard-artifacts-etl-analytics/SKILL.md

For all projects use ~/.agents/skills/

1Skills CLI (Vercel)

npx skills add reason-machines/data-skills --skill harvard-artifacts-etl-analytics -a cursor

2Manually: put the files in place

.cursor/skills/harvard-artifacts-etl-analytics/SKILL.md

Cursor also reads .agents/skills/ and .claude/skills/

1GitHub CLI

gh skill install reason-machines/data-skills harvard-artifacts-etl-analytics

2Manually: put the files in place

.github/skills/harvard-artifacts-etl-analytics/SKILL.md

1Skills CLI (Vercel)

npx skills add reason-machines/data-skills --skill harvard-artifacts-etl-analytics -a gemini-cli

2Platform CLI

gemini skills install https://github.com/reason-machines/data-skills --path skills/harvard-artifacts-etl-analytics

Manually: put the files in place

.devin/skills/harvard-artifacts-etl-analytics/SKILL.md

The legacy .windsurf/skills/ path still works

Skills CLI (Vercel)

npx skills add reason-machines/data-skills --skill harvard-artifacts-etl-analytics -a opencode

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

Questions about harvard-artifacts-etl-analytics

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

Run npx skills add reason-machines/data-skills --skill harvard-artifacts-etl-analytics -a claude-code. The skill file lands at ~/.claude/skills/harvard-artifacts-etl-analytics/SKILL.md.

What does harvard-artifacts-etl-analytics do?

It guides an agent through building an ETL pipeline and an analytics app on Harvard Art Museums API data: extraction, JSON transformation, database loading and Streamlit visualization.

What do I need before running it?

A HARVARD_API_KEY and connection details in .env: DB_HOST, DB_PORT, DB_USER, DB_PASSWORD, DB_NAME. The table schema comes from the SQL script in the skill.

Similar skills

All skills for Data and databases →

xlsx official anthropics Creates, reads, edits, and converts spreadsheet files. Use it when the requested deliverable is an Excel workbook or another tabular file. 187,223installs google-agents-cli-observability official Google This skill guides you through tracing and monitoring AI agents, including ADK agents. Use it when you need to inspect agent execution or monitor a deployed agent. CX Codex +1 511,300installs caveman-evidence-review JuliusBrussee A read-only skill reviews Caveman Cloud evidence on LLM spend, traces, and routing. Use it to see where a project’s model budget goes. CX Codex +1 104,500installs migration JuliusBrussee Enforces reversible, compatibility-safe transitions for schema, data, and API updates. Useful whenever data loss or rollout downtime is unacceptable. CX Codex +1 103,900installs performance-optimization addyosmani An agent skill that measures before it changes code: Core Web Vitals budgets, N+1 queries, missing indexes and slow endpoints. CX Codex +1 65,200installs supabase official supabase Guides the agent through database configuration and strict RLS policies in Supabase. CX Codex GP ChatGPT 8installs

From the same set31

employee-performance-analytics-hr This skill turns an employee CSV into department KPIs, per-person efficiency scores and charts. Useful when you need to read a workforce export without building pivot tables by hand. CX Codex +1 2,100installs llm-intelligent-public-opinion-analytics This skill sets up an LLM-powered opinion analytics assistant: it crawls hot lists, scores sentiment, clusters topics and sends alerts. CX Codex +1 2,100installs 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-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 amee-joshi-data-engineering-portfolio A reference skill with Azure data engineering examples: Bronze–Silver–Gold layers, Delta Lake, dimensional models and pipeline designs. CX Codex +1 2,000installs data-engineering-study-material A study guide skill for data engineering: explains concepts, shows pipeline examples, and helps with interview prep. CX Codex +1 2,000installs analytics-tracking-automation A skill that walks the agent through analytics setup: crawl the site, design GA4 events, sync them into GTM, verify in preview, publish the container. 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