Research

PostgreSQL query optimization and performance tuning reference. Use when analyzing slow queries, interpreting EXPLAIN output, optimizing indexes, or troubleshooting database performance issues.

Create and manage Google Slides presentations. Load when user mentions 'google slides', 'slides', 'presentation', 'create presentation', 'add slide', or references creating/editing slide decks.

Daily journaling for mood, energy, and experiential tracking

Agent Skill: Systematic TYPO3 extension upgrades to newer LTS versions. Covers Extension Scanner, Rector, Fractor, PHPStan, and testing. Use when upgrading extensions to newer TYPO3 versions or fixing compatibility issues. By Netresearch.

Complete Figma design extraction for pixel-perfect implementation.Extracts design tokens, component specs, layouts, and responsive behavior systematically.Use when user provides Figma design:- Figma URL or file link provided- User mentions "Figma", "design file", "mockup", or "design system"- During /create-plan phase when design needs extraction- User says "extract from Figma" or references Figma linkExtract systematically:- Design tokens: ALL colors (hex + usage), typography (sizes, weights, line heights), spacing scale, border radius, shadows, opacity values- Components: ALL states (default, hover, active, focus, disabled, loading, error), ALL variants (size/style/intent), exact dimensions, spacing, visual properties- Layouts: page structure, grid systems (columns, gutters), component hierarchy- Responsive: mobile/tablet/desktop differences explicitly documented- Assets: icons (names, sizes), images (dimensions, alt text), illustrationsGoal: Extract ONCE completely during planning phase

Use when merging parallel worktrees back together after parallel implementation. Orchestrates systematic 3-way diff analysis, dependency-ordered merging, and intelligent synthesis of parallel work streams.

Review educational content against the Four Learning Design Pillars framework. Use when users want to evaluate course materials, lessons, tutorials, e-learning modules, or any instructional content for alignment with evidence-based learning design principles. Provides structured feedback with specific principle references (e.g., 1.1.1, 2.3.4) and actionable recommendations.

Enforces project documentation structure in docs/plans/ directories - research.md for facts, design.md for decisions, tasks.md for implementation, thoughts/ for explorations.

Generates a rigorous experiment design given a hypothesis. Use when asked to design experiments, plan experiments, create an experimental setup, or figure out how to test a research hypothesis. Covers controls, baselines, ablations, metrics, statistical tests, and compute estimates.

Professional technical documentation specialist that creates clear, comprehensive documentation including API references, user guides, READMEs, integration guides, and developer tutorials

Orchestrate multiple frontier LLMs (Claude, GPT-5.1, Gemini 3.0 Pro, Perplexity Sonar, Grok 4.1) for comprehensive research using LLM Council pattern with peer review and synthesis

AI-driven development planning skill that produces TDD-ready specifications using research-backed methodologies (Plan-then-Act, Reflexion, ToT/LATS, ReAct).USE THIS SKILL PROACTIVELY when:- User requests a feature implementation- User reports a bug that needs fixing- User asks for code refactoring- Task involves multiple files or components- Requirements need clarification before coding- You need to create a comprehensive development planThis skill implements the complete planning pipeline: repo analysis → test-first design → structured plan generation → self-critique → TDD handover specification.OUTPUT: Structured TDD Handover Spec (JSON + Markdown) ready for TDD agent consumption.

VaultCPA database schema reference with 50+ Prisma models, relationships, and query patterns. Use when working with database models, designing features, or understanding data structure.

Review, audit, and fix CLAUDE.md to ensure it meets quality standards.TRIGGERS - Use this skill when user says:- "review claude.md", "review the claude.md"- Any request to check CLAUDE.md quality or find issuesAlso use when:(1) Verifying CLAUDE.md references match actual project structure(2) Checking for stale or outdated content(3) Auditing formatting quality and consistency(4) CLAUDE.md exceeds 600 lines (MUST condense)(5) Analyzing individual section sizes and making them concise(6) Detecting content that duplicates skills in `.claude/skills/`This skill reports issues AND implements all fixes to bring CLAUDE.md to standard.

Product Management frameworks, methodologies, and best practices library. Provides PM knowledge including prioritization (RICE, MoSCoW), goal setting (OKR, SMART), customer research (JTBD, Personas), and product strategy. Use when needing PM methodology guidance or framework application.

Complete reference for all 35+ PubMed Search MCP tools. Triggers: 工具列表, all tools, 完整功能, tool reference, 有哪些工具

Use when encountering any bug, test failure, or unexpected behavior, before proposing fixes - four-phase framework (root cause investigation, pattern analysis, hypothesis testing, implementation) that ensures understanding before attempting solutions

Extract text from PDF files with intelligent chunking and metadata preservation. Use for processing technical documents, standards libraries, research papers, or any PDF collection requiring text extraction.

Pattern for client components calling server actions to set cookies in Next.js. Covers the two-file pattern of a client component with user interaction (onClick, form submission) that calls a server action to modify cookies. Use when building features like authentication, preferences, or session management where client-side triggers need to set/modify server-side cookies.

Conversational brainstorming partner for capturing fleeting thoughts, reading notes,papers, videos, and online discoveries. Casual/collegial voice, one question at a time,routes captures to appropriate vault locations.