Supabase

S

Supabase

Supabase gives you the tools, documentation, and community that makes managing databases, authentication, and backend infrastructure a lot less overwhelming.

Join

Remote has more migrations then local

My local migrations are in sync up to 20250920082841, but the remote DB has an extra migration 20250930132918 that I don’t have locally: ``` Connecting to remote database... ...

Persistent Schema Cache Error: "Could not find a relationship" despite correct Foreign Key

Hi everyone! Our team is working on a simple Next.js blog app for a practice exercise. The goal is for an admin to log in and create posts that everyone can see. We've hit a wall with a persistent schema cache error and would really appreciate some help. When our homepage tries to fetch all posts, the API fails with: Could not find a relationship between 'posts' and 'users' in the schema cache. Environment:...
No description

Supabase project vanished but was not deleted by any user

As of today, a project on my supabase account disappeared from my dashboard, and this was not deleted by me nor my work partner. it simply vanished. and projects that I had deleted earlier were now resurfacing on his dashboard whereas the mcp client says there is only one project on his organization, and the one I speak of has been removed. The affected database is currently linked to a project i submitted for a competition where no alternate changes can be made, this error I just faced can res...

Cannot create policy on a legacy table, even if RLS can be enabled

Hi. I have an issue on a legacy table (created in 2021). The user postgres owns this table, and can enable RLS on it, but that's it. It cannot create policies, it always gives me this : ERROR: 42501: permission denied for schema auth. That table is in public schema, not in auth so I don't get why I am having this error. Same error when trying to create the actual policy on dbeaver. Here is the very basic policy I want to create: CREATE POLICY tous_select ON public."Liste_appreciations" FOR SELECT USING (true);...

Supabase GitHub suspended

Hi everyone, I need urgent help.
My Supabase account is linked to GitHub, but my GitHub account has been suspended.
I still have an active Supabase session on my computer, but I can’t log in anymore and I’m afraid of losing access.
Could someone from the Supabase team please help me migrate my login from GitHub to email/password or Google? ...

Error: "more than one row returned by a subquery used as an expression" when accessing a table

Description: When I try to open the user_query_counts table in the Dashboard, I get the following error: ``` Failed to retrieve rows from table...
No description

ipv4 add-on charges on supabase branches?

I'm maintaining a project with 2 branches that are always up, but there are other brannches created and deleted when we create PRs. Are gonna be charged for each of the PR branches even if they are temporary?

DB source control ?

I am using Loveable & SupaBase, a great combo 🙂 I wonder what folks are doing to bring the DB definitions under source control ? I am using pg_dump to grab the entire schema and storing that in my Git repo, but not quite what I want and it's a manual process atm.

restoration failed

My free project has failed to restore and only option is contact support. I'm willing to upgrade to Pro, but will this actually help to get my project restored sooner?...

Best way to ingest millions of records into Supabase?

Hey all, I’m working on a project where we ingest U.S. Federal Procurement Data System (FPDS) contract data into Supabase. The source is the FPDS Atom feed (XML), which we parse and store into a table. Right now we already have ~2.8M records ingested successfully, but the process is hitting limits as we scale up to larger departments. The main challenges are:...

client.updateUser email flow, how do i pass the 2nd token?

Current "update email address" flow: (see attached image for visual) 1. User clicks on "update email address" 1.1. UI calls supabase.auth.reauthenticate() because "Secure email address" option is toggled on, which requires a nonce when calling updateUser with email param....
No description

X/Twitter OAuth confusion

X/Twitter OAuth is giving me "requested path is invalid" while Google/FB/Twitch work fine. Using OAuth 2.0 Client ID/Secret with standard Supabase callback URL. Has anyone successfully set up X OAuth recently? What am I missing?...

Supabase is down for 24H+ Frankfurt

Whenerver we login to our app we get: 'Missing response', 'code': '204', 'hint': 'Please check traceback of the code', 'details': "Postgrest couldn't retrieve response, please check traceback of the code. Please create an issue in supabase-community/postgrest-py if needed....

Problems with Sign In with GitHub account

and then constant preloader ((( on this page https://supabase.com/dashboard/sign-in-mfa?returnTo=%2Fsupport%2Fnew&method=github# Chrome browser .. how can i fix it ? (( nothing helps me ... in Safari it's working - but i used to use Chrome...
No description

PostgREST Schema Cache issue – `PGRST002`

I've been having problems with the REST API of one project. I know the DB is still happy, because actual SQL queries work just fine (both in the browser and DBeaver). The REST part is failing, though. At least mostly....
No description

I am getting Error status 501 when starting my local supabase instance

I am using version "^2.48.3" and when I start my local supabase I get this error which was not there few days ago.

My production database has been timing out for hours.

Cannot access: - SQL Editor (times out) - Database queries from app (timeout) - Cannot implement fixes because DB won't respond ...

Vault Help

I have enabled, ran sql queries, exposed the vault schema but i keep getting the same error: ```{ code: 'PGRST202', details: 'Searched for the function public.vault.create_secret with parameters name, secret or with a single unnamed json/jsonb parameter, but no matches were found in the schema cache.',...

URGENT: Project Upgrade Stuck – PostgreSQL upgrade not completing for hours

Hello Supabase team, I'm experiencing a critical issue during a PostgreSQL upgrade. I initiated the upgrade to version 17.6.1.011 and my project has been stuck in the upgrading state for several hours (over 2 hours now). During this time, the database is completely unavailable, and I cannot access any backend functionality. This is blocking my production deployment....

Project stuck upgrading to Postgres 17.6.1.011

Hi Supabase team, My project is currently stuck while upgrading to Postgres version 17.6.1.011. It’s been several hours and I still cannot access my database. This is blocking my production launch and I need urgent help....