DevOps

Expert PostgreSQL database development skill covering schema design, normalization, Alembic migrations, SQLAlchemy ORM patterns, query optimization, index strategies, JSONB for flexible data, and full-text search. Use when designing database schemas, creating migrations, optimizing queries, implementing full-text search, or working with PostgreSQL-specific features like JSONB.

This skill should be used when the user asks to "make a decision", "evaluate options", "choose between alternatives", "assess trade-offs", "rank criteria", or needs structured decision-making frameworks using ClearThought's decision_framework operation for multi-criteria analysis.

Designs digital experiences for ADHD brains using neuroscience research and UX principles. Expert in reducing cognitive load, time blindness solutions, dopamine-driven engagement, and compassionate design patterns. Activate on 'ADHD design', 'cognitive load', 'accessibility', 'neurodivergent UX', 'time blindness', 'dopamine-driven', 'executive function'. NOT for general accessibility (WCAG only), neurotypical UX design, or simple UI styling without ADHD context.

Runs tests and handles failures. Triggered when: test execution, verification, test failures, CI checks.

Provide local debugging scripts for Docker including build, run, and environment setup for development workflow.

Build single-file HTML tools following Simon Willison's patterns - self-contained HTML+JS+CSS applications optimized for LLM generation, no build step, CDN dependencies. Use when creating browser-based tools, utilities, or demos that should be (1) Self-contained in one HTML file, (2) Easy to distribute and host statically, (3) Quick to prototype with LLMs, (4) Client-side only with no server requirements. Ideal for data visualization, API explorers, format converters, debugging tools, and interactive demos.

Master systematic debugging techniques, profiling tools, and root cause analysis to efficiently track down bugs across any codebase or technology stack. Use when investigating bugs, performance issues, or unexpected behavior.

Install and configure the shadcn MCP server for Codex. Use when a user asks to enable shadcn/ui MCP tools, set up the shadcn MCP server in Codex, or troubleshoot shadcn MCP startup.

Create comprehensive, production-ready frontend implementation plans for any UI screen or feature. Use this skill when documenting how to build UI components, establishing design systems, planning component architecture, or creating technical specifications for frontend development. Works across frameworks (React, Vue, Angular, Svelte, etc.) and focuses on clear structure, reusable patterns, and maintainability.

Deterministic Etsy pricing calculator that respects fee structure and margin policies for POD products.

Research documentation and evidence synthesis framework for MYCURE healthcare products using HIGH/MEDIUM/LOW confidence grading, triangulation methodology, and rigorous citation standards. Auto-activates for research documentation, evidence grading, healthcare systems analysis, user research synthesis, market analysis, competitive research. Includes Philippine healthcare context (LGU health systems, FHISIS, PhilHealth).

Multi-specialist UI design and implementation team for cross-platform applications.Use when working on: (1) UI/UX design decisions - colors, layout, typography, accessibility,(2) Web implementation - HTML5, CSS, responsive design, (3) .NET desktop - WPF, WinUI 3, MAUI with XAML,(4) .NET web - Blazor Server/WASM/Hybrid components, (5) Python GUI - PyQt, Tkinter, Kivy, Streamlit.Triggers: UI design, color scheme, layout, component styling, accessibility, responsive design,XAML styling, Blazor components, CSS architecture, Python GUI, design system, design tokens.

Efficient PR creation with gh CLI - automated branch, commit, push, and pr-create. Use when user asks to create PR, open pull request, or invokes /create-pr.

Complete full-stack development with Astro (Islands Architecture), Tailwind CSS (utility-first styling), and CloudFlare Workers/D1/KV (edge computing and hybrid database). Strategic guidance plus practical implementation patterns for building fast, globally-distributed web applications.

Perform per-change code reviews for C# and Python with language-specific best practices.Use when asked about: code review, review this code, check my code, review PR, best practices,is this code good, code quality, review changes, review my changes.Also triggers automatically after significant code changes.NOT for: architectural assessments, system design reviews (use architecture-review skill instead).

Standards and templates for product vision, roadmap planning, and technology selection. Use when establishing product foundation or making strategic decisions.

PR quality checklist for ensuring comprehensive, well-documented pull requests. Use before submitting PRs to improve review efficiency and code quality.

Create consistent, high-quality educational programming exercises or tutorials following strict template guidelines. Use this skill whenever you need to create or refine a programming exercise or tutorial for your course. Automatically applies template structure, formatting rules, and quality verification.

Automate security testing, create reusable test suites, integrate with CI/CD, and measure security improvements over time.

Analyzes subagent usage patterns to determine when to delegate tasks, evaluates and improves existing subagent configurations, creates new custom subagents when needed, and identifies outdated subagent information. Use when deciding if a task should use a subagent, analyzing existing agents for effectiveness, recommending agent improvements, creating specialized agents for recurring patterns, or managing agent configurations. Optimizes Claude's subagent usage for performance, context preservation, and task specialization.