jeremylongshore / supabase-performance-tuning
Install for your project team
Run this command in your project directory to install the skill for your entire team:
mkdir -p .claude/skills/supabase-performance-tuning && curl -L -o skill.zip "https://fastmcp.me/Skills/Download/1747" && unzip -o skill.zip -d .claude/skills/supabase-performance-tuning && rm skill.zip
Project Skills
This skill will be saved in .claude/skills/supabase-performance-tuning/ and checked into git. All team members will have access to it automatically.
Important: Please verify the skill by reviewing its instructions before using it.
Optimize Supabase API performance with caching, batching, and connection pooling. Use when experiencing slow API responses, implementing caching strategies, or optimizing request throughput for Supabase integrations. Trigger with phrases like "supabase performance", "optimize supabase", "supabase latency", "supabase caching", "supabase slow", "supabase batch".
Skill Content
---
name: supabase-performance-tuning
description: |
Optimize Supabase API performance with caching, batching, and connection pooling.
Use when experiencing slow API responses, implementing caching strategies,
or optimizing request throughput for Supabase integrations.
Trigger with phrases like "supabase performance", "optimize supabase",
"supabase latency", "supabase caching", "supabase slow", "supabase batch".
allowed-tools: Read, Write, Edit
version: 1.0.0
license: MIT
author: Jeremy Longshore <jeremy@intentsolutions.io>
---
# Supabase Performance Tuning
## Prerequisites
- Supabase SDK installed
- Understanding of async patterns
- Redis or in-memory cache available (optional)
- Performance monitoring in place
## Instructions
### Step 1: Establish Baseline
Measure current latency for critical Supabase operations.
### Step 2: Implement Caching
Add response caching for frequently accessed data.
### Step 3: Enable Batching
Use DataLoader or similar for automatic request batching.
### Step 4: Optimize Connections
Configure connection pooling with keep-alive.
## Output
- Reduced API latency
- Caching layer implemented
- Request batching enabled
- Connection pooling configured
## Error Handling
See `{baseDir}/references/errors.md` for comprehensive error handling.
## Examples
See `{baseDir}/references/examples.md` for detailed examples.
## Resources
- [Supabase Performance Guide](https://supabase.com/docs/performance)
- [DataLoader Documentation](https://github.com/graphql/dataloader)
- [LRU Cache Documentation](https://github.com/isaacs/node-lru-cache)