skill CX Codex

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

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

Run `npx skills add reason-machines/data-skills --skill harvard-artifacts-collection-data-engineering -a claude-code`. The skill lands in `~/.claude/skills/harvard-artifacts-collection-data-engineering/SKILL.md`.

Q: What do I need before running it?

A `HARVARD_API_KEY` and MySQL access. Set `DB_HOST`, `DB_PORT`, `DB_USER`, `DB_PASSWORD` and `DB_NAME` in your environment, and create the `artifactmetadata`, `artifactmedia` and `artifactcolors` tables by hand.

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.

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

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

Open on GitHub

What harvard-artifacts-collection-data-engineering does

The skill covers a full application: a client for the Harvard Art Museums API with pagination, an ETL pipeline, a relational schema and interactive dashboards. The flow is API → ETL → SQL → analytics → visualization.

Three tables hold the data — artifactmetadata, artifactmedia and artifactcolors. Media and colors come out of nested JSON as separate rows and link back to the artifact by foreign key. Analytics is a set of ready-made SQL queries, and charts run on Plotly inside Streamlit.

You need a HARVARD_API_KEY and a reachable MySQL instance: host, port, user, password and database name all come from environment variables. Dependencies install from requirements.txt — streamlit, pandas, requests, mysql-connector-python and plotly. There are no migrations, so create the tables yourself before the first pipeline run; otherwise the load step has nowhere to write.

What it helps with

pull a museum collection from the API page by page
flatten nested JSON into relational tables
link artifacts to their images and colors
run analytical queries over collection metadata
build an interactive Streamlit dashboard

Example prompts for the agent

build an ETL pipeline for Harvard Art Museums artifact data
set up batch loading from the Harvard API into MySQL
create a Streamlit dashboard over the artifactmetadata table

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

1Skills CLI (Vercel)

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

2Manually: put the files in place

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

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

1Skills CLI (Vercel)

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

2Manually: put the files in place

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

For all projects use ~/.agents/skills/

1Skills CLI (Vercel)

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

2Manually: put the files in place

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

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

1GitHub CLI

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

2Manually: put the files in place

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

1Skills CLI (Vercel)

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

2Platform CLI

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

Manually: put the files in place

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

The legacy .windsurf/skills/ path still works

Skills CLI (Vercel)

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

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

Questions about harvard-artifacts-collection-data-engineering

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

Run npx skills add reason-machines/data-skills --skill harvard-artifacts-collection-data-engineering -a claude-code. The skill lands in ~/.claude/skills/harvard-artifacts-collection-data-engineering/SKILL.md.

What does this skill do?

It describes an end-to-end app for the Harvard Art Museums API: artifact extraction, ETL into MySQL, analytical SQL queries and Streamlit dashboards with Plotly.

What do I need before running it?

A HARVARD_API_KEY and MySQL access. Set DB_HOST, DB_PORT, DB_USER, DB_PASSWORD and DB_NAME in your environment, and create the artifactmetadata, artifactmedia and artifactcolors tables by hand.

Similar skills

All skills for Data and databases →

data-engineering Seth Hobson A plugin for Claude, Claude and Cursor that helps build ETL pipelines, design data warehouses and write batch processing jobs. CX Codex ★ 41,729repo stars context-engineering-collection muratcankoylan Patterns for production agent design: context management, multi-agent systems, long-running loops. Use when building autonomous systems that need to operate reliably. CX Codex +1 4,200installs sql-pro https://github.com/Jeffallan Optimizes slow SQL queries, designs database schemas, and fixes performance bottlenecks. Built for EXPLAIN plan tuning and cross-dialect migrations. CX Codex +1 6,400installs database-optimizer https://github.com/Jeffallan Investigates slow PostgreSQL and MySQL queries, breaks down execution plans with EXPLAIN ANALYZE, and drafts indexes without table locks. CX Codex +1 6,000installs mysql-patterns affaan-m Production patterns for MySQL and MariaDB schema design, indexing, transactions, and slow query diagnostics in AI coding agents. CX Codex +1 4,700installs sql-queries phuryn Generates database queries from natural language descriptions and schema files. Useful for analysts and engineers building data reports across different SQL dialects. CX Codex +1 2,800installs

From the same set22

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 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 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-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 iac-terraform-data-engineering A skill for Claude and other AI agents that helps describe AWS data infrastructure in Terraform: S3 buckets, EC2 instances, IAM roles. CX Codex +1 1,800installs iac-data-engineering-terraform A skill with ready Terraform patterns for data engineering: S3 buckets, EC2 instances and IAM roles. Useful when you need to stand up pipeline infrastructure declaratively. CX Codex +1 1,800installs