supabase-load-scale
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".
When & Why to Use This Skill
This Claude skill automates the implementation of Supabase load testing, horizontal auto-scaling, and capacity planning. It streamlines performance engineering by leveraging k6 for benchmarking and Kubernetes HPA for dynamic resource management, ensuring Supabase integrations remain performant and scalable under high-traffic conditions.
Use Cases
- Performance Benchmarking: Generate and execute k6 load testing scripts to identify bottlenecks and evaluate Supabase performance under stress.
- Automated Scaling: Configure Kubernetes Horizontal Pod Autoscaler (HPA) using CPU and custom Prometheus metrics to handle fluctuating database loads.
- Capacity Planning: Analyze test results to determine optimal resource allocation and define long-term infrastructure requirements for production environments.
- Infrastructure Documentation: Automatically document benchmark results and capacity recommendations to maintain a reliable and cost-effective database architecture.
| name | supabase-load-scale |
|---|---|
| description | | |
| allowed-tools | Read, Write, Edit, Bash(k6:*), Bash(kubectl:*) |
| version | 1.0.0 |
| license | MIT |
| author | Jeremy Longshore <jeremy@intentsolutions.io> |
Supabase Load Scale
Prerequisites
- k6 load testing tool installed
- Kubernetes cluster with HPA configured
- Prometheus for metrics collection
- Test environment API keys
Instructions
Step 1: Create Load Test Script
Write k6 test script with appropriate thresholds.
Step 2: Configure Auto-Scaling
Set up HPA with CPU and custom metrics.
Step 3: Run Load Test
Execute test and collect metrics.
Step 4: Analyze and Document
Record results in benchmark template.
Output
- Load test script created
- HPA configured
- Benchmark results documented
- Capacity recommendations defined
Error Handling
See {baseDir}/references/errors.md for comprehensive error handling.
Examples
See {baseDir}/references/examples.md for detailed examples.