supabase-performance-tuning

通过缓存、批处理和连接池优化Supabase API性能。在遇到缓慢的API响应、实施缓存策略或优化Supabase集成请求吞吐量时使用。通过如“supabase性能”、“优化supabase”、“supabase延迟”、“supabase缓存”、“supabase慢”、“supabase批处理”等短语触发。

📖 中文导读:通过缓存、批处理和连接池优化Supabase API性能。在遇到缓慢的API响应、实施缓存策略或优化Supabase集成请求吞吐量时使用。通过如“supabase性能”、“优化supabase”、“supabase延迟”、“supabase缓存”、“supabase慢”、“supabase批处理”等短语触发。 以下正文为该技能的原始 SKILL.md 内容(英文),上方安装命令可直接使用。

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