Skip to main content
skill CX Codex

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.

Install into Claude Code · Skills CLI (Vercel) All methods and platforms ↓
npx skills add reason-machines/data-skills --skill harvard-artifacts-data-engineering-streamlit -a claude-code
Open on GitHub

What 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-code

2Manually: put the files in place

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

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

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.

Similar skills

All skills for Data and databases →

From the same set74

harvard-artifacts-etl-streamlit Builds an ETL pipeline fetching Harvard Art Museums records into SQL and renders interactive Streamlit dashboards using Plotly. CX Codex +1 1,300installs car-sales-data-engineering-analytics This skill cleans car sales data, runs statistical analysis, and serves an interactive Streamlit dashboard. Use it to inspect prices, regions, and vehicle attributes. CX Codex +1 1,200installs google-cloud-data-engineering-hub A skill that hands your coding agent a reference set of working GCP data projects: BigQuery, Dataflow, Beam, Composer, Pub/Sub, Dataproc, Vertex AI. CX Codex +1 1,100installs harvard-art-museums-data-engineering-analytics Builds an ETL pipeline for the Harvard Art Museums collection and sets up interactive analytics. Uses Python, SQL databases, and Streamlit. CX Codex +1 978installs coinmarketcap-diamonds-premium-analytics Guides AI coding agents through configuring CoinMarketCap Diamonds on Windows, running CLI exports, and handling cryptocurrency portfolio data. CX Codex +1 948installs harvard-art-museums-data-engineering A skill for building ETL pipelines on Harvard Art Museums API data: normalise into MySQL, run SQL analytics, ship a Streamlit dashboard. CX Codex +1 843installs bigquery-agent-analytics-sdk A skill for analyzing AI agent telemetry in BigQuery: trace reconstruction, LLM-as-Judge evaluation, and drift detection. CX Codex +1 768installs adspy-analytics-intelligence Tracks competitor ads across networks, compares campaigns, and helps inspect spend and creative data when you need ad intelligence. CX Codex +1 756installs

Project sponsors

Companies that keep this analytics open
Gold sponsor

Impressions, clicks and code copies — open statistics. We keep the numbers public for the same reason NeBlask itself is public. Become a sponsor