Skill UI

Expert in building and debugging comprehensive Shopify solutions. Specializes in theme development using Liquid, implementing headless commerce via the Storefront API, and developing custom Shopify applications (OAuth, webhooks). Proficient in modern e-commerce architectures, including Hydrogen/React frontends, managing Shopify CLI workflows, and optimizing performance for high-volume online stores.

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.

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.

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.

This expert guides you through building modern, high-performance applications across Apple platforms (iOS, macOS, watchOS, tvOS) using Swift 5.9+. It specializes in SwiftUI state management, Protocol-Oriented Architecture, concurrent programming with async/await and Actors, and implementing best practices for type safety and performance optimization. Ideal for developing complex, robust applications.

A comprehensive guide covering modern best practices for building high-performance, declarative user interfaces in SwiftUI. Topics include using the advanced @Observable framework for state management, achieving type-safe navigation with NavigationStack, effective view composition, and optimizing rendering performance for iOS and macOS platforms.

This skill provides deep, practical expertise in TypeScript and JavaScript, covering advanced type-level programming, performance optimization, and complex build toolchain management. It is ideal for architects building large-scale, highly performant, and type-safe corporate applications, including monorepo setup and intricate dependency resolution.

An expert guide for building high-performance, cross-platform games using Unity 6 LTS. This skill covers advanced C# programming (DOTS, Job System), modern rendering pipelines (URP/HDRP), comprehensive performance optimization (Profiling, Culling), advanced game architecture (ECS, MVC), and networked multiplayer implementation. Ideal for professional game developers tackling complex, large-scale projects.

This skill provides production-grade patterns for Unity's Data-Oriented Technology Stack (DOTS). It covers essential components like Entity Component System (ECS), the Job System, and the Burst Compiler, enabling developers to build high-performance, scalable games. Use this when optimizing CPU-bound logic, managing thousands of entities, or migrating traditional OOP game code to a data-oriented design.