Skill UI

This skill provides systematic patterns and best practices for transforming slow database queries into high-performance operations. It covers techniques like proper indexing, query plan analysis (e.g., using EXPLAIN), schema design improvements, and resolving common issues like N+1 query problems. Use it to debug performance bottlenecks, reduce database load, and ensure scalable application backends.

This skill provides a structured approach to systematically identify security threats by applying the STRIDE methodology (Spoofing, Tampering, Repudiation, Information Disclosure, Denial of Service, Elevation of Privilege). It is crucial for conducting thorough threat modeling sessions, analyzing system architectures, reviewing security design decisions, and creating robust security documentation for compliance and auditing purposes.

This tool collects a comprehensive, redacted diagnostic bundle from a Supabase project. It systematically tests connectivity, authentication (Auth), Realtime capabilities, Storage buckets, and Row-Level Security (RLS) policies. The resulting archive is designed for sharing with support teams to accelerate troubleshooting of complex issues like connection failures or misconfigurations.

This comprehensive guide provides systematic methods to optimize Supabase query and database performance. Techniques cover PostgreSQL indexing (basic, composite, partial), using EXPLAIN ANALYZE for query plan analysis, optimizing client calls (column selection, pagination), and managing infrastructure resources like connection pooling. Use this when facing slow queries, high latency, or preparing a project for production-scale traffic.

A disciplined debugging ritual that forces you to investigate errors, reproduce issues, and analyze patterns before proposing fixes, ensuring root causes are understood across multi-component systems and minimizing risky guesswork under pressure.

This skill guides developers through advanced, safe, and systematic code refactoring using Test-Driven Development (TDD) principles. It provides a comprehensive workflow encompassing pre-assessment, detecting code smells, applying major design patterns (SOLID, Factory, Strategy), optimizing performance, and ensuring safety through rigorous, incremental testing. Use this when improving code structure, restructuring large components, or updating legacy systems while guaranteeing functional integrity and maintainability.

This expert skill specializes in guiding comprehensive GitHub issue resolution. It covers systematic bug investigation, feature implementation, and collaborative development workflows. Expertise includes issue triage, root cause analysis, test-driven development, and professional pull request management, ensuring vague reports are transformed into production-ready code following modern CI/CD practices.

This skill provides a systematic, multi-step approach to identify and resolve all failing unit tests within a codebase. It guides the user through smart error grouping (e.g., grouping by ImportError or AttributeError), prioritizing fixes from infrastructure to business logic, and ensuring thorough verification to prevent regressions. Ideal for use after major refactoring, debugging CI/CD failures, or when explicitly tasked with making the test suite pass.

An expert specialist for rigorous visual validation, focusing on UI testing, design system compliance, and WCAG accessibility verification. This skill systematically analyzes visual evidence for cross-platform consistency, pixel-perfect accuracy, and adherence to modern design standards, utilizing principles from visual regression testing and comprehensive QA methodologies.

A comprehensive guide for diagnosing difficult and intermittent Vercel deployment issues. Covers advanced topics such as cold start analysis, edge function crashes, region-specific behavior isolation, function bundle optimization, and concurrency throttling. Use this when standard logging fails and systematic, deep-dive debugging is required for production stability.

This comprehensive workflow guides users through a multi-phase process for assessing web application security. It is designed to systematically test for common vulnerabilities listed in the OWASP Top 10, including SQL injection, XSS, broken authentication, and access control issues. Ideal for professional penetration testing, security auditing, and bug bounty hunting.

Systematic Windows privilege escalation guide covering enumeration, credential harvesting, service abuse, token impersonation, kernel exploits and configuration flaws to elevate from standard user to Administrator/SYSTEM during pentests.