Implement Supabase load testing, auto-scaling, and capacity planning strategies. Use when running performance tests, configuring horizontal scaling, or planning capacity for Supabase integrations. Trigger with phrases like "supabase load test", "supabase scale", "supabase performance test", "supabase capacity", "supabase k6", "supabase benchmark".
From supabase-packnpx claudepluginhub nickloveinvesting/nick-love-plugins --plugin supabase-packThis skill is limited to using the following tools:
references/capacity-planning.mdreferences/errors.mdreferences/examples.mdreferences/load-testing-with-k6.mdreferences/scaling-patterns.mdGuides Next.js Cache Components and Partial Prerendering (PPR) with cacheComponents enabled. Implements 'use cache', cacheLife(), cacheTag(), revalidateTag(), static/dynamic optimization, and cache debugging.
Migrates code, prompts, and API calls from Claude Sonnet 4.0/4.5 or Opus 4.1 to Opus 4.5, updating model strings on Anthropic, AWS, GCP, Azure platforms.
Details PluginEval's skill quality evaluation: 3 layers (static, LLM judge), 10 dimensions, rubrics, formulas, anti-patterns, badges. Use to interpret scores, improve triggering, calibrate thresholds.
Load testing a Supabase integration requires testing the right layers: your application code, connection pooling behavior, Supabase's own rate limits, and Postgres query performance under concurrent load. Testing only the application layer without observing database-level metrics can miss connection exhaustion and query plan degradation, which are the most common failure modes under high traffic.
Write a k6 test script that models your realistic traffic pattern — not just a flat ramp but the spike behavior and read/write ratio you expect at peak. Set thresholds for P95 and P99 latency at values that match your SLAs. Include both read-heavy and write-heavy scenarios since they stress different parts of the Supabase stack.
Set up HPA with CPU and custom metrics tied to request queue depth or active connection count. Configure scale-up and scale-down policies that avoid oscillation under sustained moderate load. Ensure your Supabase connection pool size is aligned with the maximum expected replica count so you do not exhaust database connections during scale-out events.
Execute the test against a staging environment that mirrors production configuration. Collect metrics at the application, connection pool, and database levels simultaneously. Watch for connection timeout errors and query latency increases as indicators of bottlenecks before they cause outages.
Record results in the benchmark template, including throughput, latency percentiles, error rate, and peak connection count. Derive capacity recommendations stating the safe maximum requests-per-second before SLA thresholds are breached.
See ${CLAUDE_SKILL_DIR}/references/errors.md for comprehensive error handling.
See ${CLAUDE_SKILL_DIR}/references/examples.md for detailed examples.
Implement Supabase load testing, auto-scaling, and capacity planning strategies.