harvard-artifacts-collection-data-engineering-analytics skill
Sets up an end-to-end data pipeline fetching Harvard Art Museums records, loading them into MySQL, and visualising trends in Streamlit.
npx skills add reason-machines/data-skills --skill harvard-artifacts-collection-data-engineering-analytics -a claude-codeWhat harvard-artifacts-collection-data-engineering-analytics does
This skill guides the agent through an entire pipeline for museum artifact analytics. It extracts records from the Harvard Art Museums API, handling request pacing and multi-page responses. The transformation step unpacks nested JSON into relational tables covering object metadata, images, and color hex percentages.
Data lands in MySQL or TiDB Cloud across foreign-keyed tables. On top of the database, the project supplies over 20 SQL queries along with interactive charts built via Streamlit and Plotly.
The pipeline fails immediately if HARVARD_API_KEY or the database credentials in .env are omitted.
What it helps with
- extract museum artifacts from the Harvard API with rate limiting
- transform nested JSON into relational schemas for metadata, images, and colors
- launch a Streamlit dashboard with Plotly charts on top of MySQL or TiDB Cloud
- run analytical SQL queries across art collection datasets
Example prompts for the agent
- Set up an ETL pipeline to load Harvard Art Museums records into MySQL.
- Create a Streamlit dashboard with Plotly charts for museum collection data.
- Generate SQL schema and queries to analyze Harvard artifact colors and metadata.
How to install harvard-artifacts-collection-data-engineering-analytics
1Skills CLI (Vercel)
npx skills add reason-machines/data-skills --skill harvard-artifacts-collection-data-engineering-analytics -a claude-code2Manually: put the files in place
~/.claude/skills/harvard-artifacts-collection-data-engineering-analytics/SKILL.mdCopy the whole skill folder; for one project use .claude/skills/harvard-artifacts-collection-data-engineering-analytics/
1Skills CLI (Vercel)
npx skills add reason-machines/data-skills --skill harvard-artifacts-collection-data-engineering-analytics -a codex2Manually: put the files in place
.agents/skills/harvard-artifacts-collection-data-engineering-analytics/SKILL.mdFor all projects use ~/.agents/skills/
1Skills CLI (Vercel)
npx skills add reason-machines/data-skills --skill harvard-artifacts-collection-data-engineering-analytics -a cursor2Manually: put the files in place
.cursor/skills/harvard-artifacts-collection-data-engineering-analytics/SKILL.mdCursor also reads .agents/skills/ and .claude/skills/
1GitHub CLI
gh skill install reason-machines/data-skills harvard-artifacts-collection-data-engineering-analytics2Manually: put the files in place
.github/skills/harvard-artifacts-collection-data-engineering-analytics/SKILL.md1Skills CLI (Vercel)
npx skills add reason-machines/data-skills --skill harvard-artifacts-collection-data-engineering-analytics -a gemini-cli2Platform CLI
gemini skills install https://github.com/reason-machines/data-skills --path skills/harvard-artifacts-collection-data-engineering-analyticsManually: put the files in place
.devin/skills/harvard-artifacts-collection-data-engineering-analytics/SKILL.mdThe legacy .windsurf/skills/ path still works
Skills CLI (Vercel)
npx skills add reason-machines/data-skills --skill harvard-artifacts-collection-data-engineering-analytics -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-collection-data-engineering-analytics
How to install harvard-artifacts-collection-data-engineering-analytics in Claude Code?
Run npx skills add reason-machines/data-skills --skill harvard-artifacts-collection-data-engineering-analytics -a claude-code. You can also configure it directly in ~/.claude/skills/harvard-artifacts-collection-data-engineering-analytics/SKILL.md.
What does this skill do?
It builds an automated workflow that fetches Harvard Art Museums data, writes structured tables to MySQL or TiDB Cloud, and presents analytics in Streamlit.
Which Python libraries are required?
The pipeline relies on streamlit, pandas, requests, mysql-connector-python, plotly, and python-dotenv.