Skill UI

A comprehensive guide to securely implementing Supabase across diverse modern application stacks. This skill covers critical patterns for Next.js Server Components (SSR), Single Page Applications (SPA), React Native mobile apps, Edge Functions (Serverless), and complex multi-tenant deployments using RLS or schema isolation. It guides developers on correctly managing client types (anon vs. service_role) and handling authentication flows in various environments.

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 skill guides the setup of a robust, multi-environment architecture for Supabase, ensuring complete data isolation between development, staging, and production projects. It covers best practices for managing separate environment-specific secrets, safe database migration promotion (db push), environment-aware client initialization, and implementing safeguards to prevent accidental cross-environment operations in production. Essential for scaling SaaS applications.

A comprehensive guide to implementing enterprise-grade Supabase architectures. This skill covers advanced patterns like monorepo layout, multi-tenant Row Level Security (RLS) isolation, microservices integration, and operational patterns (caching, queues, audit logging). Use this when building complex, scalable, and production-ready applications on Supabase.

A comprehensive guide to building event-driven architectures using Supabase. It covers four core event mechanisms: Database Webhooks (pg_net), Postgres LISTEN/NOTIFY, Edge Function HTTP calls, and Realtime subscriptions. Includes production-ready SQL triggers, signature verification logic, and best practices for handling data changes (INSERT, UPDATE, DELETE) as external HTTP events.

A guide to the Swift 6.2 concurrency model, which mandates default single-threaded execution to eliminate accidental data races. Learn how to use MainActor for isolated consistency and utilize the @concurrent attribute for explicitly offloading CPU-intensive tasks to background threads, ensuring safe and predictable application architecture.

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.

This comprehensive guide demonstrates how to achieve highly testable Swift code using protocol-based dependency injection. By abstracting external concerns—such as file systems, networking, and external APIs—into small, focused protocols, developers can write deterministic unit tests that mock side effects and error paths, ensuring robust architecture across different environments (App, Test, Preview).

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.

A detailed, multi-phase workflow that strictly enforces the Test-Driven Development (TDD) discipline using the Red-Green-Refactor cycle. This guide covers the entire software development lifecycle, from test specification and architecture design to minimal implementation, rigorous refactoring, and comprehensive integration testing. It mandates high code and test coverage (e.g., 80% line coverage) to ensure robust, maintainable, and high-quality production code.

A comprehensive guide to building functional and scalable Telegram bots. Covers bot architecture design, mastering the Telegram Bot API, optimizing user experience (UX), implementing monetization strategies (Freemium, Subscriptions), and deploying production-ready bots using webhooks. Learn to transform complex ideas into engaging, real-world automated assistants.

Provides Terraform and OpenTofu best-practice guidance for module design, testing selection, CI/CD pipeline setup, security scanning, and architecture decisions in production infrastructure-as-code projects.