Skill UI

A comprehensive guide maintained by Supabase for optimizing Postgres performance. It provides critical rules and best practices across query performance, schema design, connection management, and security (including RLS). Use this skill when writing, reviewing, or optimizing complex SQL queries, database schemas, or configurations to ensure optimal database health and performance.

A comprehensive runbook for managing critical incidents within the Replit platform. It guides users through rapid triage (P1-P4 severity), diagnosing deployment crashes, database connection failures, and platform outages. Includes detailed steps for remediation, rollback procedures, and communication templates to restore service quickly and effectively.

This comprehensive guide provides detailed steps for load testing and capacity planning of Replit deployments. Learn how to benchmark performance using industry tools like k6 and autocannon, optimize Autoscale behavior, right-size Reserved VMs, and manage database connection pools. It covers optimizing cold start times and ensuring high availability under variable and peak traffic loads.

A comprehensive guide for optimizing application performance on Replit. Covers critical areas such as reducing cold start times, managing memory consumption, optimizing Nix environment dependencies, accelerating build processes, and ensuring database connection efficiency. Use this guide when facing slow startups, resource limits, or deployment slowdowns.

This skill guides you through advanced integration patterns to connect Sentry with your full observability stack. Learn how to correlate error events from structured loggers (like Winston/Pino) using Event IDs, track business metrics (counters, gauges) within Sentry, and link performance data across multiple tools (Grafana, Datadog). Achieve end-to-end visibility, ensuring every error is tied back to its root cause and business context.

This guide provides comprehensive, actionable methods to audit and significantly reduce Supabase operational costs. It covers advanced database tuning (vacuuming, index cleanup, bloat management), efficient storage lifecycle management, connection pooling strategies, and optimal plan selection. Use this when analyzing high billing reports, identifying resource waste, or implementing robust cost-saving measures in a cloud environment.

This guide demonstrates the fundamental "Hello World" query using the Supabase JS/Python client. It covers creating a structured table, enabling Row Level Security (RLS), inserting a record, and successfully selecting it back. This is essential for verifying project connectivity, understanding the basic data round-trip pattern, and mastering initial database interactions in a new Supabase environment.

A comprehensive guide detailing the most common and critical mistakes when developing with Supabase. Covers severe security issues (like exposing service role keys or missing RLS), data integrity failures, and performance bottlenecks (connection pooling, N+1 queries). Essential for code review, onboarding new developers, or auditing existing Supabase projects to ensure secure and robust applications.

Master advanced techniques for scaling Supabase projects to handle high production load. This skill covers six critical layers: implementing read replicas for analytics, optimizing connectivity using connection pooling (Supavisor), upgrading compute resources, utilizing CDN caching for Storage, deploying Edge Functions regionally, and performing database table partitioning. Ideal for engineers preparing for traffic spikes or optimizing large-scale database architectures.

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.

Supabase-curated Postgres best practices that prioritize query, schema, connection, security, and monitoring rules to guide writing, reviewing, or tuning SQL plus database configuration for better performance.

Guide for orchestrating Supadata operations via Composio’s Rube MCP workflow, covering tool discovery, connection checks, schema compliance, execution, and best practices for consistent automation.