Skill UI

Use this resource to implement comprehensive end-to-end monitoring and observability for Supabase projects. It guides users through analyzing API metrics, diagnosing slow database queries using pg_stat_statements, managing log drains for external aggregation, and setting up custom alerts, ensuring optimal project health and performance.

This comprehensive guide provides systematic methods to optimize Supabase query and database performance. Techniques cover PostgreSQL indexing (basic, composite, partial), using EXPLAIN ANALYZE for query plan analysis, optimizing client calls (column selection, pagination), and managing infrastructure resources like connection pooling. Use this when facing slow queries, high latency, or preparing a project for production-scale traffic.

A comprehensive guardrail system for enforcing organizational governance across Supabase projects. It provides reusable RLS policy templates, strict naming conventions, CI-checked migration processes, cost alert configurations, and security audit scripts. Use this to ensure development consistency, security, and cost control at scale.

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 for managing resource limits and quotas across all Supabase services (API, Auth, Storage, Realtime, Edge Functions). Learn how to understand tier-specific limits, configure connection pooling using Supavisor (Transaction/Session mode), and implement robust retry logic with exponential backoff to gracefully handle 429 rate limiting errors, ensuring high application reliability.

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.

This skill translates complex business requirements and specification documents into a complete, production-ready Postgres schema for Supabase. It covers the full development lifecycle, including entity extraction, defining robust tables with constraints, generating migration SQL files, implementing Row Level Security (RLS) policies, and producing corresponding TypeScript types. It is the foundational step for building any robust SaaS application on Supabase.

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 for migrating and upgrading the Supabase SDK (JS/TS and Python) and CLI. This tool detects breaking changes, covers major version jumps (e.g., v1 to v2), and provides automated code migration patterns for Auth, Realtime, and Storage APIs. Use this when updating your project to a new Supabase version or when encountering API deprecations.