supabase-troubleshooting

SKILL.md

| Empty data returned | RLS policies blocking access | | "Not authorized" | Missing or invalid auth token | | "JWT expired" | Token needs refresh | | Slow queries | Missing indexes or RLS subqueries | | Connection refused | Wrong URL or service down | | "Duplicate key" | Unique constraint violation | | Function timeout | Cold start or heavy computation |

| PGRST116 | No rows found (single expected) | Use maybeSingle() instead of single() | | PGRST205 | Table not found in schema cache | Check table name spelling, verify table exists | | PGRST301 | Multiple rows (single expected) | Add unique constraint or better filter |

| 22P02 | Invalid input syntax (e.g., bad UUID) | Validate input format before query | | 23503 | Foreign key violation | Ensure parent row exists first | | 23505 | Unique constraint violation | Use upsert or check existence | | 42501 | Insufficient privilege (RLS) | Fix RLS policies or use service role |

查看原文