How to Fix Rate Limit Issues in Supabase

1// Common rate limit error messages:
2
3// 1. Auth email rate limit (default SMTP)
4// Error: 'Email rate limit exceeded'
5// HTTP 429 on /auth/v1/signup or /auth/v1/recover
6// Cause: Default SMTP allows only 2 emails/hour
7
8// 2. Auth signup rate limit
9// Error: 'For security purposes, you can only request this once every 60 seconds'
10// Cause: Same email requested too quickly
11
12// 3. API request rate limit
13// Error: 'Too many requests'
14// HTTP 429 on /rest/v1/* endpoints
15// Cause: Exceeded plan's API request quota
16
17// 4. Realtime connection limit
18// Error: 'Too many connections'
19// Cause: Exceeded max concurrent WebSocket connections
20
21// Check which limit:
22console.log('Status:', error?.status) // 429 = rate limited
23console.log('Message:', error?.message)

1# Dashboard > Authentication > Settings > SMTP Settings
2# Enable Custom SMTP: ON
3
4# For Resend (recommended, free tier: 100 emails/day):
5# Host: smtp.resend.com
6# Port: 465
7# Username: resend
8# Password: re_your_api_key
9# Sender email: noreply@yourdomain.com
10
11# For SendGrid (free tier: 100 emails/day):
12# Host: smtp.sendgrid.net
13# Port: 465
14# Username: apikey
15# Password: SG.your_api_key
16# Sender email: noreply@yourdomain.com
17
18# For Mailgun:
19# Host: smtp.mailgun.org
20# Port: 465
21# Username: your_mailgun_username
22# Password: your_mailgun_password
23# Sender email: noreply@yourdomain.com
24
25# After saving, test by triggering a signup or password reset

1import { createClient } from '@supabase/supabase-js'
2
3const supabase = createClient(
4  'https://your-project.supabase.co',
5  'your-anon-key'
6)
7
8// BAD: Fetches on every keystroke
9function handleSearch(query: string) {
10  supabase.from('products').select('*').ilike('name', `%${query}%`)
11}
12
13// GOOD: Debounced search (only fires after 300ms pause)
14function debounce<T extends (...args: any[]) => any>(fn: T, delay: number) {
15  let timer: ReturnType<typeof setTimeout>
16  return (...args: Parameters<T>) => {
17    clearTimeout(timer)
18    timer = setTimeout(() => fn(...args), delay)
19  }
20}
21
22const debouncedSearch = debounce(async (query: string) => {
23  const { data } = await supabase
24    .from('products')
25    .select('*')
26    .ilike('name', `%${query}%`)
27    .limit(20)
28  // Update state with results
29}, 300)
30
31// Use in input handler:
32// <input onChange={(e) => debouncedSearch(e.target.value)} />

1async function fetchWithRetry<T>(
2  fn: () => Promise<{ data: T | null; error: any }>,
3  maxRetries = 3
4): Promise<{ data: T | null; error: any }> {
5  let lastError: any = null
6
7  for (let attempt = 0; attempt <= maxRetries; attempt++) {
8    const { data, error } = await fn()
9
10    if (!error) {
11      return { data, error: null }
12    }
13
14    // Only retry on rate limit errors (429)
15    if (error.status !== 429 || attempt === maxRetries) {
16      return { data: null, error }
17    }
18
19    lastError = error
20
21    // Exponential backoff: 1s, 2s, 4s
22    const delay = Math.pow(2, attempt) * 1000
23    console.log(`Rate limited, retrying in ${delay}ms (attempt ${attempt + 1})`)
24    await new Promise((resolve) => setTimeout(resolve, delay))
25  }
26
27  return { data: null, error: lastError }
28}
29
30// Usage:
31const { data, error } = await fetchWithRetry(() =>
32  supabase.from('todos').select('*')
33)

1# Dashboard > Settings > Usage
2# Monitor these metrics:
3#   - API requests: total requests per month
4#   - Database size: storage used
5#   - Bandwidth: data transferred
6#   - Edge Function invocations: function calls
7#   - Realtime connections: concurrent WebSocket connections
8
9# Plan limits (approximate):
10# Free:  500K API requests/month, 500MB database, 1GB bandwidth
11# Pro:   Unlimited API requests, 8GB database, 50GB bandwidth
12# Team:  Unlimited API requests, 8GB database, 50GB bandwidth
13
14# If hitting limits on Free plan:
15# 1. Optimize queries (add .limit(), use indexes)
16# 2. Cache responses client-side
17# 3. Upgrade to Pro ($25/month) for unlimited API requests
18
19# If hitting limits on Pro plan:
20# Contact Supabase support for custom limits
21# Or implement your own rate limiting with Edge Functions