Skill UI

This guide provides robust patterns for managing external API rate limits, specifically detailing the implementation of exponential backoff, request queuing, and throttling strategies. It uses TypeScript examples to ensure stable and reliable API interactions. Use this when building production-grade applications that require frequent, high-volume calls to rate-limited services, such as language learning APIs.

This guide provides production-ready patterns for integrating the Speak language learning API. It covers managing conversation sessions, performing pronunciation assessment, preprocessing audio files using ffmpeg, implementing robust retry mechanisms (with backoff), and tracking user learning progress. Use this when developing a full-featured, high-reliability language learning application or troubleshooting complex API integrations.

Guidance for Spring Boot TDD covering JUnit 5, Mockito, MockMvc, Testcontainers, JaCoCo and coverage enforcement, ideal for adding endpoints, fixing bugs, or refactoring with high confidence.

This skill provides systematic patterns and best practices for transforming slow database queries into high-performance operations. It covers techniques like proper indexing, query plan analysis (e.g., using EXPLAIN), schema design improvements, and resolving common issues like N+1 query problems. Use it to debug performance bottlenecks, reduce database load, and ensure scalable application backends.

Guides how to craft detailed prompts for Google Stitch so it generates high-quality web and mobile UI designs, covering specificity, visual style, multi-screen structure, platform targeting, and iterative refinement.

A workflow for executing implementation plans by spinning up a fresh subagent for each task and enforcing consecutive spec compliance and code quality reviews so the session stays focused and high-quality without manual context switches.

This module provides the essential three pillars for building robust full-stack applications on Supabase. It implements comprehensive user authentication (including OAuth, email/password, and session management), secure file storage (uploading, downloading, and managing signed URLs), and real-time data subscriptions (listening to Postgres changes, presence, and broadcasts). It is crucial for developing modern, live-updating, and highly secure web services.

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.

Master advanced techniques for scaling Supabase projects to handle high production load. This skill covers six critical layers: implementing read replicas for analytics, optimizing connectivity using connection pooling (Supavisor), upgrading compute resources, utilizing CDN caching for Storage, deploying Edge Functions regionally, and performing database table partitioning. Ideal for engineers preparing for traffic spikes or optimizing large-scale database architectures.

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.

A comprehensive guide for managing resource limits and quotas across all Supabase services (API, Auth, Storage, Realtime, Edge Functions). Learn how to understand tier-specific limits, configure connection pooling using Supavisor (Transaction/Session mode), and implement robust retry logic with exponential backoff to gracefully handle 429 rate limiting errors, ensuring high application reliability.

Master advanced techniques for building fault-tolerant applications integrated with Supabase. This guide implements critical resilience patterns, including circuit breakers, offline queuing (using IndexedDB), graceful degradation, exponential backoff retries, and dual-write strategies. Use this skill to handle network outages, API failures, and transient errors, ensuring your application remains highly available and reliable in production environments.