Supabase Docs
You can use the Database Linter to check your database for issues such as missing indexes and improperly set-up RLS policies.
Using the linter
In the dashboard, navigate to Database Linter under Database. The linter runs automatically. You can also manually rerun it after you've resolved issues.