Supabase

S

Supabase

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

Join

Supabase Dashboard login issues

I'm having trouble logging in to my dashboard. When I log in with GitHub it always connects to my personal account, even if I use my work email. I have a different organization connected to my work email, and I'm not able to find it at all. Help from the team would be very appreciated here!!

Connection timeout

Has anyone been facing issues to retreive any data? I cannot use anything and nothing works i have tried clearing browser history and all that but it still didnt work
No description

pg_stat_monitor do the same as "supabase" stats?

does the pg_stats_monitor extension basically do the same as the supabase stats that are in reports etc, does it need to be "enabled"?

Failed to retrieve project's storage configuration

I cannot create new buckets for my project due to some storage config error (screenshot attached). However, all the other database operations work as expected. I just want to create buckets to store some image files for my project.
No description

Type generation error

Hello! I'm trying to generate types for one of my projects via CLI but it throws error: ```...

Error 504 when trying to send password reset email - JS Client

I have a website hosted by DailyRazor that connects to Supabase. While the website is in the development, I am running it on my own PC for testing. I've looked at the docs, asked AI, scanned the console output, and verified the database logs. I found nothing strange or helpful. My guess is the issue is incorrect SMTP settings. I opened a ticket with DailyRazor to get their SMTP settings. I'll put their response in a comment below. My Supabase SMTP settings are in a comment below....

Storage or folder

I want to use storage for 2 goals. Goal one, allow teachers to upload files to the subject. Teachers enrolled in a subject are allowed to upload. Students that can see a task that is linked to a upload in the subject are allowed to download. Should each subject be its own bucket? Or should i simply have one bucket called subject-uploads. and have a folder for each subject? Goal two, (context. subjects have chapters which contain tasks, a task can be a assignment to which a student can upload their work) Should each assignment be its own buckets or should i just have one bucket called assignment-work. Where each assignment is its own folder and in there there is a folder for each student their upload. Making just one private bucket makes more sense than one per subject or assignment for managing it. But who would be the owner of the bucket. And who should be the owner of the file, the user who uploaded it or the owner of the bucket?...

SQL command instead of js sdk

Is there a sql command to create a signed link? And is there a sql command to create a bucket with params like max file size or restricted MIME types?

supabase database claim error

I have already spent many credits trying to solve this, but all the solutions presented do not help. More than 20 million credits were spent. Using version 1, we were able to integrate Supabase easily, but in version 2, the MCP insists on using the Bolt database. Even after changing the .env with the external database credentials on supabase.com belonging to our organization, it still defaults to the previous situation with the Bolt database credentials. It was suggested and even done to create...

Handling multiple environments without downtime

So here is the situation, we have two environments/branches in Supabase -> staging and production. We also have tho apps on the App store called App-Staging and App-Production (this one has been live on the App store for 2 months). So our worklfow is that we develop a new feature or rather change an existing feature on db-staging an deploy a new test-flight version to App-Staging where we can test it. After we are happy with it we would like to push it to db-production and App-production. The problem is that the new staging updates are not compatible with the current live version, meaning that as soon as we push db-staging to production the current live version App-production breaks. And it stays broken until the App-Production is reviewed by Apple (usually takes a day) meaning there is a day of downtime. But we need the db-production updated in order for us to test on test flight of App-production + Apple will reject the app if we try and submit a broken version. What would be the cleanest/correct solution here to minimize downtime? Any suggestions/resources? I hope I explained it well, if anyone needs clarification anywhere lmk. Thanks!...

Storage pricing

Hi, I am a little suprised by the storage cost. Is it really just disk usage and no cost from in/egress? A big portion of my s3 bill in previous projects was egress... Is that not the case here and did i misread, or is it really true? Or is it counted towards the same egress cost as the db itself?...

How long does it take for the WAL to reset? / How to clear the WAL?

I ran a fairly large update query, which caused the WAL to fill up and the project is now in read-only mode because the disk is full. The query got cancelled, but the WAL is still full for about 30 minutes now. What can I do to get my project back online as soon as possible?
No description

URGENT: Accidental DROP TABLE – Free plan, willing to upgrade

