Development

Master SQL query optimization, indexing strategies, and EXPLAIN analysis to dramatically improve database performance and eliminate slow queries. Use when debugging slow queries, designing database schemas, or optimizing application performance.

WHEN: General Python code review, PEP8 compliance, type hints, Pythonic patternsWHAT: PEP8/style check + Type hint validation + Pythonic idioms + Error handling + DocumentationWHEN NOT: FastAPI → fastapi-reviewer, Django → django-reviewer, Data science → python-data-reviewer

Build embeddable chatbot widgets for web applications. Use when creating chat UIs, iframe embeds, or widget-based AI interfaces.

Use when creating, testing, iterating, or managing Claude Code skills. Handles skill scaffolding, git versioning, symlink management, auto-discovery testing, and quality assurance. Triggered by requests to create new skills, improve existing skills, test skill loading, or manage skill infrastructure.

Set up pre-commit hooks and GitHub Actions workflows for testing, linting, security scanning, releases, and deployments. Supports Python, Node.js, Go, Rust, and multi-language projects.

WCM tech stack - Python, pandas, Stata, clinical data

Scaffold and conventions to create a new UI component following project patterns (no Shadow DOM, static stylesheet registration, pixEngine templates). Use when adding a new custom element to the app.

Complete TinaCMS skill for building content-heavy sites with Git-backed CMS.Use this skill when setting up blogs, documentation sites, or marketing sitesthat require visual editing and content management for non-technical users.Supports Next.js (App Router + Pages Router), Vite + React, Astro, andframework-agnostic setups. Prevents 9+ common errors including ESbuild compilationissues, module resolution problems, schema configuration errors, Docker bindingissues, and deployment problems. Self-hosting options for Cloudflare Workers,Vercel Functions, and Netlify Functions included.Keywords: TinaCMS, Tina CMS, Git-backed CMS, visual editing CMS, content management, Next.js CMS, App Router TinaCMS, Pages Router TinaCMS, Vite React TinaCMS, Astro TinaCMS, framework-agnostic CMS, TinaCloud, self-hosted TinaCMS, blog CMS, documentation site CMS, marketing site CMS, GraphQL CMS, tina schema, tina collections, tina templates, tinacli, @tinacms/cli, ESbuild compilation error, module resolution tina, schema conf

Manages, consolidates, and optimizes project documentation following research-backed docs-as-code principles. Use this skill when documentation becomes scattered, duplicated, or contradictory after development work. Also use when user explicitly requests "tidy docs", "consolidate documentation", "clean up docs", or "organize documentation". Applies Diátaxis framework, enforces YAML front matter, resolves conflicts using evidence-based rules, and generates machine-readable manifest for AI agents. NEVER modifies CLAUDE.md.

Suite of tools for creating elaborate, multi-component claude.ai HTML artifacts using modern frontend web technologies (React, Tailwind CSS, shadcn/ui). Use for complex artifacts requiring state management, routing, or shadcn/ui components - not for simple single-file HTML/JSX artifacts.

Garante padrões de código HTML limpo, semântico e consistente. Use quando criar ou modificar arquivos HTML, estruturar páginas, ou o usuário mencionar HTML, tags, atributos, ou estrutura de código.

Send WhatsApp messages to other people or search/sync WhatsApp history via the wacli CLI (not for normal user chats).

본 스킬은 Flutter 프레임워크로 앱을 개발하는 데 반드시 따라야 하는 UI/UX 디자인, 상태관리, 네트워킹, API 연동에 관한 가이드라인 제공합니다. 본 스킬은 선택적인 정보를 제공하는 것이 아니라 Flutter 앱 개발에 필수적인 지침을 제공하며 반드시 준수해야 할 사항들을 제공합니다. 개발자가 디자인, UI, UX, 디자인 효과, 상태관리, 라우팅, 네트워킹, API 연동에 관한 요청, 코믹디자인, Comic 관련 요청, 채팅, FCM, 푸시 알림, 메시지, 알림에 관한 요청이 있을 때 반드시 본 스킬을 사용해서 본 스킬이 제공하는 대로 작업을 수행해야 합니다. 각 스킬 문서에의 상단에는 반드시 따라야 할 Workflow 가 있습니다. 반드시 그 Workflow 를 따라야 합니다. (project)

Implements structured logging and observability with Axiom for serverless applications. Use when adding logging, tracing, and Web Vitals monitoring to Next.js and Vercel applications.

Deployment and DevOps for EFT-Tracker using Coolify, Docker, and Nixpacks. Covers 3-tier validation, pre-push hooks, and production deployment. Activates when user mentions: deploy, deployment, Docker, Coolify, production, staging, nixpacks, build, CI/CD, pre-push, webhook.

DEPRECATED umbrella Skill (backward compatibility). Use only for cross-cutting orchestration across multiple WebF app tasks when a request spans several capabilities (dev loop + debugging + testing + release). Prefer focused openwebf-app-* Skills.

This skill should be used when orchestrating rich human-in-the-loop question flows, building layered AskUserQuestion calls that respond to context (codebase, CLI tools, prior answers). Triggers include "ask me questions", "help me think through", "what should we consider", or complex tasks benefiting from interactive clarification.

iOS/SwiftUIアプリのデザインシステム・スタイルガイドを構築するスキル。カラーパレット、タイポグラフィ、スペーシング、コンポーネントスタイルをSwiftコードとして生成。使用シーン：(1)「スタイルガイドを作って」「デザインシステムを構築して」などの新規作成リクエスト (2)「既存のスタイルを分析して」「色やフォントを整理して」などの既存コード分析リクエスト (3) UI実装時にスタイル定義の一貫性が必要な場合

WHEN: Kotlin Multiplatform (KMP) project review, expect/actual patterns, shared module structure, iOS interopWHAT: Module structure analysis + expect/actual validation + platform separation + iOS/Android interop + dependency managementWHEN NOT: Android UI → kotlin-android-reviewer, Server → kotlin-spring-reviewer

Use when planning refactoring priorities, investigating recurring bugs, identifying which files cause the most bugs, or determining problem areas to fix - identifies high-risk files by combining git change frequency with code complexity using research-backed formula (4-9x defect rates)