harvard-artifacts-data-engineering-streamlit — Claude Code skill
Sets up an ETL pipeline for the Harvard Art Museums API, stores artifacts in MySQL, and visualizes trends with Streamlit.
npx skills add reason-machines/data-skills --skill harvard-artifacts-data-engineering-streamlit -a claude-codeWhat harvard-artifacts-data-engineering-streamlit does
The skill sets up a full workflow for museum catalog records. It pulls artifact entries from the Harvard Art Museums API using pagination and extracts details into relational structures for artifactmetadata, artifactmedia, and artifactcolors.
Data lands in MySQL or TiDB Cloud. Over 20 predefined SQL queries process breakdowns by century, culture, and department, presenting visual outputs through Plotly inside a Streamlit web app accessible at http://localhost:8501.
Without a valid HARVARD_API_KEY and an active database connection configured in .env, the extraction scripts fail immediately. Running the project also requires installing dependencies like pandas, requests, and mysql-connector-python.
What it helps with
- ingest museum catalog data from the Harvard Art Museums API
- load artifact metadata and color distributions into MySQL
- build an interactive Plotly dashboard with Streamlit
- run analytical SQL queries across centuries and cultural origins
Example prompts for the agent
- Build an ETL pipeline to ingest Harvard Art Museums API data into MySQL
- Set up a Streamlit dashboard with Plotly charts for museum artifact analytics
- Generate MySQL table schemas for artifact metadata and color records
How to install harvard-artifacts-data-engineering-streamlit
1Skills CLI (Vercel)
npx skills add reason-machines/data-skills --skill harvard-artifacts-data-engineering-streamlit -a claude-code2Manually: put the files in place
~/.claude/skills/harvard-artifacts-data-engineering-streamlit/SKILL.mdCopy the whole skill folder; for one project use .claude/skills/harvard-artifacts-data-engineering-streamlit/
1Skills CLI (Vercel)
npx skills add reason-machines/data-skills --skill harvard-artifacts-data-engineering-streamlit -a codex2Manually: put the files in place
.agents/skills/harvard-artifacts-data-engineering-streamlit/SKILL.mdFor all projects use ~/.agents/skills/
1Skills CLI (Vercel)
npx skills add reason-machines/data-skills --skill harvard-artifacts-data-engineering-streamlit -a cursor2Manually: put the files in place
.cursor/skills/harvard-artifacts-data-engineering-streamlit/SKILL.mdCursor also reads .agents/skills/ and .claude/skills/
1GitHub CLI
gh skill install reason-machines/data-skills harvard-artifacts-data-engineering-streamlit2Manually: put the files in place
.github/skills/harvard-artifacts-data-engineering-streamlit/SKILL.md1Skills CLI (Vercel)
npx skills add reason-machines/data-skills --skill harvard-artifacts-data-engineering-streamlit -a gemini-cli2Platform CLI
gemini skills install https://github.com/reason-machines/data-skills --path skills/harvard-artifacts-data-engineering-streamlitManually: put the files in place
.devin/skills/harvard-artifacts-data-engineering-streamlit/SKILL.mdThe legacy .windsurf/skills/ path still works
Skills CLI (Vercel)
npx skills add reason-machines/data-skills --skill harvard-artifacts-data-engineering-streamlit -a opencodeClaude.ai
Zip the folder and upload it in Settings → Capabilities → Skills
Step by step, with commands for each platform: How to install skills in Claude Code: five ways
Questions about harvard-artifacts-data-engineering-streamlit
How to install harvard-artifacts-data-engineering-streamlit in Claude Code?
Run npx skills add reason-machines/data-skills --skill harvard-artifacts-data-engineering-streamlit -a claude-code in your terminal.
What does harvard-artifacts-data-engineering-streamlit do?
It coordinates data ingestion from the Harvard museum API, writes clean relational records into MySQL, and runs Streamlit dashboards for exploration.
What credentials are required to run this skill?
You need a HARVARD_API_KEY from the museum portal and MySQL or TiDB connection details placed in a .env file.