Skill UI

Expert guidance on designing highly scalable, distributed NoSQL databases, specifically covering Apache Cassandra and Amazon DynamoDB. This skill emphasizes the 'Query-First' modeling approach, teaching best practices like partitioning, denormalization, single-table design, and avoiding common anti-patterns (e.g., hot partitions, joins) to ensure optimal read/write performance at massive scale.

This skill provides a comprehensive guide to PostgreSQL best practices and performance optimization, maintained by Supabase. It covers critical areas such as query tuning, schema design, connection management, security (RLS), and indexing. Use this guide when writing complex SQL, reviewing database architecture, or diagnosing performance bottlenecks to ensure robust and efficient database operations.

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

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.

Provides a comprehensive, production-ready reference architecture for building complex applications on Vercel using Next.js and TypeScript. It covers modern best practices, including layered directory structure, secure typed environment variable management (Zod), lazy database singleton implementation, API route patterns, and essential Edge Middleware for authentication and routing. Use this guide when starting a new Vercel project or standardizing existing application infrastructure.

Automates websocket handler setup for backend development, guiding Node.js, Python, and Go implementations while aligning with database, caching, messaging, and microservice architecture best practices to deliver production-ready code and validations.

A comprehensive, multi-phase workflow for developing professional WordPress plugins. Covers foundational architecture, hooks, admin UI, database design, and REST API implementation. Crucially, it incorporates advanced WordPress 7.0 features, including Real-Time Collaboration (RTC) compatibility, AI Connector integration (OpenAI, Claude, etc.), and the Abilities API, ensuring modern, scalable, and secure plugins.

This skill facilitates the end-to-end deployment of web applications and websites, supporting full-stack architectures including backend APIs, databases, and file storage. It is used when the user wishes to publish a project to a public, live URL, managing the entire deployment lifecycle from template selection to status checking and updates.