Skill UI

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.

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.

A comprehensive guide for optimizing application performance on Replit. Covers critical areas such as reducing cold start times, managing memory consumption, optimizing Nix environment dependencies, accelerating build processes, and ensuring database connection efficiency. Use this guide when facing slow startups, resource limits, or deployment slowdowns.

A comprehensive guide on optimizing Sentry observability costs. Learn techniques such as SDK-level error sampling, fine-grained performance tracing control, and event filtering using the `beforeSend` hook. These methods significantly reduce the volume of error and transaction data sent, allowing users to manage quotas and prevent overage charges without losing visibility into mission-critical production errors.

A comprehensive guide to optimizing Sentry's performance monitoring pipeline. Learn how to minimize SDK overhead and event costs while maximizing signal quality. Techniques covered include replacing static sampling rates with dynamic `tracesSampler`, configuring profiling rates, preventing cardinality explosion through proper transaction naming, and implementing custom measurements for deeper business logic visibility. Essential for high-traffic, production applications.

Guides building, tuning, and validating production Apache Spark jobs, covering DataFrame/RDD choices, partitioning, broadcast joins, skew handling, caching, and cluster configuration for big data pipelines.

A comprehensive guide for optimizing costs when integrating the Speak API. This skill covers usage monitoring, selecting optimal API tiers, and implementing efficient audio processing pipelines. It is essential for developers managing language learning platform operations to ensure cost efficiency while maintaining high performance.

This guide provides a comprehensive method for optimizing the latency and reliability of the Speak API integration. It covers techniques such as audio preprocessing, implementing response caching, and managing connection pooling. Use this skill when establishing a production-grade, low-latency language learning platform or managing high-volume API operations.

A comprehensive guide for deep PostgreSQL diagnostics, designed for advanced troubleshooting when standard methods fail. Covers using pg_stat_statements for identifying slow queries, analyzing lock contention with pg_locks, detecting connection leaks, debugging RLS policy conflicts, and profiling Edge Function cold starts. Essential for performance regression investigation and escalating issues to support.

This guide provides comprehensive, actionable methods to audit and significantly reduce Supabase operational costs. It covers advanced database tuning (vacuuming, index cleanup, bloat management), efficient storage lifecycle management, connection pooling strategies, and optimal plan selection. Use this when analyzing high billing reports, identifying resource waste, or implementing robust cost-saving measures in a cloud environment.

This comprehensive guide provides systematic methods to optimize Supabase query and database performance. Techniques cover PostgreSQL indexing (basic, composite, partial), using EXPLAIN ANALYZE for query plan analysis, optimizing client calls (column selection, pagination), and managing infrastructure resources like connection pooling. Use this when facing slow queries, high latency, or preparing a project for production-scale traffic.

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.