Skill UI

A comprehensive guide maintained by Supabase for optimizing Postgres performance. It provides critical rules and best practices across query performance, schema design, connection management, and security (including RLS). Use this skill when writing, reviewing, or optimizing complex SQL queries, database schemas, or configurations to ensure optimal database health and performance.

Provides prioritized performance optimization recommendations across frontend, backend, and infrastructure, offering bottleneck analysis, impact estimates, and phased implementation roadmaps when users request speed improvements or reviews.

Expert skill for writing, reviewing, and debugging idiomatic Rust code, focusing on memory safety and zero-cost abstractions. Specializes in advanced concepts like ownership patterns, explicit lifetime management, trait-based API design, and building concurrent async applications using Tokio. Use this when developing high-performance, reliable, systems-level software in Rust.

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.

Supabase-curated Postgres best practices that prioritize query, schema, connection, security, and monitoring rules to guide writing, reviewing, or tuning SQL plus database configuration for better performance.

A comprehensive skill guide for building, reviewing, and optimizing SwiftUI code. It covers modern best practices for state management, optimal view composition, performance optimization, and adopting the latest Apple APIs, including iOS 26+ Liquid Glass features. Use this when ensuring code quality, refactoring complex views, or adhering to strict Apple design guidelines.

This comprehensive workflow provides a complete cycle of quality assurance for software development. It covers every stage from defining the test strategy (TDD, Unit Testing) through integration, E2E testing, browser automation, performance profiling, security scanning, and final code review. Use this when setting up robust testing infrastructure or ensuring production-ready software quality.

This comprehensive guide catalogs common anti-patterns and mistakes when deploying applications on Vercel. It covers critical architectural areas such as secret management (preventing key exposure), optimizing serverless function performance (cold start, timeouts), adhering to Edge Runtime standards, and resolving configuration errors. Use this skill for code reviews, security audits, and onboarding new developers to ensure best deployment practices.

Guidelines for reviewing UI code against web interface best practices, covering accessibility, performance, responsive design, component patterns, CSS practices, security, and internationalization during audits or UX evaluations.

Runs a Lighthouse-based audit that combines performance, accessibility, SEO, and best-practice checks, categorizes issues by severity, and recommends targeted fixes for requested site reviews.

Guides writing high-quality YARA-X detection rules for malware hunting, covering naming conventions, string selection, performance tuning, migrations from legacy YARA, and reducing false positives when authoring, reviewing, or debugging signatures.

A specialized review tool for identifying critical performance bottlenecks within Django applications. It focuses on validating issues such as N+1 queries, unbounded querysets, missing database indexes, and write loops. Use this when you suspect database slowdowns or memory exhaustion due to inefficient ORM usage, ensuring findings are provable and actionable.