Supabase Load Scale

What it does

When your agent uses it

• Preparing a Supabase project for production load — traffic spikes
• Connection-limit tuning
• Read replicas for analytics queries
• CDN caching for Storage

Example prompts

• “supabase scale”
• “supabase read replica”
• “supabase connection pooling”
• “/supabase-load-scale”

Requirements

• A credential in SUPABASE_ANON_KEY
• Compatibility (from SKILL.md): Designed for Claude Code
• Pre-approved tools (allowed-tools): Read, Write, Edit, Bash(supabase:*), Bash(psql:*), Bash(curl:*), Grep

Workflow steps

3 steps, taken from the step headings in SKILL.md.

1. 1Read Replicas and Connection Pooling
2. 2Compute Upgrades, CDN for Storage, and Edge Function Regions
3. 3Database Table Partitioning

What it can do on your machine

Read from SKILL.md and the folder at commit cfae287. It shows what the files ask for, not the result of running them.

• Tool permissions

  Pre-approves these tools, so the agent can use them without asking each time:

  • Read
  • Write
  • Edit
  • Bash(supabase:*)
  • Bash(psql:*)
  • Bash(curl:*)
  • Grep

  From allowed-tools in the SKILL.md frontmatter.

• Runs code

  Shell commands in SKILL.md call:

  • supabase
  • psql

  From the folder's file list and the shell code blocks in SKILL.md.

• Network

  Links to these hosts (documentation or services it may open):

  • supabase.com
  • postgresql.org

  From URLs in SKILL.md, links to its own repository left out.

• Credentials

  Names these keys or tokens, usually read from environment variables:

  • SUPABASE_ANON_KEY

  From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.

• Compatibility

  Designed for Claude Code

  From compatibility in the SKILL.md frontmatter.

Context cost

Supabase Load Scale loads about 1.7k tokens when it runs, and up to ~7.6k if it reads all its reference files. Until then it costs about 157 tokens; SKILL.md has 594 words of instructions outside code blocks.

Always · name and description, kept in context so the agent knows when to use it

~157

When it runs · the whole SKILL.md, loaded when a task matches

~1.7k

With references · SKILL.md plus every file in references/, read only if the agent opens them

~7.6k

Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.

Safety

Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); files beside SKILL.md are not scanned.

SKILL.md

The full file from jeremylongshore/tons-of-skills-marketplace at commit cfae287, republished under its MIT licence (© jeremylongshore). 594 words, ~1,684 tokens.

name

supabase-load-scale

description

Use when preparing a Supabase project for production load — traffic spikes, connection-limit tuning, read replicas for analytics queries, CDN caching for Storage, regional Edge Function deployment, or partitioning large tables. Covers read replicas, Supavisor connection pooling, compute-size upgrades, Storage CDN, Edge Function regions, and table partitioning. Trigger with phrases like "supabase scale", "supabase read replica", "supabase connection pooling", "supabase compute upgrade", "supabase CDN storage", "supabase edge function regions", "supabase partitioning", "supavisor", "supabase pool mode".

allowed-tools

Read, Write, Edit, Bash(supabase:*), Bash(psql:*), Bash(curl:*), Grep

compatibility

Designed for Claude Code

version

1.54.0

license

MIT

author

Jeremy Longshore <jeremy@intentsolutions.io>

tags

saas, supabase, scaling, performance, connection-pooling, read-replicas, partitioning

// lib/supabase.ts
export const supabase = createClient<Database>(
  process.env.SUPABASE_URL!, process.env.SUPABASE_ANON_KEY!)       // writes + realtime
export const supabaseReadOnly = createClient<Database>(
  process.env.SUPABASE_READ_REPLICA_URL!, process.env.SUPABASE_ANON_KEY!) // analytics

supabase projects update --experimental --compute-size large   # scale compute
supabase functions deploy my-function --region eu-west-1        # deploy near users

# Check how many connections are in use right now
psql "$DATABASE_URL" -c "SELECT count(*) AS active_connections FROM pg_stat_activity WHERE state = 'active';"

© jeremylongshore, MIT. Rendered from Markdown: HTML in the file is shown as text, images as links, and headings moved down two levels. Raw file

Files

SKILL.md and 9 other files (references) in skills/.curated/supabase-load-scale of jeremylongshore/tons-of-skills-marketplace.

• SKILL.md
• references/advanced-examples.md
• references/capacity-planning.md
• references/cdn-and-edge.md
• references/connection-pooling.md
• references/errors.md
• references/examples.md
• references/load-testing-with-k6.md
• references/scaling-patterns.md
• references/table-partitioning.md

Open the folder on GitHubat commit cfae287