Skill UI

Helps developers systematically optimize web performance by measuring key metrics, reducing bundle size, deferring scripts, optimizing images and fonts, and tuning caching and CSS for faster Time to Interactive and better Lighthouse scores.

This skill simulates an expert performance engineer capable of diagnosing complex bottlenecks across the entire technology stack. It covers modern observability techniques (OpenTelemetry, APM), advanced profiling (CPU, Memory, I/O), and sophisticated load testing strategies (k6, Chaos Engineering). Use this when optimizing scalability, reducing latency, improving throughput, or architecting highly reliable, performant distributed systems in cloud environments.

Guides engineers through bundle analysis, lazy loading, image optimization, caching headers, virtualized lists, and Core Web Vitals monitoring so web apps stay fast and scalable for production traffic.

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 toolkit designed to manage the complex data flow associated with Perplexity search workflows. This skill implements critical security measures, including PII sanitization in user queries, validates external citations for accuracy, optimizes performance via result caching with freshness policies, and manages conversation context to maintain coherence and reliability. Essential for building robust, compliance-aware AI applications.

This comprehensive checklist guides the deployment of Perplexity Sonar API integrations to a robust production environment. It covers critical aspects including API key management, robust code quality practices (retries, rate limiting), performance optimization (caching, streaming), detailed monitoring setup, and cost control strategies. Use this checklist when preparing for a major Perplexity feature launch or going live to production.

Provides PostgreSQL optimization advice covering index design, query plan inspection, partitioning, JSONB tweaks, connection pooling, and tuning checkpoints to stabilize OLTP workloads.

This skill provides comprehensive expertise for senior database administrators to optimize and manage PostgreSQL databases at an advanced level. Use it for deep query analysis via EXPLAIN ANALYZE, implementing advanced features like JSONB indexing, configuring streaming or logical replication, and maintaining database health through VACUUM tuning and monitoring pg_stat views. Ideal for building highly available, high-performance, and resilient system architectures.

A specialized, comprehensive workflow designed for optimizing PostgreSQL databases. It guides users through performance assessment, advanced query tuning (using EXPLAIN ANALYZE), defining optimal indexing strategies, fine-tuning configuration parameters (like shared_buffers), and setting up robust maintenance and monitoring practices for production environments.

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.