Hi everyone, sorry to bother you, but I really need urgent help. One of my collaborators accidentally dropped all database tables today (October 13th, around 4:20 PM CET) in my Supabase project (Project ID: lckxirrmqaumhulvpatn). I already opened a support ticket (SU-275642), but I’m on the Free plan. ...

What is the correct way to implement the next query param in auth/confirm routes?

In the auth/confirm routes for Supabase UI the "next" search param is only used if it starts with /. In the Supabase SSR docs it just uses it as is. If I use the implementation from Supabase UI then it would never work because the redirect URL needs to have the full domain in it....
No description

database error

I have already spent many credits trying to solve this, but all the solutions presented do not help. More than 20 million credits were spent. Using version 1, we were able to integrate Supabase easily, but in version 2, the MCP insists on using the Bolt database. Even after changing the .env with the external database credentials on supabase.com belonging to our organization, it still defaults to the previous situation with the Bolt database credentials. It was suggested and even done to create...

Stuck on this page

not a technical issue but cannot sign in. need support like immediately
No description

Update password (not reset password page)

Hi everyone 👋 I'm working on a password update feature using Supabase Auth in my Next.js app. The password update itself works perfectly — Supabase updates the password and I can log in again with the new one. ...
No description

Can't delete a db role from the dashboard or SQL

Something has gone wrong and we're stuck with a database role. It can't be deleted from the dashboard or using SQL. Here's the error message:
Failed to delete database role: Failed to run sql query: {"error":"ERROR: 42501: permission denied to drop role\nDETAIL: Only roles with the CREATEROLE attribute and the ADMIN option on role \"metabase_app\" may drop this role.\nCONTEXT: SQL statement \"drop role metabase_app;\"\nPL/pgSQL function inline_code_block line 56 at EXECUTE\n","length":285,"name":"error","severity":"ERROR","code":"42501","detail":"Only roles with the CREATEROLE attribute and the ADMIN option on role \"metabase_app\" may drop this role.","where":"SQL statement \"drop role metabase_app;\"\nPL/pgSQL function inline_code_block line 56 at EXECUTE","file":"user.c","line":"1175","routine":"DropRole","message":"permission denied to drop role","formattedError":"ERROR: 42501: permission denied to drop role\nDETAIL: Only roles with the CREATEROLE attribute and the ADMIN option on role \"metabase_app\" may drop this role.\nCONTEXT: SQL statement \"drop role metabase_app;\"\nPL/pgSQL function inline_code_block line 56 at EXECUTE\n"}
Failed to delete database role: Failed to run sql query: {"error":"ERROR: 42501: permission denied to drop role\nDETAIL: Only roles with the CREATEROLE attribute and the ADMIN option on role \"metabase_app\" may drop this role.\nCONTEXT: SQL statement \"drop role metabase_app;\"\nPL/pgSQL function inline_code_block line 56 at EXECUTE\n","length":285,"name":"error","severity":"ERROR","code":"42501","detail":"Only roles with the CREATEROLE attribute and the ADMIN option on role \"metabase_app\" may drop this role.","where":"SQL statement \"drop role metabase_app;\"\nPL/pgSQL function inline_code_block line 56 at EXECUTE","file":"user.c","line":"1175","routine":"DropRole","message":"permission denied to drop role","formattedError":"ERROR: 42501: permission denied to drop role\nDETAIL: Only roles with the CREATEROLE attribute and the ADMIN option on role \"metabase_app\" may drop this role.\nCONTEXT: SQL statement \"drop role metabase_app;\"\nPL/pgSQL function inline_code_block line 56 at EXECUTE\n"}
...

Custom domain quota

Im getting error messages when trying to connect my domain to supabase with it saying: Failed to create custom domain: failed to create custom hostname: { "result": { "ssl": null }, "success": false, "errors": [ { "code": 1405, "message": "Quota exceeded. If you're already a paid SSL for SaaS customer, please contact your Customer Success Manager for additional provisioning. If you're not yet enrolled, please fill out this form and someone from our sales team will contact you: https://www.cloudf...

Supabase Not Unpausing: Still Showing Exceeded Project Limit After Deletion

The Loveable support team mentioned that the issue is from the Supabase side, so I’m reaching out here for help. Here’s the situation: - All projects from my other organization accounts have already been deleted....
No description