Tools

Use when writing BigQuery queries, optimizing query performance, analyzing execution plans, or avoiding common SQL gotchas. Covers parameterized queries, UDFs, scripting, window functions (QUALIFY, ROW_NUMBER, RANK, LEAD/LAG), JSON functions, ARRAY/STRUCT operations, BigQuery-specific features (EXCEPT, REPLACE, SAFE_*), CTE re-execution issues, NOT IN with NULLs, DML performance, Standard vs Legacy SQL, and performance best practices.

Check which Claude skills are loaded globally and project-level. Displays loaded skills by category (Hostinger, Anthropic, custom), counts, and helps troubleshoot missing skills.

Systematic debugging workflow enforcing 'The Iron Law': No fixes without root cause investigation first.

Set up custom Claude Code status line with Nerd Font icons, colors, git status, usage tracking, system info, and project context. NO EMOJIS - only Nerd Font icons and symbols. Use when configuring statusline, setting up status bar, or customizing Claude UI. Triggers with statusline, status bar, custom theme.

Professional design methodology for building modern, premium interfaces with client branding. Use for ALL client work and non-AICA projects. Applies glassforium logic, cinematic polish, and intentional design principles while adapting to client colors and brand identity. For Kelvin's personal AICA brand (black glass + gold), use the 'aica' skill instead.

Expert guidance for creating and working with marimo notebooks - reactive Python notebooks that can be executed as scripts and deployed as apps. Use when the user asks to create marimo notebooks, convert Jupyter notebooks to marimo, build interactive dashboards or data apps with marimo, work with marimo's reactive programming model, debug marimo notebooks, or needs help with marimo-specific features (cells, UI elements, reactivity, SQL integration, deploying apps, etc.).

Use the @steipete/oracle CLI to bundle a prompt plus the right files and get a second-model review (API or browser) for debugging, refactors, design checks, or cross-validation.

创建和配置 Claude Code 钩子以自定义代理行为。当用户需要以下操作时使用：(1) 创建新钩子，(2) 配置自动格式化、日志记录或通知，(3) 添加文件保护或自定义权限，(4) 设置工具执行前后的操作，(5) 询问钩子事件如 PreToolUse、PostToolUse、Notification 等。

Generate structured research reports with findings, comparisons, recommendations, and citations. Use when documenting investigation results or creating technical comparisons.This skill provides comprehensive research report templates:- Investigation findings with proper structure- Technology comparison tables- Best practices summaries- Citation and reference management- Executive summariesTriggers: "create report", "summarize findings", "compare technologies", "research report", "調査レポート", "技術比較", "ベストプラクティス"

Python project scaffolding and development with modern tooling. Use when creating new Python projects, setting up virtual environments, configuring dependencies, or working with Flask web applications. Triggers on mentions of Python setup, uv, Flask, pytest, or project initialization.

통합 문서 처리 스킬. PDF, DOCX, XLSX, PPTX 문서 분석/요약/변환. "문서 분석", "PDF 변환", "Excel 추출", "문서 요약" 요청 시 활성화됩니다.

GitHub Issue-based task execution workflow with project management. Use when user says "work on issue", "implement issue", "start issue", or "/issue-workflow {issue-url}". Includes project status management, plan mode investigation, and PR auto-linking.

Create and maintain GitHub Actions workflows in .github/workflows

Create and maintain Roslyn source generators for compile-time code generation. Use when building incremental generators, designing pipelines with ForAttributeWithMetadataName, creating marker attributes, implementing equatable models, testing generators, or debugging generator performance issues.

搜索并提炼业界/开源最佳实践的 SOP，强调可信来源、适用边界与可执行建议。

Generate comprehensive book marketing and launch materials for fiction ebooks. Use when authors need promotional content including emails, ad copy, retail descriptions, social media content, press kits, newsletter swap letters, or lead magnet outlines. Triggers include requests like "create launch materials," "generate book marketing content," "make promotional emails," or "build press kit for my book."

JavaScript project structure, package.json configuration, dependency management, and Maven integration standards for consistent project setup and builds

Scaffolds feature modules following feature-based architecture with colocation principle and 500 LOC file limit. Use when creating new features or refactoring large files into modular structure.

Master advanced TypeScript patterns, generics, and type system features.

Semantic image-text matching with CLIP and alternatives. Use for image search, zero-shot classification, similarity matching. NOT for counting objects, fine-grained classification (celebrities, car models), spatial reasoning, or compositional queries. Activate on "CLIP", "embeddings", "image similarity", "semantic search", "zero-shot classification", "image-text matching".