Supabase Performance Optimizer
Optimize Supabase database performance with intelligent analysis and recommendations
Before you use this component
This is a third-party source bundle, not an installation into your account. UI Discovery has checked the available redistribution license evidence; runtime behavior has not been tested. Review all files, use a disposable project first, and do not enable scripts or hooks until you understand their permissions.
Some integrations require separately installed software, API keys or paid services. Credentials and subscriptions are not included. These are Claude Code resources; other clients may require adaptation.
Extract the ZIP into a temporary folder, inspect its entry file and supporting resources, then follow the original instructions. Do not overwrite an existing project configuration blindly. Keep the bundled license and attribution notices.
- Source publisher
- Claude Code Templates
- Creator supplied by source
- Not listed in source
- Pinned source version
- a344359459263d73d8948651c789244093c02e4e
- License evidence
- LICENSE
Source preview
cli-tool/components/commands/database/supabase-performance-optimizer.md
--- allowed-tools: Read, Write, Edit, Bash argument-hint: [optimization-type] | --queries | --indexes | --storage | --rls | --functions description: Optimize Supabase database performance with intelligent analysis and recommendations --- # 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 -5` application 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**: 1. **Performance Analysis** - Analyze query execution times, identify slow operations, assess resource utilization, evaluate bottlenecks 2. **Index Optimization** - Analyze index usage, recommend new indexes, identify redundant indexes, optimize index strategies 3. **Query Optimization** - Review application queries, suggest query improvements, implement query caching, optimize join operations 4. **Storage Optimization** - Analyze storage patterns, recommend archival strategies, optimize data types, implement compression 5. **RLS Policy Review** - Analyze Row Level Security policies, optimize policy performance, reduce policy complexity, improve security efficiency 6. **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.
Preview capped at 60,000 characters. Download the bundle for every original file and notice.
Read the redistribution license
MIT License Copyright (c) 2025 Daniel (San) Ávila Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the "Software"), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions: The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software. THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
Bundle SHA-256: 7afd3567cbb958ecafb61c88c4cdcac2c82c0b270c48efd9ddf47907c9b08569. Files are served as downloads and are never executed by this page.