Supabase Performance Optimizer
Optimize Supabase database performance with intelligent analysis and recommendations
npx claude-code-templates@latest --command database/supabase-performance-optimizer Scanned by NVIDIA SkillSpector
Automated static analysis (no LLM) · v2.12.0 · 2026-10-23
SkillSpector looks for patterns such as shell commands, credential access, network calls or unpinned dependencies. An observation is something worth reading in the files before you install, not a confirmed vulnerability. Components that run code locally, like hooks, MCP servers and security tooling, naturally show more of them.
No observations.
Learn more about NVIDIA SkillSpector.
Content
Supabase Performance Optimizer
Optimize Supabase database performance with intelligent analysis and automated improvements: $ARGUMENTS
Current Performance Context
- Supabase metrics: Database performance data via MCP integration
- Query patterns: !
find . -name "*.sql" -o -name "*.ts" -o -name "*.js" | xargs grep -l "from\|select\|insert\|update" 2>/dev/null | head -5application queries - Schema analysis: Current table structures and relationship complexity
- Performance logs: Recent query execution times and resource usage patterns
Task
Execute comprehensive performance optimization with intelligent analysis and automated improvements:
Optimization Focus: Use $ARGUMENTS to focus on query optimization, index management, storage optimization, RLS policies, or database functions
Performance Optimization Framework:
- Performance Analysis - Analyze query execution times, identify slow operations, assess resource utilization, evaluate bottlenecks
- Index Optimization - Analyze index usage, recommend new indexes, identify redundant indexes, optimize index strategies
- Query Optimization - Review application queries, suggest query improvements, implement query caching, optimize join operations
- Storage Optimization - Analyze storage patterns, recommend archival strategies, optimize data types, implement compression
- RLS Policy Review - Analyze Row Level Security policies, optimize policy performance, reduce policy complexity, improve security efficiency
- Function Optimization - Review database functions, optimize function performance, implement caching strategies, improve execution plans
Advanced Features: Automated index recommendations, query plan analysis, performance trend monitoring, cost optimization, scaling recommendations.
Monitoring Integration: Real-time performance tracking, alert configuration, performance regression detection, optimization impact measurement.
Output: Comprehensive optimization plan with performance improvements, index recommendations, query optimizations, and monitoring setup.