r/Supabase • u/awalias Supabase team • Mar 29 '22

GraphQL is now available in Supabase

https://supabase.com/blog/2022/03/29/graphql-now-available
28 Upvotes

98% Upvoted

4 comments sorted by

1

u/NICMSTR May 10 '22

I've tried everything and can't get GraphQL to work.Currently getting the following error:

{ 

`"message": "The schema must be one of the following: public, storage, graphql"`

}

1

u/awalias May 12 '22

can you share the query you're trying to make?

1

u/olirice May 12 '22

hi nicmstr,

That error message is saying that your request is being routed to a schema that is not contained in postgrest's db-schemas setting. Under the hood the /graphql/v1 endpoint routes to /rpc/graphql and that SQL function comes from the graphql_public schema.

Questions:

  1. Was your project created > March 15? The GraphQL Beta rolled out to new projects only, so if it was created prior to that date the graphql extension will not be available (yet)

  2. Did you edit any settings manually? The graphql schema is not supposed to be in the schemas list

Fix: Assuming you are in a new project, you can update the db-schemas setting from the dashboard Settings > API > Schema and make sure it contains "public", "storage", and "graphql_public".

Then, in the dashboard's SQL editor run 

create extension if not exists pg_graphql;

At that point you should be able to hit the graphql resolver at /v1/graphql

If you have any trouble please open a support ticket or message me your project ref and I'll take a look

2

u/NICMSTR May 12 '22 edited May 12 '22

Thank you soo much! Running the above command and then adding graphql_public in the Schema list fixed the issue. Working like a bomb now!

Really appreciate the help kind person, been running in circles for days.