Skill UI

A comprehensive guide to building modern, high-performance full-stack applications using Next.js 14+ and the App Router. Covers advanced concepts including React Server Components (RSC), Server Actions, optimized data fetching with caching, implementing robust SEO via generateMetadata, and best practices for deployment and performance tuning (Vercel).

A comprehensive guide for optimizing Obsidian plugin performance, especially when dealing with large knowledge vaults (10,000+ files). Learn advanced techniques such as profiling bottlenecks with DevTools, implementing lazy initialization to speed up startup, processing files in manageable batches with UI yielding, and utilizing LRU caches for bounded memory management. Essential for creating stable, high-performance plugins.

This guide provides comprehensive strategies for optimizing API interactions with OpenEvidence. It covers implementing robust caching mechanisms (TTL management), efficient batch retrieval of citations, connection pooling, and handling rate limits. By applying these techniques, users can significantly reduce query latency, ensuring smooth system performance even when handling complex multi-condition queries or large citation batches.

This skill provides comprehensive best practices and Python code examples for optimizing API calls to Large Language Models (LLMs) via OpenRouter. It covers benchmarking model latency, implementing streaming to achieve low Time-To-First-Token (TTFT), and processing requests concurrently using asynchronous programming (asyncio). Use this when developing real-time, high-throughput applications that require predictable and fast model responses.

Guides the user through configuring and tuning database connection pools across languages, from selecting pool sizes to setting timeouts and monitoring usage to boost application performance.

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 guide provides advanced architectural patterns to optimize interactions with the Perplexity Sonar API. By implementing smart model routing, query hashing with time-to-live (TTL) caching, streaming responses, and rate-limited parallel processing, developers can significantly reduce latency, improve overall throughput, and manage API costs. Ideal for integrating complex, research-intensive search-augmented applications.

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 comprehensive guide outlines advanced strategies for optimizing PostHog in production environments. Key techniques covered include implementing local feature flag evaluation to eliminate network latency, optimizing event batching for network efficiency, utilizing strategic event sampling, and writing efficient HogQL queries. Master these methods to dramatically improve data collection reliability and query speed.

Builds and optimizes production-ready React Native and Expo mobile apps, covering navigation hierarchies, native module setup, FlatList performance tuning, SafeArea/keyboard handling, and multi-platform testing to ensure smooth iOS and Android releases.