Can it help with JWT expired issues?

Yes, it provides implementation patterns for manual session refreshing and correctly configuring auth listeners to handle token expiry gracefully.

How does this skill help with RLS errors?

It provides specific SQL diagnostic queries and logic checks to verify if policies are correctly matching user IDs and allows you to test policies as specific users.

Does it support debugging Supabase Edge Functions?

Absolutely. It covers common 500 and 504 errors, CORS header configurations, and how to properly manage environment secrets using the CLI.

How can I optimize slow queries with this skill?

The skill includes guidance on using EXPLAIN ANALYZE, identifying sequential scans, and implementing 'security definer' functions to speed up RLS-heavy queries.

Supabase Troubleshooting

Name: Supabase Troubleshooting
Author: adaptationio

byadaptationio

Database Management

Diagnoses and resolves complex Supabase issues including authentication errors, RLS policy failures, and database performance bottlenecks.

About

The Supabase Troubleshooting skill equips Claude with specialized knowledge to debug and optimize the entire Supabase ecosystem. It provides deep insights into common pitfalls such as Row Level Security (RLS) access denials, JWT authentication expiration, and Edge Function timeouts. Whether you are dealing with 'failed to fetch' network errors, slow PostgreSQL queries, or Realtime subscription limits, this skill offers actionable code snippets and configuration fixes to streamline your backend development workflow.

Key Features

Edge Function troubleshooting for timeouts, CORS, and secret management
Comprehensive RLS debugging for policy violations and hidden data issues
Database performance tuning using indexing strategies and query analysis
Authentication flow optimization for JWT management and session persistence
Realtime subscription fixes for connection limits and event handling
0 GitHub stars

Use Cases

Resolving 504 Gateway Timeouts and cold start issues in Supabase Edge Functions
Fixing 'violates row-level security policy' errors when users cannot access their own data
Identifying missing indexes to improve query speed on large PostgreSQL tables

About

Key Features

Edge Function troubleshooting for timeouts, CORS, and secret management
Comprehensive RLS debugging for policy violations and hidden data issues
Database performance tuning using indexing strategies and query analysis
Authentication flow optimization for JWT management and session persistence
Realtime subscription fixes for connection limits and event handling
0 GitHub stars

Use Cases

Resolving 504 Gateway Timeouts and cold start issues in Supabase Edge Functions
Fixing 'violates row-level security policy' errors when users cannot access their own data
Identifying missing indexes to improve query speed on large PostgreSQL tables