Skill UI

A guide to building robust projections and read models from continuous event streams. This pattern is essential for implementing CQRS read sides, creating materialized views, optimizing query performance, and building complex search indexes in event-sourced architectures. Use it when data needs to be transformed and aggregated from raw events into optimized query structures.

Expert in designing and implementing advanced Retrieval-Augmented Generation (RAG) pipelines. This role focuses on optimizing the entire information retrieval process—from document chunking and embedding model selection to vector database architectures and hybrid search strategies. The goal is to bridge the gap between raw knowledge documents and accurate LLM understanding, drastically reducing hallucination and enhancing context relevance for enterprise applications.

A senior specialist for building modern, production-grade React applications using React 19, Server Components, and Next.js App Router. Expertise includes implementing complex state management (Redux, Zustand), optimizing performance with memoization, handling data fetching with TanStack Query, and ensuring strict TypeScript typing and accessibility standards. Ideal for architecting large-scale frontend systems.

This comprehensive workflow guides the development of modern, scalable full-stack applications using Next.js 14+, React, and TypeScript. It covers all phases, from project setup and component architecture to advanced data fetching (Server Components, React Query), styling with Tailwind CSS, robust testing (E2E via Playwright), and deployment optimization. Ideal for building complex, production-grade web interfaces.

A comprehensive guide to selecting the optimal architecture for Replit applications. It compares three scaling models—single-file scripts (prototypes), modular apps (MVPs), and multi-service systems (large scale)—to help developers choose the correct database, storage, and deployment strategy as their project grows.

This comprehensive workflow guides developers through building a production-ready, full-stack web application entirely within the Replit environment. It covers setting up the entire architecture, including Express/Flask backend logic, robust PostgreSQL database integration for persistent data, implementing secure user authentication using Replit Auth, and managing file uploads via Object Storage. It is the definitive guide for launching a complex, scalable SaaS project from scratch.

This guide provides a comprehensive reference architecture for building robust, production-grade applications on Replit. It covers best-practice project layouts, system-level configurations (like replit.nix), data layer strategies (PostgreSQL, KV, Object Storage), and secure deployment techniques. Use it when starting a new Replit project, optimizing existing codebases, or establishing enterprise-level architectural standards.

This skill provides patterns and implementation templates for managing complex, long-running business processes across multiple independent services. It focuses on implementing the Saga pattern, ensuring data consistency in microservices architectures. It defines clear states, handles step execution, and crucially includes compensation logic to reliably roll back changes when any part of the workflow fails.

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 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.