command

supabase-performance-optimizer — Claude Code command: what it does

Q: How do I install supabase-performance-optimizer in Claude?

Use the templates CLI: `npx claude-code-templates@latest --command database/supabase-performance-optimizer`. The command file lands at `.claude/commands/supabase-performance-optimizer.md`.

A Claude slash command that inspects a Supabase database for slow queries and wasted indexes, then hands back an optimization plan.

Install into Claude Code · claude-code-templates All methods and platforms ↓

npx claude-code-templates@latest --command database/supabase-performance-optimizer

Open on GitHub

What supabase-performance-optimizer does

Run the command with a focus flag — --queries, --indexes, --storage, --rls or --functions — and it works through that area only. Leave the argument off and it walks the whole list.

The framework has six stages: query execution analysis, index review, application query cleanup, storage strategy, Row Level Security policy check, and database function tuning. It also scans your project for SQL, TypeScript and JavaScript files that touch the database, so the review is based on your actual query patterns rather than a generic checklist. Supabase metrics arrive through an MCP integration, which you need to set up first; without it the performance data side is thin.

You get back a plan covering index recommendations, query rewrites and monitoring setup. The command can write and edit files, so some changes land on disk directly. Worth reading the diff before you commit, especially in a project that already manages its own migrations.

What it helps with

track down slow queries in a Supabase database
drop redundant indexes
read the execution plan for a heavy query
simplify Row Level Security policies
decide which tables to archive

Example prompts for the agent

/supabase-performance-optimizer --queries
/supabase-performance-optimizer --indexes
/supabase-performance-optimizer --rls

How to install supabase-performance-optimizer

1claude-code-templates

npx claude-code-templates@latest --command database/supabase-performance-optimizer

2Manually: put the files in place

.claude/commands/supabase-performance-optimizer.md

Call it with /supabase-performance-optimizer. For all projects use ~/.claude/commands/

Manually: put the files in place

~/.codex/prompts/supabase-performance-optimizer.md

Call it with /prompts:supabase-performance-optimizer. Codex marks this format deprecated in favour of skills

Manually: put the files in place

.github/prompts/supabase-performance-optimizer.prompt.md

Manually: put the files in place

.gemini/commands/supabase-performance-optimizer.toml

Gemini stores commands as TOML: the prompt text goes into the prompt field

Questions about supabase-performance-optimizer

How do I install supabase-performance-optimizer in Claude?

Use the templates CLI: npx claude-code-templates@latest --command database/supabase-performance-optimizer. The command file lands at .claude/commands/supabase-performance-optimizer.md.

What does supabase-performance-optimizer do?

It analyzes Supabase database performance and returns an optimization plan covering indexes, queries, storage, RLS policies and functions. A flag narrows it to one area.

What does the command need to run?

A configured MCP integration with Supabase, since that is where the performance metrics come from. It also reads your project files to find the queries in use.

Source text

supabase-performance-optimizer.md · MIT

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

Similar slash commands

All slash commands for Data and databases →

supabase-postgres-best-practices official supabase A rule set for Postgres performance, maintained by Supabase. Useful when your agent writes queries, designs schemas or digs into a slow database. CX Codex GP ChatGPT 40installs supabase official supabase Guides the agent through database configuration and strict RLS policies in Supabase. CX Codex GP ChatGPT 8installs postgres-patterns affaan-m PostgreSQL best practice reference based on Supabase guidelines. Covers indexing patterns, data type choices, RLS policies, and slow query diagnosis. CX Codex +1 5,200installs performance-engineer VoltAgent Community A Claude Code subagent designed to identify performance bottlenecks across code, databases, and infrastructure under heavy load. 671installs

From the same set205

The whole set →

containerize-application A slash command that writes the Docker setup for your project: Dockerfile, .dockerignore, docker-compose and Kubernetes manifests. 1,200installs docs-maintenance This command audits documentation, links, structure, and style, then helps plan updates. Use it when Markdown docs need recurring checks. 1,146installs supabase-data-explorer This command explores Supabase data and schema, runs read-only SQL queries, and prepares exports or visualizations. Use it when database checks belong in the project workflow. 1,032installs test-runner This hook fires a test command right after Claude edits a file. Handy when you keep forgetting to re-run checks by hand. 1,027installs design-database-schema This command plans database structures around requirements, relationships, and query patterns. Use it to draft a schema or rethink an existing one. 1,021installs supabase-security-audit A slash command that audits a Supabase project: RLS policies, role permissions, API keys and auth configuration, with a report at the end. 1,020installs supabase-type-generator A slash command that turns your Supabase schema into TypeScript types and keeps them in sync. Useful when the database moves ahead of the types in your project. 948installs start Turns a task list or requirements file into atomic task files, checks dependencies and builds an execution plan. 945installs