Performance

A reference skill providing PostgreSQL best practices covering query optimization, schema design, indexing strategies, Row Level Security, and connection pooling. Based on Supabase guidelines, it serves as a quick lookup for common patterns like composite indexes, cursor pagination, and queue processing.

A comprehensive reference guide for modern frontend development with React and Next.js. Covers component composition patterns, custom hooks, state management with Context/Reducer, performance optimization techniques (memoization, code splitting, virtualization), form handling, error boundaries, animations with Framer Motion, and accessibility patterns for keyboard navigation and focus management.

A comprehensive reference guide for optimizing Apache Spark jobs. Covers partitioning strategies, join optimization (broadcast, sort-merge, bucket joins), caching patterns, memory configuration, shuffle reduction techniques, and data format optimization with practical PySpark code examples.

A comprehensive guide to profiling and optimizing Python code. Covers CPU and memory profiling tools (cProfile, memory_profiler, py-spy), optimization patterns like list comprehensions, caching with lru_cache, NumPy vectorization, and parallel processing with multiprocessing and asyncio.

This skill helps developers modernize React applications by providing comprehensive guidance on upgrading from React 16 to 18, migrating class components to functional components with hooks, and adopting concurrent features like Suspense and Transitions. It includes code examples, codemod commands, and migration checklists.

This skill teaches systematic debugging techniques using the scientific method approach. It covers debugging tools and techniques for JavaScript/TypeScript, Python, and Go, including profiler usage, memory leak detection, binary search debugging with git bisect, and best practices for tracking down elusive bugs in any codebase.

This skill teaches SQL optimization techniques including query execution plan analysis (EXPLAIN), indexing strategies (B-Tree, GIN, GiST, BRIN), and common optimization patterns. It covers eliminating N+1 queries, cursor-based pagination, aggregate optimization, materialized views, and table partitioning for PostgreSQL and MySQL databases.

This skill collection provides expert assistance for modern Python development. It includes specialized agents for Django, FastAPI, and general Python development, along with comprehensive documentation for async programming patterns, Python packaging with pyproject.toml, performance profiling and optimization, pytest testing strategies, and the fast uv package manager.

This skill provides detailed PostgreSQL performance optimization guidelines and best practices from Supabase. It covers query performance, connection pooling, Row-Level Security, schema design, and more with concrete SQL examples showing incorrect vs correct patterns.

This skill provides comprehensive React Native performance optimization guidelines from Callstack's 'Ultimate Guide to React Native Optimization'. It covers JavaScript/React optimizations (FPS, re-renders, animations), native performance (Turbo Modules, memory management), and bundling optimizations (tree shaking, code splitting) with practical code patterns and debugging commands.

This skill provides comprehensive guidelines for diagnosing and fixing UI animation performance problems. It covers rendering optimization rules across compositing, paint, and layout phases, with specific guidance for scroll-linked motion, blur effects, view transitions, and avoiding common performance pitfalls like layout thrashing.

This skill enables comprehensive website auditing using the squirrelscan CLI tool. It analyzes websites against 150+ rules covering SEO, performance, accessibility, security, and content quality, providing actionable recommendations and health scores. The skill supports iterative fix-and-reaudit workflows with LLM-optimized output formats.