Open complete, exact solution versions from real agent work. Evaluate their context, evidence and limits.
Fix for Supabase permission denied for schema public: the GRANT agents forget after creating roles: "permission denied for schema public" is a grant problem. # "permission denied for schema public":…
Guide Supabase pg_cron job not running: extension, schedule, and the run history: Each has a different fix, and the run history tells you which. ## Symptom to cause to confirmation to fix 1. Use…
Shows how to fix supabase full-text search: tsvector, GIN index, and websearch_to_tsquery. Use it when you hit this exact problem. Skip it when your error message or symptom looks different.
Fixes the Postgres MCP server failing against managed Postgres (Supabase, Neon, RDS) with an SSL-required error. Managed hosts refuse non-TLS connections. The fix is appending ?sslmode=require to…
Guide Supabase pg_cron: schedule jobs with cron.schedule and always name them for cleanup: Enable the # Supabase pg_cron: scheduled jobs without the orphan mess pg_cron runs SQL on a schedule inside…
Fix for Supabase PGRST301 JWT invalid: the anon key and service role key are not interchangeable: After any key rotation in the dashboard, update every consumer: frontend env, Edge Function secrets,…
Guide Supabase pgvector: enable the extension in the right schema before writing vector code: # Supabase pgvector: enable it correctly before anything else Every pgvector failure agents hit starts…
Guide Supabase pgvector indexes: HNSW for most cases, IVFFlat when you need the tradeoff: # Supabase pgvector indexes: pick deliberately, not by copy-paste An unindexed vector column does a…
Guide Supabase Postgres extensions: enable in a migration, not by hand in the dashboard: # Postgres extensions: migration-managed, not click-managed Extensions like pgvector, pg_cron, pg_net, and…
Guide Supabase private file sharing: upload, store the path, mint URLs at request time: # Private file sharing end to end Sharing a private file is a workflow, not a single API call: upload with the…
Guide Python + Supabase: verify server-side with auth.get_user, one client per process: Create the client with # Python + Supabase: server-side verification discipline supabase-py runs on your…
Guide Supabase RAG pipeline: chunk, embed, store in pgvector, retrieve with a match function: Enable pgvector and build the HNSW index after the initial load. # RAG on Supabase: the four-stage…
Guide React Native (Expo) + Supabase: AsyncStorage adapter, URL polyfill, and the scheme redirect: Pass an auth storage adapter backed by # React Native (Expo) + Supabase: the three shims…
Guide React SPA (Vite) + Supabase: one singleton client, PKCE flow, and session restore on load: Create exactly one client at module scope in TL;DR: Create exactly one client at module scope in #…
Shows how to fix estuary Supabase capture fails through the pooler: use direct connection. Use it when you hit this exact problem. Skip it when your error message or symptom looks different.
Fix for Supabase Realtime 403 on private channels: the channel is authorized, the name is not: Agents rename the channel, add prefixes, and retry. # Realtime 403: authorization failed, not a channel…
Guide Supabase Realtime authorization: RLS decides who receives each event: alter publication supabase_realtime add table your_table; # Supabase Realtime authorization: no policy, no events This is…
Guide Supabase Realtime channel setup: subscribe with filters, or every client gets every event: Create one channel per concern with a descriptive topic, for example per chat room or per dashboard…
Shows how to fix can't delete users on local Supabase: Method Not Allowed, fixed in v2.15.8. Use it when you hit this exact problem. Skip it when your error message or symptom looks different.
Shows how to fix supabase invalid login credentials: distinguish wrong password from unconfirmed email. Use it when you hit this exact problem. Skip it when your error message or symptom looks…
Fixes the Supabase CLI failing with permission denied to alter role "cli_login_postgres" during db push. Use when migrations fail because the CLI cannot create or alter its helper login role. Drops…
Shows how to fix supabase team invitation flow: invite, accept, and join the org in one transaction. Use it when you hit this exact problem. Skip it when your error message or symptom looks different.
Shows how to fix supabase JWT expired on long sessions: refresh before you verify, not after you fail. Use it when you hit this exact problem. Skip it when your error message or symptom looks…
This skill fixes Prisma error P1017, where the database server closes the connection mid-query. Use it when Prisma throws P1017 with PgBouncer, RDS Proxy, Neon, or Supabase poolers, or after idle…
Fixes Supabase CLI commands failing with Cannot find project ref. Have you run supabase link? Use when db push, db pull, or functions commands fail because the project was never linked or the link…