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

harvard-artifacts-collection-analytics-app — Claude Code skill: setup

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.

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

What harvard-artifacts-collection-analytics-app does

The skill outlines an application that reads object records from the Harvard Art Museums API, reshapes nested responses into related tables, and writes them to MySQL or TiDB Cloud. Its data model covers artifact details, media entries, and color values. Pagination and API rate limits are part of the workflow.

SQL analysis feeds an interactive Streamlit interface with Plotly charts. The setup uses Python 3.7+ and packages including streamlit, pandas, requests, mysql-connector-python, plotly, and python-dotenv. A Harvard API key plus database variables must be placed in .env; without HARVARD_API_KEY, the data extraction step cannot run.

What it helps with

  • assemble an ETL workflow for museum records
  • turn nested API responses into relational tables
  • load collection data into MySQL or TiDB Cloud
  • build a Streamlit view for collection analysis
  • account for API pagination and request limits

Example prompts for the agent

  • Create a Python and SQL ETL workflow for Harvard Art Museums object records.
  • Build a Streamlit dashboard using the API’s metadata, images, and color fields.
  • Set up the MySQL tables and queries needed to analyze the collection.

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

1Skills CLI (Vercel)

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

2Manually: put the files in place

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

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

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

Questions about harvard-artifacts-collection-analytics-app

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

Run npx skills add reason-machines/data-skills --skill harvard-artifacts-collection-analytics-app -a claude-code, then inspect ~/.claude/skills/harvard-artifacts-collection-analytics-app/SKILL.md.

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

It guides an API-to-database workflow for Harvard Art Museums records, including normalization into artifact, media, and color tables, SQL analysis, and a Streamlit dashboard.

What is required to use this skill?

Prepare Python 3.7+, the listed packages, a Harvard Art Museums API key, and database connection variables in .env. The application starts with streamlit run app.py.

Similar skills

All skills for Data and databases →
indicator-setup marketcalls Creates a venv, installs the libraries OpenAlgo indicator scripts rely on, and prepares project folders plus a .env with your API key. CX Codex +1 551installs indicator-dashboard marketcalls Creates technical analysis dashboards with Plotly Dash or Streamlit. Generates live multi-timeframe charts and market scanners. CX Codex +1 570installs 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 dx-app-analytics-query forcedotcom This skill retrieves managed package usage data through App Analytics and configures simulation mode. Use it when working with subscriber analytics queries. CX Codex +1 5,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 set62

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 snowflake-dbt-airbnb-analytics Guides coding assistants through building a Snowflake and dbt warehouse on Inside Airbnb datasets, from stage ingestion to Streamlit reporting. CX Codex +1 1,700installs harvard-artifacts-etl-pipeline A skill that walks your coding agent through an ETL pipeline from the Harvard Art Museums API to Streamlit charts. CX Codex +1 1,700installs infrastructure-cicd-data-engineering This skill guides Terraform delivery for data infrastructure through GitHub Actions and AWS OIDC. Use it when infrastructure changes need checks, approvals, and automated deployment. CX Codex +1 1,600installs 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

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