Automated summary
This skill walks through optimizing Supabase API performance by first measuring baseline latency, then adding response caching, request batching, and connection pooling.
Strengths
- Four-step sequence: baseline latency measurement, caching, batching, then connection pooling
- Points to concrete tooling (DataLoader, LRU cache, Redis or in-memory cache)
- States a clear expected output: reduced latency, a caching layer, request batching, and configured pooling
- Links to authoritative references (Supabase performance guide, DataLoader, node-lru-cache)
Limitations
- The body is only a skeleton; error handling and detailed examples live in external reference files that are not included
- No guidance on cache invalidation, TTL strategy, or numeric performance targets
- Allowed tools (Read, Write, Edit) mean it cannot run benchmarks or profiling commands itself
Use it when an existing Supabase integration has slow API responses or when you want a structured plan for caching and batching to raise request throughput.
Skip it when the bottleneck is actually Postgres indexing or schema design, since this skill focuses on the API layer and application-side caching.
Security analysis
SafeThe skill only uses Read, Write, and Edit tools. It provides guidance on performance tuning with no destructive actions, network calls, or exfiltration. No risky commands or obfuscation.
No concerns found
How this analysis is madeExamples
My Supabase queries take ~800ms on the dashboard page. Help me measure a baseline, then add a response cache for the most frequently read tables.Optimize Supabase request throughput: introduce DataLoader batching for my N+1 lookups and configure connection pooling with keep-alive.Les appels Supabase de mon API Node sont lents : propose une stratégie de cache Redis et de batching, puis montre-moi les changements de code.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
From the file to a first result
The download contains exactly the content displayed on this page. This copy may differ from the latest version in the source repository.
View the source and supporting filesThis download contains SKILL.md only. Any scripts, references, templates and dependencies are not included. Get the required files from the source, preserving their directory structure, before continuing.
1. Download the file
Download SKILL.mdFrom the root of a test project, save the file as .skill-downloads/supabase-performance-tuning-mttmx6vd/SKILL.md, or use the command below. This folder is for inspecting the skill before installation.
Command for macOS/Linux or WSL: requires a POSIX shell and curl. On Windows without WSL, use the download button and create the folder manually.
mkdir -p '.skill-downloads/supabase-performance-tuning-mttmx6vd' && curl --fail --show-error --location 'https://skills-guides.com/api/skills/supabase-performance-tuning-mttmx6vd/download' --output '.skill-downloads/supabase-performance-tuning-mttmx6vd/SKILL.md.part' && mv '.skill-downloads/supabase-performance-tuning-mttmx6vd/SKILL.md.part' '.skill-downloads/supabase-performance-tuning-mttmx6vd/SKILL.md'2. Check prerequisites
Read SKILL.md before using it. If it references scripts or external services, inspect them and prepare the required access in your test environment.
Tools declared by the author (check availability in your agent): Read, Write, Edit
Original excerpt: Prerequisites
- Supabase SDK installed
- Understanding of async patterns
- Redis or in-memory cache available (optional)
- Performance monitoring in place
The platforms on this page are catalog indications. The paths below follow tool documentation; they do not prove this skill has been run in those tools. No minimum tool version is confirmed for this listing.
3. Load the skill
After inspection, copy the complete folder into your project using one of the commands below, then open a new tool session. The command stops if a folder with the same name already exists: compare the files before replacing it.
Claude Code
test -f '.skill-downloads/supabase-performance-tuning-mttmx6vd/SKILL.md' && test -s '.skill-downloads/supabase-performance-tuning-mttmx6vd/SKILL.md' && mkdir -p '.claude/skills' && test ! -e '.claude/skills/supabase-performance-tuning' && cp -R '.skill-downloads/supabase-performance-tuning-mttmx6vd' '.claude/skills/supabase-performance-tuning'Cursor
test -f '.skill-downloads/supabase-performance-tuning-mttmx6vd/SKILL.md' && test -s '.skill-downloads/supabase-performance-tuning-mttmx6vd/SKILL.md' && mkdir -p '.cursor/skills' && test ! -e '.cursor/skills/supabase-performance-tuning' && cp -R '.skill-downloads/supabase-performance-tuning-mttmx6vd' '.cursor/skills/supabase-performance-tuning'OpenSkills
OpenSkills must already be installed. The local install/read procedure is checked with OpenSkills 1.5.0, which requires Node.js ≥ 20.6.0. Catalog slugs are not resolved automatically.
Official OpenSkills installationopenskills install './.skill-downloads/supabase-performance-tuning-mttmx6vd'openskills read 'supabase-performance-tuning-mttmx6vd'Reading should display the installed file content and its base directory. It does not run the skill or install its dependencies.
For an agent that reads AGENTS.md, then sync the index. This command changes AGENTS.md: review the diff before using it.
openskills syncManual method or another tool: attach SKILL.md to a conversation, or open it in an agent that can read files. Include any required supporting resources. No universal folder is recognized by every tool.
4. Try a first task
Use a short, synthetic input: an API endpoint, a small document or an interface brief. In a new conversation, attach the file or give the agent its path, then adapt this request:
Read .skill-downloads/supabase-performance-tuning-mttmx6vd/SKILL.md and apply its instructions to this example: [describe a test input]. Identify any missing files, dependencies or access. Produce the result requested by the skill without inventing data or running unreviewed scripts.Expected result: output matching the skill instructions, or a precise list of missing prerequisites. A read confirmation alone does not validate a first use. If an external resource is unavailable, that path remains untested.
React Hook Form Best Practices
Development
Master React Hook Form: avoid anti-patterns, manage subscriptions, and handle reset, dirty state, and controlled inputs correctly.
Emotion to Mantine Migration
Development
Migrate Emotion styled-components to Mantine components with style props and CSS modules. Use when converting .styled.tsx files or removing @emotion imports.
Scope Creep Detector
Development
Analyzes git diffs against a stated intent to detect scope creep, unrelated files, broad PRs, and oversized changes, then suggests keep, split, or justify actions.