Data & Analytics for Claude Code

Use when reviewing data pipelines, numerical/ML code, model training/inference, or analytics correctness — verifies reproducibility and numerical correctness against the scientific and db persona standards.

> Generate comprehensive database documentation from existing schemas

Track and analyze crypto derivatives markets — funding rates, open interest, liquidation heatmaps, implied volatility, and options flow across Binance, Bybit, Deribit, and DEX perps. Use when researching perpetual positioning, basis-trade opportunities, or options sentiment. Trigger with \"analyze derivatives\", \"funding rates\".

Design database schemas with best practices

Run a full freshie ecosystem discovery scan via rebuild-inventory.py and report plugin, skill, and pack delta against the previous run stored in the SQLite inventory database. Use when refreshing the inventory after adding plugins or tracking ecosystem growth over time. Trigger with \"run discovery scan\", \"scan the inventory\".

Detects and diagnoses ML model decay in production — data drift, concept drift, and silent degradation. Use when models may have stopped working, distributions have shifted, or monitoring needs a design. Trigger with \"audit my ML monitoring\", \"detect model drift\".

Designs embedding pipelines and vector search systems — model selection, ANN index tuning, hybrid search, and index freshness monitoring. Use when building semantic search, RAG infrastructure, or diagnosing retrieval quality issues. Trigger with \"design embedding pipeline\", \"optimize vector search\".

Produces institutional-quality equity research using fundamental analysis, DCF valuation, and technical analysis to issue Buy/Hold/Sell ratings with price targets. Use when analyzing a stock or building an investment thesis. Trigger with "analyze this stock", "equity research on X".

Designs statistically rigorous experiments — A/B tests, power analysis, variance reduction, and causal inference frameworks. Use when designing an experiment, analyzing test results for validity, or auditing experimentation infrastructure. Trigger with \"design A/B test\", \"review experiment methodology\".

Explore blockchain transactions, addresses, and contracts

Transforms raw data into model-ready features — leakage audits, encoding strategies, feature stores, and reproducible pipeline design. Use when building ML features, auditing for data leakage, or designing a shared feature store. Trigger with \"build feature pipeline\", \"audit features for leakage\".

> Find arbitrage opportunities across CEX/DEX with real-time detection

Find optimal DEX routing for token swaps

Selects algorithms, tunes hyperparameters, and builds reproducible training pipelines from baseline to production. Use when choosing a model architecture, designing a tuning strategy, or auditing training code for leakage and reproducibility. Trigger with \"design training pipeline\", \"tune model hyperparameters\".

Simulate flash loan strategies across Aave, dYdX, and Balancer — model DEX arbitrage, liquidation, and collateral-swap transactions with full fee, gas, and slippage breakdowns. Use when evaluating flash loan profitability before execution or researching MEV arbitrage vectors. Trigger with \"simulate flash loan\", \"flash loan arbitrage\".

Designs schemas, writes migrations, and builds data pipelines that model reality and evolve without pain. Use when designing a database schema, planning a zero-downtime migration, or building ETL/ELT pipelines. Trigger with \"design database schema\", \"write zero-downtime migration\".

Verifies citations and data claims by checking URL accessibility, DOI resolution, source authority, and formatting style consistency across APA, MLA, and Chicago. Use when validating academic content or auditing reference accuracy. Trigger with "check citations", "verify data sources".

Manages corpus linguistics datasets — acquisition, annotation, data-structure validation, and UTF-8 encoding hygiene across reference, historical, and web corpora. Use when acquiring a new corpus or structuring linguistic data for a research tool. Trigger with "set up the corpus", "validate this linguistic dataset".

Designs linguistically-informed interfaces for corpus research tools — KWIC displays, concordance viewers, frequency charts, and genre filters following Swiss Design principles. Use when building or improving a UI for a corpus or NLP tool. Trigger with "design the concordance viewer", "improve the KWIC display".

Audits datasets across five quality dimensions — accuracy, completeness, consistency, timeliness, and schema validity — and flags stale or malformed records against authoritative sources. Use when updating a dataset or when data feels outdated. Trigger with "audit this dataset", "check data freshness".

Analyzes query plans, recommends indexes, and diagnoses N+1 patterns, lock contention, and missing pagination for SQLite and PostgreSQL databases. Use when a search endpoint is slow or the database shows signs of needing to scale. Trigger with "analyze slow queries", "optimize the database".

Coordinates swarm-style parallel data gathering across APIs, websites, and system sources, then aggregates findings into a structured research report. Use when pulling data from multiple sources or validating link collections. Trigger with \"gather data from these APIs\", \"research and synthesize this topic\".

Generate trading signals from technical indicators

Scores YouTube video ideas against search demand, competition level, trend direction, and audience fit to produce ranked opportunity assessments. Use when deciding which video ideas to prioritize. Trigger with "validate video ideas", "score content ideas".

> Analyze query patterns and recommend optimal database indexes

Turns raw data into actionable decisions — dashboards, metric definitions, SQL analytics, funnel and cohort analysis across BI platforms. Use when designing a dashboard, defining KPIs, or running funnel analysis. Trigger with \"design a dashboard\", \"analyze our funnel\".

Owns the measurement layer — North Star definition, input metrics trees, A/B test specs, funnel and cohort analysis that drive product decisions. Use when defining what to track, diagnosing a funnel, or designing an experiment. Trigger with \"define our North Star metric\", \"design an A/B test\".

Maintains rolling 90-day analytics baselines, learned seasonal patterns, and anomaly history so specialist agents never start cold. Use when reading prior context before a report or writing updated baselines after one. Trigger with \"load analytics context\", \"update analytics baselines\".

Analyze blockchain mempools for MEV opportunities, sandwich attack patterns, pending large transfers, and gas price optimization across Ethereum, BSC, and Arbitrum. Use when detecting front-running risk, profiling pending transactions, or researching block builder behavior. Trigger with \"analyze mempool\", \"detect MEV\".

Generate SEO-optimized metadata for YouTube, blogs, and social platforms...

> Monitor whale transactions in real-time with market impact analysis and...

Design efficient NoSQL data models for MongoDB, DynamoDB, and Cassandra — applying embed-vs-reference, access-pattern-first, sharding key, and index strategies. Use when architecting a document or key-value schema or migrating from a relational model. Trigger with \"design NoSQL schema\", \"model for MongoDB\".

Cryptocurrency market analysis using OpenBB - price data, on-chain metrics,...

Comprehensive equity analysis using OpenBB - historical prices,...

Macroeconomic analysis using OpenBB - GDP, inflation, interest rates,...

Options analysis using OpenBB - chain data, Greeks, implied volatility,...

Portfolio analysis and optimization using OpenBB - performance tracking,...

AI-powered investment research using OpenBB - comprehensive analysis, thesis...