Skip to main content
skill CX Codex

crypto-etl-analytics-core — Claude Code skill: what it does, install

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

no license 273 installs ★ 5 updated 2026-10-09

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

What crypto-etl-analytics-core 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.

What it helps with

  • 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 for the agent

  • 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

How to install crypto-etl-analytics-core

1Skills CLI (Vercel)

npx skills add reason-machines/data-skills --skill crypto-etl-analytics-core -a claude-code

2Manually: put the files in place

~/.claude/skills/crypto-etl-analytics-core/SKILL.md

Copy the whole skill folder; for one project use .claude/skills/crypto-etl-analytics-core/

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

Questions about crypto-etl-analytics-core

How to install crypto-etl-analytics-core in Claude Code?

Run npx skills add reason-machines/data-skills --skill crypto-etl-analytics-core -a claude-code in your terminal.

What does crypto-etl-analytics-core do?

It guides the creation of a cryptocurrency ETL pipeline, strict SQL schema, and an object-oriented analytics module in Python.

Does this pipeline require Pandas or NumPy?

No, the analytics logic relies strictly on standard Python arithmetic without external math libraries.

Similar skills

All skills for Data and databases →
etl-pipeline datadrivenconstruction etl-pipeline is a skill for building construction-data workflows that extract, clean, validate, aggregate, and send results to files, databases, APIs, or dashboards. CX Codex +1 117installs etl-connector-strategy Samuel Berthe etl-connector-strategy 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 10,400installs tracking-crypto-prices Jeremy Longshore tracking-crypto-prices — a skill for Claude Code and five other AI platforms that pulls current and historical prices for 10,000+ coins via CoinGecko and yfinance. Triggers on phrases like "BTC price" or "show me top coins". CX Codex +1 345installs aggregating-crypto-news Jeremy Longshore aggregating-crypto-news — a skill for Claude Code and five other platforms that pulls articles from CoinDesk, CoinTelegraph, The Block, and Decrypt RSS feeds, then filters by coin, category, and time window. CX Codex +1 238installs etl-sync-job-builder patricio0312rev etl-sync-job-builder generates TypeScript ETL pipelines with incremental watermark tracking, idempotent batch upserts, and retry backoff logic. CX Codex +1 274installs analytics-data-analysis Mindrally analytics-data-analysis — a skill for Claude Code and five other platforms that sets rules for Python data work: pandas, matplotlib, seaborn, Jupyter. It kicks in during exploratory analysis, dataset cleanup, and statistical charting. CX Codex +1 1,200installs

From the same set82

The whole set →
enterprise-user-management-ai-system enterprise-user-management-ai-system — a skill that scaffolds a user management system with Kanban boards, support tickets and AI analytics for risk, anomalies and burnout. CX Codex +1 372installs enterprise-user-management-system-ai-analytics The enterprise-user-management-system-ai-analytics skill outlines a user management app with task tracking, support tickets, and ML analytics. Use it when planning authentication, admin views, or workload and risk analysis. CX Codex +1 338installs web-analytics-agent-skill web-analytics-agent-skill pulls search and visitor metrics from Google Search Console, GA4, and Bing Webmaster Tools. Use it for SEO checks, comparisons, and reports. CX Codex +1 306installs microsoft-fabric-unified-analytics microsoft-fabric-unified-analytics walks you through a Fabric analytics stack: OneLake layers, a Dataflow Gen2 cleaning step, PySpark gold tables and Power BI on top. CX Codex +1 282installs enterprise-user-management-system-ai enterprise-user-management-system-ai scaffolds a user management platform pairing React and Node.js with a FastAPI machine learning service. CX Codex +1 249installs ai-data-engineering-rag-pipeline ai-data-engineering-rag-pipeline is a Claude Code skill for building a local RAG workflow with BM25 retrieval, hierarchical document chunks, and retrieval scoring. It tests retrieval against a prepared set of questions. CX Codex +1 165installs zomato-ai-data-engineering-pipeline zomato-ai-data-engineering-pipeline is a Claude Code skill for building a food delivery batch pipeline across S3, Snowflake, dbt, and Airflow, with OpenAI for review enrichment and text-to-SQL. CX Codex +1 128installs high-stakes-analytics-decision-lab The high-stakes-analytics-decision-lab Claude Code skill checks data quality and chooses an analysis method to match the question. It runs for evidence-based reports and decision work that needs uncertainty bounds. CX Codex +1 103installs

Project sponsors

Companies that keep this analytics open