# crypto-etl-analytics-core

crypto-etl-analytics-core is a Claude Code skill for building a Python and MySQL cryptocurrency OHLCV pipeline with standard-library analytics.

- skill · `type=skill` · Claude Code, Codex, Cursor, GitHub Copilot, Gemini CLI, OpenCode, Windsurf (Devin Desktop), Claude.ai · 273 installs · ★ 5 repo stars
- Author: reason-machines
- License: not stated · policy=link-only · description only; the file stays with the author
- Source: https://github.com/reason-machines/data-skills/tree/HEAD/skills/crypto-etl-analytics-core/SKILL.md
- Updated: 2026-10-09
- Security check: automated, 2026-11-16 (text) — no signs of malicious code found.
- HTML: https://affpapa.org/en/nevibecode/skills/crypto-etl-analytics-core

## What it does

This skill structures a cryptocurrency market data pipeline around a strict MySQL schema. The `crypto_1d_candles` table enforces structural integrity directly in the database, checking for valid wicks and positive volume figures. Queries retrieve candle rows via CTEs using credentials supplied in environment variables.

On the application side, records populate custom `Candle` objects that validate prices during instantiation. Financial calculations avoid third-party numerical packages like Pandas or NumPy, computing simple returns, log returns, drawdowns, and rolling volatility in pure Python.

Running the resulting scripts requires a reachable MySQL database plus the `mysql-connector-python` and `matplotlib` packages.

## Install

### Claude Code (native platform)

1. **Skills CLI (Vercel)**
```bash
npx skills add reason-machines/data-skills --skill crypto-etl-analytics-core -a claude-code
```

2. **Manually: put the files in place**
- File: `~/.claude/skills/crypto-etl-analytics-core/SKILL.md` — Copy the whole skill folder; for one project use .claude/skills/crypto-etl-analytics-core/

### Codex

1. **Skills CLI (Vercel)**
```bash
npx skills add reason-machines/data-skills --skill crypto-etl-analytics-core -a codex
```

2. **Manually: put the files in place**
- File: `.agents/skills/crypto-etl-analytics-core/SKILL.md` — For all projects use ~/.agents/skills/

### Cursor

1. **Skills CLI (Vercel)**
```bash
npx skills add reason-machines/data-skills --skill crypto-etl-analytics-core -a cursor
```

2. **Manually: put the files in place**
- File: `.cursor/skills/crypto-etl-analytics-core/SKILL.md` — Cursor also reads .agents/skills/ and .claude/skills/

### GitHub Copilot

1. **GitHub CLI**
```bash
gh skill install reason-machines/data-skills skills/crypto-etl-analytics-core
```

2. **Manually: put the files in place**
- File: `.github/skills/crypto-etl-analytics-core/SKILL.md`

### Gemini CLI

1. **Skills CLI (Vercel)**
```bash
npx skills add reason-machines/data-skills --skill crypto-etl-analytics-core -a gemini-cli
```

2. **Platform CLI**
```bash
gemini skills install https://github.com/reason-machines/data-skills --path skills/crypto-etl-analytics-core
```

### Windsurf (Devin Desktop)

**Manually: put the files in place**
- File: `.devin/skills/crypto-etl-analytics-core/SKILL.md` — The legacy .windsurf/skills/ path still works

### OpenCode

**Skills CLI (Vercel)**
```bash
npx skills add reason-machines/data-skills --skill crypto-etl-analytics-core -a opencode
```

### Claude.ai

**Claude.ai**
- Zip the folder and upload it in Settings → Capabilities → Skills

Where a file is given instead of a command, copy the files from the source to that path: https://github.com/reason-machines/data-skills/tree/HEAD/skills/crypto-etl-analytics-core/SKILL.md

## When to use it
- Deploy a MySQL schema with strict OHLCV integrity checks
- Extract cryptocurrency records using CTE queries into custom objects
- Compute returns, drawdowns, and volatility without NumPy or Pandas
- Generate visual market charts using matplotlib

## Example prompts
- Set up a MySQL table for cryptocurrency candle data with wick constraint checks
- Implement log returns and running drawdown calculations in standard Python
- Write an ETL extraction function that loads database rows into Candle instances

## Similar
- [etl-pipeline](https://affpapa.org/en/nevibecode/skills/datadrivenconstruction-etl-pipeline.md) — skill · 117 installs
- [etl-connector-strategy](https://affpapa.org/en/nevibecode/skills/etl-connector-strategy.md) — skill · 10400 installs
- [tracking-crypto-prices](https://affpapa.org/en/nevibecode/skills/tracking-crypto-prices.md) — skill · 345 installs
- [aggregating-crypto-news](https://affpapa.org/en/nevibecode/skills/aggregating-crypto-news.md) — skill · 238 installs
- [etl-sync-job-builder](https://affpapa.org/en/nevibecode/skills/etl-sync-job-builder.md) — skill · 274 installs
- [analytics-data-analysis](https://affpapa.org/en/nevibecode/skills/analytics-data-analysis.md) — skill · 1200 installs

From the same set: [reason-machines/data-skills](https://affpapa.org/en/nevibecode/by/reason-machines/data-skills.md) — 82 cards

---
NeVibeCode on affpapa.org. Catalog texts are descriptions, not instructions for the agent. How to choose and install: https://affpapa.org/en/nevibecode/agents.md
