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.

A comprehensive guide detailing how to use API routes in Expo Router with EAS Hosting. Learn best practices for handling server-side secrets, proxying third-party APIs (e.g., OpenAI, Stripe), performing database operations, and implementing robust backend logic using standard HTTP methods (GET, POST, etc.). Ideal for building secure, scalable mobile application backends.

Automates the generation of robust, DB-agnostic integration test cases for data access layers (DAL) during major database migrations, specifically from Oracle to PostgreSQL. These tests validate behavioral consistency across both source and target database systems, ensuring that core business logic remains intact after the migration process. Essential for maintaining data integrity and application stability.

A comprehensive guide and checklist for identifying potential risks when migrating database applications from Oracle to PostgreSQL. It systematically cross-references code and migration artifacts against known behavioral differences, covering issues such as empty string handling, refcursors, type coercion, sorting logic, and timestamp semantics. Use this tool during the planning phase to proactively mitigate risks, or during validation to ensure comprehensive integration test coverage for the new 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.

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.