Skill UI

This skill provides comprehensive performance optimization and best practices for PostgreSQL, maintained by Supabase. It guides users on optimizing database performance, covering critical areas such as writing efficient SQL queries, designing robust schemas, implementing proper indexing, managing connection pooling, and enforcing Row-Level Security (RLS).

This comprehensive checklist guides the secure deployment and hardening of a Supabase project for production use. It covers critical security measures such as enforcing Row Level Security (RLS), separating client and service keys, optimizing connection pooling via Supavisor, setting up Point-in-Time Recovery (PITR) backups, and configuring network restrictions. Use this guide before launching or for conducting security audits to ensure maximum stability and security.

A comprehensive guide to implementing enterprise-grade Supabase architectures. This skill covers advanced patterns like monorepo layout, multi-tenant Row Level Security (RLS) isolation, microservices integration, and operational patterns (caching, queues, audit logging). Use this when building complex, scalable, and production-ready applications on Supabase.

Master advanced techniques for building fault-tolerant applications integrated with Supabase. This guide implements critical resilience patterns, including circuit breakers, offline queuing (using IndexedDB), graceful degradation, exponential backoff retries, and dual-write strategies. Use this skill to handle network outages, API failures, and transient errors, ensuring your application remains highly available and reliable in production environments.

Learn robust and production-ready patterns for interacting with Supabase backend services. This skill covers client initialization, advanced CRUD operations (filtering, upserting), authentication, real-time subscriptions, and RPC calls. Provides best practices for both TypeScript and Python environments, ensuring secure and reliable data handling.

This skill provides a comprehensive guide to securing Supabase projects. It covers critical security measures, including proper separation of anonymous and service role keys, enforcing Row Level Security (RLS) on all tables, and hardening the API surface. Use this when setting up a new project, performing security audits, or implementing robust data access control policies.

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.

Automate Svix operations through Composio’s Svix toolkit by orchestrating Rube MCP calls; follow the required discovery, connection, and execution steps to keep schemas current and workflows reliable.

This pattern demonstrates how to build a robust, thread-safe data persistence layer in Swift using the 'actor' model. It combines fast in-memory caching with reliable file-backed storage, automatically eliminating data races and the need for manual locks. Ideal for offline-first applications and managing shared mutable state in modern Swift concurrency.

Automate Sympla operations through Composio’s Sympla toolkit by sequencing Rube MCP calls, always discovering current tools, checking active Sympla connections, and executing schema-compliant steps via the multi-tool executor.

This expert skill acts as a master orchestrator for Test-Driven Development (TDD), guiding users through the complete Red-Green-Refactor cycle. It specializes in coordinating complex, multi-agent testing workflows, integrating modern practices like BDD, ATDD, and AI-assisted test generation. Use it to ensure robust, highly maintainable, and thoroughly tested software systems across diverse technological stacks and complex development pipelines.

This skill helps developers adhere to Test-Driven Development (TDD) principles by generating comprehensive, failing unit and integration tests. It is specifically designed for the 'Red' phase, ensuring that expected behaviors, edge cases (null, boundary values), and error handling are rigorously defined before any implementation code is written. It forces the definition of the 'what' before the 'how'.