Skill UI

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 comprehensive guide details how to configure robust multi-environment deployments (Development, Staging, Production) within the Replit ecosystem. It covers best practices for database separation, managing environment-specific secrets, implementing reliable environment detection logic, and setting up CI/CD pipelines to ensure applications are stable and secure across all deployment stages.

A comprehensive skill for optimizing complex SQL queries, designing robust database schemas, and troubleshooting performance bottlenecks across various dialects (PostgreSQL, MySQL, etc.). Use this when queries are slow, complex set-based logic is needed (CTEs, Window Functions), or when structuring/migrating a database schema. It provides detailed query plan analysis, advanced indexing strategies, and industry best practices.

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.

This comprehensive guide details how to establish secure and robust API endpoints using Expo Router and EAS Hosting. Learn best practices for handling server-side secrets (API keys, credentials), proxying third-party services (like OpenAI), executing secure database operations, and implementing complex business logic entirely on the server. It covers file structure, HTTP methods, and deployment to Cloudflare Workers.

This skill provides a comprehensive framework for building an automated Service Level Agreement (SLA) breach alerting system for vulnerability remediation. It covers defining severity-based SLA policies (Critical, High, Medium, Low), structuring a database schema for tracking, implementing breach detection logic, and dispatching multi-channel escalation notifications (Email, Slack, PagerDuty). Essential for achieving compliance and improving overall security posture.

This guide details the Hexagonal Architecture (Ports and Adapters) pattern, a robust method for decoupling core business logic from external infrastructure concerns. It teaches how to structure applications to make the domain model independent of databases, UI frameworks, or message queues. Implementing this pattern drastically improves testability, maintainability, and the ability to swap out external services without rewriting business rules.

A comprehensive, production-ready reference architecture for building robust, scalable transcription services using AssemblyAI. This guide demonstrates best practices for layered system design, covering API endpoints, service logic, client management, and infrastructure integration (webhooks, database). It is ideal for designing new high-throughput speech-to-text applications.

This skill manages comprehensive identity verification using the Persona API. It covers government ID checks (passport, driver's license), selfie liveness detection, and database lookups (SSN, watchlist). Use this when implementing Know Your Customer (KYC) workflows, reviewing detailed verification results, or building custom approval logic based on multi-source identity data.

This catalog provides essential database abstractions and specialized clients for robust data persistence. It includes core components like DbRegistry, DynamoDBClient, and various filtering utilities. By utilizing these standardized imports, developers can standardize data access logic, ensuring clean code separation, type safety, and scalable architecture in their applications.

This guide details the Hexagonal Architecture (Ports and Adapters) pattern, a robust method for decoupling core business logic from external infrastructure concerns. It teaches how to structure applications to make the domain model independent of databases, UI frameworks, or message queues. Implementing this pattern drastically improves testability, maintainability, and the ability to swap out external services without rewriting business rules.

This tool validates all pending database migrations to ensure correctness, safety, and adherence to best practices. Use it before applying migrations to catch critical issues like broken foreign key references, incomplete rollback logic, unintended destructive operations (e.g., DROP TABLE), and naming convention violations. It checks for rollback completeness, schema integrity, and idempotency.