Supabase

S

Supabase

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

Join

How do we query server-side as postgres or service_role with the new secret key locally?

I tried this and it doesn't seem to work: import { createClient } from '@supabase/supabase-js' const supabase = createClient(supabase_url, service_role_key, {...

Help for auth sessions invalidation

Hiho! I am here to ask for guidance regarding how to invalidate user sessions. I found no option on auth.admin functions for this. My scenario: user got subscription canceled. I archived user's plan in database, but I want user sessions to be updated. I have a custom auth hook function that is setting subscription data into the claims, but I want the session token to be refreshed immediately after subscription cancelled. Thanks for any suggestion 😄...

Local Backup Download

Hello, I'm trying to download a backup of all my database data! I would like a local copy of my data as a fail safe especially since I don't update the data too often and I have a lot of data! I have done lots of reading and no luck so far. I have been able to download a cop of the database structure but not the actual database content....

Unable to terminate a query

I am unable to terminate a query that has been running for days. It is in a dev environment, and I would like to simply restart the db, but it looks like this ability has been removed from users. I have a support ticket in, but it takes days back and forth. Any help in the meantime of things to try?

Missing PostgREST CORS UI / Add Allowed Origin

Hello everyone, I'm facing a blocking issue and I'm hoping someone from the community or team can help. The Problem:...

Any devs able to help with 2fa ?

randomly today my sso with github is now requesting 2fa...is it the 2fa for supabase or github?

project not getting created

it's been 5-6 hours since i created this project it is still showing loading issue...
No description

The project is constantly in "Setting up project" status and I can't do anything

Hey, yesterday got an email about pausing my project (free if matters) after 7 days of inactivity. I checked it today, pressed "restore" and all day the project is in "Setting up project" status and I can't do anything (even check the schem etc).

API Configuration

should i use legacy api keys or create new ones?

Exposing Schema

Hey everyone, I'm having a heck of a time with a schema I've created that SHOULD be exposed (see screenshot). Steps I've taken: - Enable & Save wait 30s, Disable & Save wait 30s, Enable & Save wait 30s - Upgrade Postgres version to the latest...
No description

Getting "FATAL: Tenant or user not found" after project resume and changing db password

My staging project was paused due to inactivity and then I resumed it. I'm getting this "FATAL: Tenant or user not found" error when trying to connect (it was working before). I changed the password a couple of times to make sure that it wasn't a credentials problem. I also tried connecting via DBeaver following this guide https://supabase.com/docs/guides/database/dbeaver. I'm copying the data from the Connect -> Session pooler section (host, port, database and user) in Supabase....

Local Realtime - MalformedJWT: The token provided is not a valid JWT

I've been trying everything I can think of to get around this error. If I point my app to production in supabase no issue, everything works instantly with realtime. Locally though it just constantly fails. Haven't had success once locally. supabase-js 2.58.0, docker JWTs are the same and originals, its in the publication table, local studio shows the table is enabled, no diffs in table or settings between local and production. The entire project requires auth for the RPCs and edge functions and they all work fine locally. It's just literally realtime gets this weird JWT error that I can't seem to get around. Any ideas much appreciated! Full log line from Docker:...

Can't link my local project to cloud, help me troubleshoot

I'm trying to link my local project to supabase cloud but in this process I faced, and still facing, multiple issues: 1- I created my project in supabase cloud and successfully linked to my local project, but when I started the migration it complained a table had multiple primary keys (which it hadn't). I couldn't get how to solve it so I removed all migration files and generated one single migration file again. Tried again but complained "remote migrations versions not found in local migrations directory". So I decided to create a new project in supabase cloud and start fresh....

CLI Unauthorized - Edge Function Deployment False Positive

Hello everyone, Is anyone else experiencing random 401 Unauthorized errors when trying to deploy Edge Functions via CLI? (I am admin in my team and was able to deploy them using CLI up until yesterday) ...

does supabase have any sort of 3rd party plugin or webhook system we could integrate features with?

I'm not sure what for just an idea I have to build 3rd party plugins/tools for supabase.

Project upgrade stuck at "Shutting down API services" for over 72 hours.

Hello, My project has been stuck in a PostgreSQL upgrade since 03 oct 17:17. Is this normal or have I messed something up? I'm in region eu-central-1....
No description

Restricted projects

Hey fam,still familiarizing with supabase, had 3 projects, one exceeded the free quota of 1 gb. i had delete the project to create space but now after deleting it, no space was created...seems the delete did not wipe out the files, am now restricted,...help

Upgrade stuck since +5days

Hi everyone, I started the upgrade 5+ days ago and I am still stuck on "prepare new server". I did open a ticket 5 days ago, but haven't heard back yet. I'm in the eu-central-2 region with free plan. Was planning to upgrade, but now I'm genuinly questioning the product. I have no idea on what to do, any suggestion?

update openai edge function documentation

Can we get an update with openai and deno and jsr? The docs are fairly out of date: https://supabase.com/docs/guides/ai/examples/openai and openai.responses is not valid with version 4.69.0...