sql-optimization-patterns
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...
Discover data ai debugging skills, compare source repositories and read the instructions for each workflow.
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...
Use this skill when performing QA reviews of the Planted website (Astro frontend at localhost:4321), Admin Dashboard V2 (localhost:5175), or production sites (planted.com, admin.planted.com). Orchestrates visua...
Toolkit for interacting with and testing local web applications using Playwright. Supports verifying frontend functionality, debugging UI behavior, capturing browser screenshots, and viewing browser logs.
Creates actionable bug reports with reproduction steps. Use when documenting bugs, creating defect tickets, or improving existing bug reports.
Mobile-first responsive design specialist for SARAISE React/TypeScript/Tailwind applications. Provides guidance on breakpoints, fluid typography, flexible layouts, touch targets, and progressive enhancement. Us...
Automated Google Tag Manager debugging with visual monitoring, screenshot annotation, and MCP integration. Use when testing GTM configurations, verifying tag firing, debugging dataLayer events, validating conse...
Browser automation, testing, and debugging using Chrome DevTools. Use when users want to take screenshots, test websites, debug UI, inspect network requests, check console errors, or automate browser interactio...
Optimizes token usage and context management for large tasks, cleanup operations, multi-step workflows, code audits, and complex agent operations. Automatically triggers when handling cleanup commands, large co...
Caching, Web Vitals, and Full-Stack Optimization
Tracing (OTEL), Metrics (Prometheus), and Structured Logging
Sentry error tracking and monitoring patterns
Use for systematic debugging and root cause analysis with Codex. Triggers on "codex debug", "codex root cause", "have codex investigate this bug", "codex find the issue".
Use for systematic debugging and root cause analysis with both Codex and Gemini. Triggers on "council debug", "council root cause", "have council investigate this bug", "council find the issue".
Browser automation, debugging, and performance analysis using Puppeteer CLI scripts. Use for automating browsers, taking screenshots, analyzing performance, monitoring network traffic, web scraping, form automa...
AI-assisted development workflow with TDD, context management, and incremental implementation. Use when developing features with AI assistance, managing code context for AI tools, implementing features step-by-...
Use Gemini CLI for large codebase analysis when context limits are exceeded. Use `gemini -p` with @ syntax to include files/directories when analyzing entire codebases, comparing multiple large files, understan...
Write self-documenting code with minimal, helpful comments that explain logic rather than changes. Use this skill when adding comments to TypeScript files, writing JSDoc documentation, deciding whether code nee...
Performs comprehensive WordPress site speed and performance audits. Use when analyzing WordPress themes, plugins, or sites for performance optimization opportunities, checking image/video optimization, database...
Expert prompt engineer that transforms vague user requests into optimized, detailed prompts for AI coding agents. Focus is on efficiency - helping users get complete results in one go without follow-up prompts....
Debugging techniques for Python, JavaScript, and distributed systems. Activate for troubleshooting, error analysis, log investigation, and performance debugging.
Testing patterns including pytest, unittest, mocking, fixtures, and test-driven development. Activate for test writing, coverage analysis, TDD, and quality assurance tasks.
Expert .NET 10 Debugging Strategist using CLI-first diagnosis. Use when user encounters: - Bugs, errors, exceptions in .NET/C# applications - Performance issues (slow, high CPU, memory leaks) - Crashes, deadlo...
Generate CLAUDE.md project memory files by exploring codebases. Use when user asks to "generate memory", "create CLAUDE.md", "document this project", "understand this codebase", or starts work on a new/unfamili...
Comprehensive React Native screen analysis tool that systematically extracts every feature, component, interaction, and detail from existing screens. Use BEFORE recreating ANY screen to ensure 100% feature pari...
The default order uses GitHub repository stars from our indexed data. Stars belong to the source repository and may be shared by multiple skills. They indicate repository interest, not skill installs or an independent quality score.