Data Science

Build or update a code graph index for C#/.NET repositories using ragsharp-graph.Triggers: build index, update index, refresh index, code graph, dependency graph, static analysis, Roslyn, line numbers.

Comprehensive data analysis skill for exploratory data analysis (EDA), data cleaning, visualization, and statistical analysis. Use when asked to perform EDA, analyze datasets, clean/prepare data, create visualizations, or conduct statistical analysis. Triggers include phrases like "perform an initial EDA", "prepare this data for analysis", "analyze this dataset", "clean this data", "explore this data", or "create a visualization". Outputs are formatted for TAG brand guidelines with educational explanations throughout.

Intelligent POC-to-production code extraction with architectural awareness. Analyzes dependencies, adapts patterns, makes extraction strategy decisions (copy/adapt/rewrite), maintains system coherence. Performs pre-extraction analysis, transformation reasoning, quality gate enforcement, evidence-based commits. Use when extracting code requires understanding architecture, adapting patterns, threading parameters, or maintaining coherence across modules. Triggers on understand and extract, analyze dependencies, adapt pattern, extraction strategy, architectural extraction, intelligent migration.

Analyze and optimize database performance through index analysis and query profiling. Identify missing/unused indexes, interpret EXPLAIN plans, find performance bottlenecks, and recommend optimization strategies. Use when optimizing slow queries, analyzing database workloads, improving query execution speed, or managing database indexes.

Comprehensive code review assistant that analyzes code for security vulnerabilities, performance issues, and code quality. Use when reviewing pull requests, conducting code audits, or analyzing code changes. Supports Python, JavaScript/TypeScript, and general code patterns. Includes automated analysis scripts and structured checklists.

Initial reconnaissance on binaries including checksec, file analysis, strings, and symbols. First step for any new target.

R 4.4+ development specialist covering tidyverse, ggplot2, Shiny, and data science patterns. Use when developing data analysis pipelines, visualizations, or Shiny applications.

Enterprise code quality orchestrator with TRUST 5 validation, proactive analysis, and automated best practices enforcement

Investment intelligence with power structure awareness. Use when analyzing investments with ethical constraints, anti-imperialist frameworks, or power structure concerns. Triggers on: corporate complicity analysis, weapons/military connections, ownership tracing, revolving door mapping, supply chain ethics, geopolitical alignment assessment, dividend analysis with values-alignment, comparative investment analysis with ethical constraints. Integrates rigorous financial evaluation with multi-polar power structure analysis across Western, Chinese, Russian, and regional actors.

Master SQL query optimization, indexing strategies, and EXPLAIN analysis for Supabase/PostgreSQL to dramatically improve database performance. Includes PostGIS spatial optimization, RLS performance, and Supabase-specific patterns. Use when debugging slow queries, designing database schemas, optimizing RPC functions, or improving application performance.

Development skill for CaseMark's Smart Redaction Tool - an intelligent document redaction application with two-pass PII detection combining regex patterns and AI-powered semantic analysis. Built with Next.js 14, pdf.js/pdf-lib, and Case.dev LLMs. Use this skill when: (1) Working on the redaction-tool codebase, (2) Adding or modifying regex patterns, (3) Implementing AI detection features, (4) Building PDF export functionality, or (5) Adding new PII types.

Comprehensive toolkit for fetching, searching, analyzing, and monitoring Hacker News content. Use when Claude needs to interact with Hacker News for (1) Fetching top/new/best/ask/show/job stories, (2) Searching for specific topics or keywords, (3) Monitoring specific users or tracking their activity, (4) Analyzing trending topics and patterns, (5) Getting story details, comments, or user profiles, or (6) Any other task involving Hacker News data retrieval or analysis.

Presentation creation, editing, and analysis. When Claude needs to work with presentations (.pptx files) for: (1) Creating new presentations, (2) Modifying or editing content, (3) Working with layouts, (4) Adding comments or speaker notes, or any other presentation tasks

ICT-based MNQ futures trading analysis system for MFFU prop firm evaluation. Use when user provides market data (PDH, PDL, FVG levels, liquidity sweeps) and asks for trade analysis, entry/exit points, or bias confirmation. Triggers on keywords like "trade setup", "NQ analysis", "entry", "SL", "TP", "bias", "liquidity sweep", "FVG", "order block", "ICT", "MMXM", "MMBM", "MMSM", "market maker model", "smart money reversal", "SMR".

Diagnoses and debugs A2A agent communication issues including agent status, message routing, transport connectivity, and log analysis. Use when agents aren't responding, messages aren't being delivered, routing is incorrect, or when debugging orchestrator, coder-agent, tester-agent communication problems.

Generates sonar-project.properties for SonarQube code quality analysis and coverage reporting. Auto-detects test framework (Jest/Vitest) and configures coverage paths.

WHEN: Deep AI-powered code analysis, multi-model code review, security scanning with Codex and GeminiWHAT: Comprehensive code review using external AI models with severity-based findings, deduplication, and secret detectionWHEN NOT: Simple lint checks -> code-reviewer, Quick security only -> security-scanner, Style formatting -> code-quality-checker

Use this skill for the requests related to the power plants in USA; it provides a way to get power plants as a GeoDataframe in GeoPandas

Performs keyword research, competitive SERP analysis, and generates article outlines optimized for AI Overviews. Use before drafting any article. Focuses on long-tail keywords and semantic structure for LLM digestibility.

Apply SQL optimization patterns including index usage, query rewriting, JOIN optimization, and window functions. Use when improving query performance or analyzing slow queries.This skill provides comprehensive SQL optimization patterns and best practices:- N+1 query elimination- Index optimization strategies- JOIN vs subquery performance- Window functions for complex aggregations- Query execution plan analysisTriggers: "optimize SQL", "slow query", "improve performance", "SQL最適化", "クエリ改善", "パフォーマンス向上"