Data Science

SQL Specialist for BigQuery SQL statement implementation including ad-hoc analysis, materialized views, and data preparation. Use when generating or modifying BigQuery SQL code.

Export query results to various formats (CSV, JSON, Excel, Markdown tables) with proper formatting and headers. Use when saving analysis results to files.This skill provides data export utilities for multiple formats:- CSV: Comma-separated with headers, customizable delimiters- JSON: Structured data with pretty-print option- Excel: Multiple sheets, cell formatting, formulas- Markdown: Tables for documentationTriggers: "export data", "save results", "output CSV", "output JSON", "output Excel", "データ出力", "結果保存", "エクスポート"

Run PHPStan static analysis and fix errors using intelligent agent delegation. Use when user requests to:- Run static analysis- Fix PHPStan errors- Check code quality- Analyze type errorsDelegates to runner agent (haiku) for execution and fixer agent (sonnet) for fixes.Automatically cycles between run and fix until analysis passes or human intervention needed.

Generate comprehensive tests following three-layer pyramid - unit (Vitest), integration (real database), E2E (Playwright). Use when user needs "add tests", "improve coverage", "test [feature]", "write E2E tests", "generate test factory", or mentions testing auth, forms, database, AI features, visualizations, real-time collaboration, performance, accessibility, or import/export. Provides templates and patterns for 80%+ coverage including AI mocking, chart testing, WebSocket testing, and Page Object Models. Do NOT use when building new features (use worldcrafter-feature-builder which includes tests), database-only changes (use worldcrafter-database-setup), or simple routes (use worldcrafter-route-creator).

Comprehensive statistical analysis toolkit for research. Conduct hypothesis tests (t-test, ANOVA, chi-square), regression, correlation, Bayesian stats, power analysis, assumption checks, and APA reporting. Use when the user asks about statistics, needs help analyzing data, or when writing methods sections that include statistical approaches.

Complete Calibre library management - add/remove books, convert PDF to EPUB, metadata editing, library analysis, cleanup, and e-reader sync (Sony PRS-T1). Use for any ebook or Calibre operation.

EDA, dashboards, Matplotlib, Seaborn, Plotly, and BI tools. Use for creating visualizations, exploratory analysis, or dashboards.

Expert in visualizing and explaining braid theory, knot mathematics, and topological concepts for educational purposes. Use for creating interactive visualizations, explainer cards, step-wise animations, and translating abstract algebra into intuitive understanding. Activate on keywords: braid theory, knot visualization, σ notation, crossing diagrams, Yang-Baxter, topological education. NOT for general math tutoring, pure knot invariant computation, or non-educational knot theory research.

Documentation of available data science libraries (scipy, numpy, pandas, sklearn) and best practices for statistical analysis, regression modeling, and organizing analysis scripts. **CRITICAL:** All analysis scripts MUST be placed in reports/{topic}/scripts/, NOT in root scripts/ directory.

This skill should be used when the user asks to "analyze data", "build a model", "explore this dataset", "run analysis", or needs a structured data science workflow. Orchestrates brainstorm, plan, implement, review, and verify phases with output-first verification.

Weighted pandas DataFrames for survey microdata analysis - inequality, poverty, and distributional calculations

A skill for analyzing data using Python (pandas) and generating professional visualizations (matplotlib/seaborn).

Fetch transcripts and subtitles from YouTube videos using youtube-transcript-api. Use when extracting video transcripts, listing available languages, translating captions, or processing YouTube content for summarization or analysis.

Marketing attribution modeling and analysis

Guides and code for creating, analyzing, and formatting spreadsheets. Use this skill to work with Excel files programmatically and apply data analysis techniques.

AI image generation using Google's Nano Banana Pro (Gemini 3 Pro Image).Generates research visualizations, lab graphics, hero banners, and academic imagery.USE WHEN: user says "generate image", "create visual", "nano banana","research graphic", "hero image", "AI image for".

Comprehensive xlsx sheet creation, editing, and analysis with support for formulas, formatting, data analysis, and visualization. When Claude needs to work with xlsx sheets (.xlsx, .xlsm, .csv, .tsv, etc) for: (1) Creating new xlsx sheets with formulas and formatting, (2) Reading or analyzing data, (3) Modify existing xlsx sheets while preserving formulas, (4) Data analysis and visualization in xlsx sheets, or (5) Recalculating formulas

Automated hypothesis generation and testing using large language models. Use this skill when generating scientific hypotheses from datasets, combining literature insights with empirical data, testing hypotheses against observational data, or conducting systematic hypothesis exploration for research discovery in domains like deception detection, AI content detection, mental health analysis, or other empirical research tasks.

Execute SQL queries on Danmarks Statistik data stored in DuckDB. Use when user needs specific data analysis, filtering, aggregation, or joins. Also includes table summary functionality.

Fundamental analysis specialist. Analyzes company financials, earnings, valuation multiples, and competitive positioning to assess intrinsic value and long-term investment potential.