Community Команды Базы данных

Команда supabase-performance-optimizer

Claude Code
Открыть источник ↗ GitHub ↗
Установка 
npx claude-code-templates@latest --command database/supabase-performance-optimizer

Описание

supabase-performance-optimizer — slash-команда ускорения Supabase: анализ — интеллектуальный разбор производительности, рекомендации — конкретные шаги по оптимизации, применение — что и в каком порядке менять. Для разработчиков на Supabase, желающих быструю базу без найма DBA.

Что умеет:
— анализировать производительность Supabase;
— давать конкретные рекомендации;
— приоритизировать шаги оптимизации;
— запускаться одной командой.

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:

  • 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.