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

harvard-artifacts-collection-etl-analytics — Claude Code skill: ETL

A skill for building an ETL pipeline and analytics dashboard on Harvard Art Museums API data with Python, SQL and Streamlit.

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

What harvard-artifacts-collection-etl-analytics does

The skill walks the agent through the whole chain: API → ETL → SQL → analytics → visualization. The data source is the Harvard Art Museums API, extraction runs on Python with requests and pandas, the database is MySQL or TiDB Cloud, and the dashboard is Streamlit with Plotly. Inside are functions for paged artifact fetching with rate limiting, splitting nested JSON into three tables (metadata, images, colors), and creating the database schema.

You need a Harvard Art Museums API key and database access up front: HARVARD_API_KEY, DB_HOST, DB_USER, DB_PASSWORD, DB_NAME. Without the key the extraction never starts, because the first API call comes back as an error. Dependencies install from requirements.txt.

The description claims 20+ analytical queries with auto-generated charts, but the text is cut off, so don't count on a specific query set yet. The skill runs in Claude, Codex, Cursor, GitHub Copilot, Gemini CLI and OpenCode.

What it helps with

  • fetch artifacts from the Harvard Art Museums API page by page
  • split nested JSON into metadata, image and color tables
  • create the database schema and load the data
  • write SQL queries for collection analytics
  • build an interactive Streamlit dashboard with Plotly charts

Example prompts for the agent

  • build an ETL pipeline for Harvard Art Museums API data
  • split the artifacts into metadata, image and color tables
  • create a Streamlit dashboard with collection analytics

How to install harvard-artifacts-collection-etl-analytics

1Skills CLI (Vercel)

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

2Manually: put the files in place

~/.claude/skills/harvard-artifacts-collection-etl-analytics/SKILL.md

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

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

Questions about harvard-artifacts-collection-etl-analytics

How do I install harvard-artifacts-collection-etl-analytics in Claude?

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

What does harvard-artifacts-collection-etl-analytics do?

It guides the agent through building an ETL pipeline and analytics dashboard on Harvard Art Museums API data: fetching, transforming JSON into tables, loading into SQL, and visualizing in Streamlit.

What do I need before using the skill?

A Harvard Art Museums API key and access to a MySQL or TiDB Cloud database. Environment variables: HARVARD_API_KEY, DB_HOST, DB_USER, DB_PASSWORD, DB_NAME.

Similar skills

All skills for Data and databases →
etl-connector-strategy Samuel Berthe Walks a SaaS vendor through whether, where and how to appear as a source in customers' ETL/ELT pipelines, and what that costs to maintain. CX Codex +1 8,000installs ETL Pipeline Claude Office Skills A skill for designing and automating ETL pipelines: pull from databases and APIs, transform, load into warehouses. Useful when you need a recurring data flow. CX Codex +1 4,800installs pyspark-etl-best-practices-cursorrules-prompt-file PatrickJS A Cursor rule that sets PySpark code style: F.col(), explicit joins, select over withColumn, and Iceberg-aware ETL structure. ★ 41,011repo stars mysql sanjay3290 This skill runs SELECT queries against several MySQL databases and blocks every write. Handy when you want to inspect a schema or pull data without touching production. CX Codex +1 420installs business-analytics-reporter ailabs-393 Reads a CSV of sales and revenue, finds weak spots and suggests improvement strategies. Useful when you need a business performance report without manual math. CX Codex +1 2,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

From the same set22

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-data-engineering 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. 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 terraform-data-engineering-infrastructure A skill with Terraform patterns for data engineering: S3 data lake buckets, EC2 processing nodes, IAM roles. Useful when AWS infrastructure has to be described in code, not clicked together. CX Codex +1 1,800installs

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