What database performance issues does it address?

The skill helps identify bottlenecks using EXPLAIN ANALYZE, suggests missing indexes for high-traffic columns, and provides solutions for high connection counts and sequential scans.

How does this skill help with Row Level Security (RLS)?

It provides diagnostic SQL queries to verify if RLS is enabled, tests existing policies against specific user IDs, and offers implementation patterns to optimize RLS performance by caching auth.uid() results.

Does it cover Supabase Edge Functions and Realtime?

Yes, it assists in debugging 504 timeouts and 500 internal errors in Edge Functions, as well as resolving common subscription issues and connection limits in Supabase Realtime.

Can it help resolve 'JWT expired' errors in Supabase?

Yes, it includes code patterns for forcing session refreshes and setting up authentication state listeners to handle token expiration gracefully within your client-side application.

Supabase Troubleshooting

Name: Supabase Troubleshooting
Author: adaptationio

byadaptationio

Database Management

Diagnoses and resolves common Supabase errors related to authentication, row-level security, database performance, and connection issues.

About

This specialized Claude Code Skill empowers developers to rapidly debug and fix complex Supabase issues across the entire stack. From resolving JWT expiration and authentication persistence problems to troubleshooting 'empty data' RLS violations, this skill provides actionable code snippets and structured diagnostic steps. It acts as a domain-specific expert for the Supabase ecosystem, helping you optimize slow SQL queries, manage Edge Function timeouts, and secure your storage buckets, ensuring your backend remains robust and performant.

Key Features

Performance optimization guides for SQL queries, indexing, and connection pooling
Detailed troubleshooting for Row Level Security (RLS) policies and performance
0 GitHub stars
Comprehensive diagnosis of authentication, JWT, and session persistence errors
Quick-reference mapping for PostgREST and PostgreSQL error codes
Debugging workflows for Edge Functions, Realtime subscriptions, and Storage uploads

Use Cases

Fixing 'Not authorized' errors or RLS-related empty data returns in production
Resolving connection failures, CORS issues, and Edge Function timeouts
Optimizing slow-performing database queries and complex security policies

About

Key Features

Performance optimization guides for SQL queries, indexing, and connection pooling
Detailed troubleshooting for Row Level Security (RLS) policies and performance
0 GitHub stars
Comprehensive diagnosis of authentication, JWT, and session persistence errors
Quick-reference mapping for PostgREST and PostgreSQL error codes
Debugging workflows for Edge Functions, Realtime subscriptions, and Storage uploads

Use Cases

Fixing 'Not authorized' errors or RLS-related empty data returns in production
Resolving connection failures, CORS issues, and Edge Function timeouts
Optimizing slow-performing database queries and complex security policies