Skill UI

A comprehensive guide and tool for building and configuring complex, multi-step AI agent workflows. Users can define sophisticated automation pipelines by chaining together customizable triggers (e.g., email, webhook), actions (e.g., Slack post, database update), conditional logic, and external knowledge bases. Ideal for automating business processes like customer support triage, data processing, and complex notifications, ensuring deterministic and scalable AI operations.

This skill provides comprehensive expertise for senior database administrators to optimize and manage PostgreSQL databases at an advanced level. Use it for deep query analysis via EXPLAIN ANALYZE, implementing advanced features like JSONB indexing, configuring streaming or logical replication, and maintaining database health through VACUUM tuning and monitoring pg_stat views. Ideal for building highly available, high-performance, and resilient system architectures.

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 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 guide for improving application speed across the entire stack, including frontend rendering, backend logic, and database queries. It outlines the crucial workflow—Measure, Identify, Fix, Verify—and addresses common bottlenecks like N+1 queries, Core Web Vitals improvements (LCP, INP, CLS), and large data handling.

This comprehensive guide details the workflow for creating robust, database-agnostic integration tests for data access layers migrating from Oracle to PostgreSQL. It outlines best practices for generating deterministic test cases using controlled seed data, ensuring that business logic and behavior remain consistent and validated across both source and target database systems.

This tool facilitates the migration of stored procedures and functions from Oracle PL/SQL to PostgreSQL PL/pgSQL. It handles complex syntax translation, preserves function signatures and type-anchored parameters, and manages explicit collation mapping. Use this when converting an existing Oracle database schema or application logic to a PostgreSQL environment.

This skill is designed to translate vague, colloquial, or descriptive biological details (such as behaviors, appearances, or cultural uses) into precise scientific or common species names. It is essential for constructing effective search queries in biological databases when the question does not use formal taxonomic names. By accurately identifying candidate species names from descriptive clues, users can drastically improve search relevance and accuracy.