skill CX Codex

harvard-artifacts-data-engineering-pipeline — Claude Code skill

Q: How do I install harvard-artifacts-data-engineering-pipeline in Claude Code?

Run `npx skills add reason-machines/data-skills --skill harvard-artifacts-data-engineering-pipeline -a claude-code`; it installs to `~/.claude/skills/harvard-artifacts-data-engineering-pipeline/SKILL.md`.

Pulls artifact records from the Harvard Art Museums API, loads them into SQL tables, and renders a Streamlit dashboard on top.

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

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

Open on GitHub

What harvard-artifacts-data-engineering-pipeline does

The skill fetches museum artifacts from the Harvard Art Museums API with paged requests and rate limiting, then splits the nested JSON into three relational tables covering item metadata, media files, and color palettes. Storage runs on MySQL or TiDB Cloud, with a schema of three linked tables: artifactmetadata, artifactmedia, artifactcolors.

Running it requires an API key from Harvard Art Museums and a .env file holding the database credentials. On the Python side it relies on requests for the API calls, pandas for reshaping records into dataframes, and mysql-connector-python for writing rows into the tables.

Once the data lands in SQL, the skill runs more than 20 prebuilt analytical queries and draws interactive Plotly charts inside a Streamlit app. Without that API key and a configured database, the pipeline has nothing to connect to.

What it helps with

set up an ETL pipeline for the Harvard Art Museums API
split nested artifact JSON into normalized SQL tables
load a museum collection into MySQL or TiDB Cloud
build a Streamlit dashboard with Plotly charts over artifact data
write SQL analytics queries on culture, period, and technique fields

Example prompts for the agent

Build an ETL pipeline for the Harvard Art Museums API with MySQL storage
Split artifact JSON into metadata, media, and colors tables
Set up a Streamlit dashboard with charts over the Harvard artifacts collection

How to install harvard-artifacts-data-engineering-pipeline

1Skills CLI (Vercel)

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

2Manually: put the files in place

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

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

1Skills CLI (Vercel)

npx skills add reason-machines/data-skills --skill harvard-artifacts-data-engineering-pipeline -a codex

2Manually: put the files in place

.agents/skills/harvard-artifacts-data-engineering-pipeline/SKILL.md

For all projects use ~/.agents/skills/

1Skills CLI (Vercel)

npx skills add reason-machines/data-skills --skill harvard-artifacts-data-engineering-pipeline -a cursor

2Manually: put the files in place

.cursor/skills/harvard-artifacts-data-engineering-pipeline/SKILL.md

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

1GitHub CLI

gh skill install reason-machines/data-skills harvard-artifacts-data-engineering-pipeline

2Manually: put the files in place

.github/skills/harvard-artifacts-data-engineering-pipeline/SKILL.md

1Skills CLI (Vercel)

npx skills add reason-machines/data-skills --skill harvard-artifacts-data-engineering-pipeline -a gemini-cli

2Platform CLI

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

Manually: put the files in place

.devin/skills/harvard-artifacts-data-engineering-pipeline/SKILL.md

The legacy .windsurf/skills/ path still works

Skills CLI (Vercel)

npx skills add reason-machines/data-skills --skill harvard-artifacts-data-engineering-pipeline -a opencode

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

Questions about harvard-artifacts-data-engineering-pipeline

How do I install harvard-artifacts-data-engineering-pipeline in Claude Code?

Run npx skills add reason-machines/data-skills --skill harvard-artifacts-data-engineering-pipeline -a claude-code; it installs to ~/.claude/skills/harvard-artifacts-data-engineering-pipeline/SKILL.md.

What does harvard-artifacts-data-engineering-pipeline do?

It pulls records from the Harvard Art Museums API, loads them into SQL tables split across metadata, media, and colors, then powers a Streamlit dashboard with SQL analytics and Plotly charts.

What do I need before running this skill?

An API key from Harvard Art Museums, a MySQL or TiDB Cloud database set up with the matching table schema, and a .env file with the connection details.

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

mm2-analytics-dashboard-roblox A Murder Mystery 2 toolkit for Roblox: catalogues your inventory, tracks knife skins and gamepasses, and turns match stats into strategy advice. CX Codex +1 2,300installs 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-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 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