Skill UI

A comprehensive guide covering the entire web performance optimization lifecycle. Learn how to measure Core Web Vitals (LCP, INP, CLS), identify bottlenecks using specialized tools like Lighthouse and DevTools, and apply advanced techniques such as code splitting, lazy loading, and memory leak fixes to ensure fast, stable, and high-quality user experiences.

Automates load, stress, spike, and endurance tests through the performance-test-suite plugin, collecting response time, throughput, and error-rate metrics to spot CPU/memory/database/network bottlenecks and deliver graphs plus optimization guidance.

A comprehensive specialist that combines automated static analysis (SonarQube, CodeQL, Semgrep) with advanced AI capabilities. This tool performs multi-layered code reviews assessing security vulnerabilities, performance bottlenecks, architectural coherence, and maintainability across various programming languages, integrating seamlessly into CI/CD pipelines.

This skill provides a comprehensive guide to PostgreSQL best practices and performance optimization, maintained by Supabase. It covers critical areas such as query tuning, schema design, connection management, security (RLS), and indexing. Use this guide when writing complex SQL, reviewing database architecture, or diagnosing performance bottlenecks to ensure robust and efficient database operations.

This skill performs deep, line-by-line scanning of an entire codebase to understand its architecture, patterns, and dependencies. It systematically identifies critical issues across security vulnerabilities (SQL injection, secrets), performance bottlenecks (N+1 queries, caching), architectural flaws, and code quality gaps. It then automatically refactors and fixes all identified issues, transforming the code into professional, production-grade, enterprise-level quality.

Profiles application performance by analyzing CPU usage, memory allocation, and execution time with the application-profiler plugin, then identifies bottlenecks and suggests code-level optimizations for faster execution.

A comprehensive guide for profiling, analyzing, and optimizing Python code. It addresses identifying performance bottlenecks related to CPU usage, excessive memory consumption, I/O operations, and slow data processing. Use this skill to improve application speed and efficiency in production environments.

This skill guides the setup of distributed tracing and performance monitoring using Sentry. It covers configuring the SDK (e.g., setting tracesSampleRate) to capture latency, identify performance bottlenecks, and trace requests across the entire application stack. It demonstrates how to create manual spans for business logic and utilizes profiling for deeper performance insights, ensuring comprehensive application observability.

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.

A comprehensive skill for optimizing complex SQL queries, designing robust database schemas, and troubleshooting performance bottlenecks across various dialects (PostgreSQL, MySQL, etc.). Use this when queries are slow, complex set-based logic is needed (CTEs, Window Functions), or when structuring/migrating a database schema. It provides detailed query plan analysis, advanced indexing strategies, and industry best practices.

A comprehensive guide detailing the most common and critical mistakes when developing with Supabase. Covers severe security issues (like exposing service role keys or missing RLS), data integrity failures, and performance bottlenecks (connection pooling, N+1 queries). Essential for code review, onboarding new developers, or auditing existing Supabase projects to ensure secure and robust applications.

Tracks and optimizes application response times using the response-time-tracker plugin, covering API endpoints, database queries, external calls, frontend rendering, and background jobs to highlight bottlenecks or SLO breaches.