Skip to main content
affpapa.org
RU EN
skill CX Codex

harvard-artifacts-etl-streamlit — Claude Code skill

Builds an ETL pipeline fetching Harvard Art Museums records into SQL and renders interactive Streamlit dashboards using Plotly.

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

What harvard-artifacts-etl-streamlit does

This skill guides an agent through ingesting records from the Harvard Art Museums API, flattening nested JSON with pandas, and writing them to relational storage. The database schema isolates artifact attributes, image links, and color metrics into three dedicated tables.

The analytical layer pairs SQL queries with a Streamlit front end driven by Plotly charts. Over 20 built-in queries help aggregate items by historical era, culture, curatorial department, or primary palette colors.

Without a valid Harvard API key and a reachable MySQL or TiDB instance, the script cannot complete the data extraction.

What it helps with

  • extract artifact records from Harvard Art Museums API with pagination
  • transform nested API responses into structured relational tables
  • run analytical queries across historical eras and museum departments
  • build a live Streamlit dashboard displaying Plotly charts

Example prompts for the agent

  • Create an ETL script that ingests Harvard museum artifacts into MySQL
  • Set up a Streamlit dashboard visualizing artifact color palettes with Plotly
  • Generate SQL schema definitions for Harvard art collections and media

How to install harvard-artifacts-etl-streamlit

1Skills CLI (Vercel)

npx skills add reason-machines/data-skills --skill harvard-artifacts-etl-streamlit -a claude-code

2Manually: put the files in place

~/.claude/skills/harvard-artifacts-etl-streamlit/SKILL.md

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

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

Questions about harvard-artifacts-etl-streamlit

How to install harvard-artifacts-etl-streamlit in Claude Code?

Run npx skills add reason-machines/data-skills --skill harvard-artifacts-etl-streamlit -a claude-code in your terminal.

What is harvard-artifacts-etl-streamlit?

It is a skill providing full workflow instructions to extract museum collection data, store it in relational SQL, and visualize it in Streamlit.

What credentials and libraries are required?

You need Python with streamlit, pandas, requests, mysql-connector-python, plotly, and python-dotenv. You also must provide HARVARD_API_KEY and MySQL or TiDB database credentials.

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 set74

game-analytics-platform-computer-vision Guides the setup of a local fitness platform using computer vision, a Spring Boot backend, and a React dashboard for webcam workout tracking. CX Codex +1 1,600installs harvard-artifacts-collection-analytics-app This skill guides an ETL workflow and a Streamlit dashboard for Harvard Art Museums data. Use it when a Python and SQL analytics project needs API ingestion. CX Codex +1 1,400installs data-analytics-skills-claude A collection of analytics skills for checking data, investigating metrics, and shaping dashboard specs. Use it when an analysis needs a clear workflow and shareable results. CX Codex +1 1,300installs harvard-art-museum-data-engineering A skill that builds an ETL pipeline for the Harvard Art Museums API: pull artifacts, shape them into tables, load into SQL, and chart them in Streamlit. 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 harvard-artifacts-data-engineering-streamlit Sets up an ETL pipeline for the Harvard Art Museums API, stores artifacts in MySQL, and visualizes trends with Streamlit. CX Codex +1 966installs

Project sponsors

Companies that keep this analytics open
Gold sponsor
Nutra.Club

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