Is there a way to update the

service_role

API Key? If it ever gets revealed where it shouldn't, is there a way to reset it?

anyone been getting a

500

when going to

/api

in the studio on a local/self-hosted version?

been getting this. Both with docker and the

supabase start

The error seems to be in kong, but the terminal for Kong says nothing

Request URL: http://kong:8000/rest/v1/?apikey=<>
Referrer Policy: no-referrer-when-downgrade

I see the same page as yours .. tho everything else is working fine (connecting to the db, querying, etc.) -- it could be that the API docs are not supported locally since not everything in the local studio is supported yet.

do you think its just the docs? Or the API itself?

When I open the

/api

on the remote supabase , it's only the docs

Yeah I see that too

none of my API's seem to work locally -- I tried creating identical table schema's locally and in a hosted version, the hosted API works fine, the local just throw's 404

Which shouldn't depend on studio at all

I'm stupid. I was hitting

localhost:3000/rest

(the studio URL) instead of

localhost:8000/rest

(kong)

yeah that happens sometimes with me too 😅

but also, I had to change

KONG_URL=http://kong:8000

to

KONG_URL=http://localhost:8000

in the docker env file (in case anyone has this issue in the future) to make the studio page work

@User I personally did the commit to fix this issue, sorry I read only now

the issue are the url targets of kong service (someone had it on meta as well)

for the future, if someone have the same issue, can read this: https://github.com/supabase/supabase/pull/5054

Amazing timing, thank you

Question regarding managing schema using Prisma. So just make things easier I wanted to continue managing my schema using Prisma of existing supabase projects. But im getting an error when I migrate

And has an errors when even using npx prisma db push

Guys please use threads 😅

Does anyone know know of any examples of setting up version control and CI/CD with Supabase?

Is there any way to get the jwt secret for the local version of supabase? The hosted version has it in the dashboard and I can access it in postgres with

show app.settings.jwt_secret;

, but this command does not work on my local supbase and there is no settings page that shows the secret either.

Supabase CI CD and version control

jwt secret in local development

why am i getting only the first row on my queries?

why am i getting only the first row on

how do i export all the rows in my table to csv? when i try, it only exports the first 100 rows even though i selected export all rows

Is there any way I can export authenticated users email id from supabase. I have create profiles table which can be exported but it does not have email id of the user. Does anyone know how can I do it?

In the bottom section , where it says 100 rows, click it and you can change it to 1000 rows per page, that way you can export at least 1000 rows once. as it only exports all rows on the current page

Hello Team. I have been using supabase for a week now and it is wonderful. Thank you for your hard work 🙇 I am stuck on a problem. Please provide me with your suggestions on this. https://github.com/supabase/supabase/issues/5113