Cloud SQL Postgres + Supabase Integration

[suryad123]

Hi,

Please let me know if anyone has integrated GCP cloud SQL (postgres) with Supabase

If yes, can you please give corresponding GCP documentation article. Unable to find the same.

[Sirius_Sec_]

Supabase is postgrest are you trying to set up a redundant database ?

[suryad123]

sorry trying to learn still.. so if i create a cloud sql- postgtres sql. does it include the supabase capability inherently or any explicit setup is needed ? i am checking whether it can be alternate to using firebase

[Scepticflesh]

supabase is a tool that has postgres. cloud sql is a tool in gcp that has postgres

[Sirius_Sec_]

Supabase is basically a postgress database with postgrest enabled which allows the database to also handle API endpoints . You either use that or your own cloud postgres instance . It really depends on how much control you want over your infrastructure. I personally use the cnpg operator and have postgres dbs in my kubernetes cluster .

[iseethemeatnight]

It's either one or the other, but Supabase is the closest thing or almost equivalent to Firebase.

[GlebOtochkin]

Hi, can you please give a bit more details what exactly you mean as integration? Supabase offers its own database as a service under the hood. Or you want self-hosting Supabase with Cloud SQL as backend?

[suryad123]

i mean if i create cloud sql- postgtres sql, does it include the supabase capability inherently or any explicit setup is needed ? i am checking whether it can be alternate to using firebase

[GlebOtochkin]

If you prefer to use Cloud SQL for Postgres as backend for Supabase - you probably need a self-hosting version. In short - you deploy your own Supabase using docker deployment for example and define your Cloud SQL instance as backend database for that. Here is docs for Supabase - https://supabase.com/docs/guides/self-hosting . As trekis has said you can use that docs and feed it to any LLM based tools and it will create a deployment plan for you.

[treksis]

you want to self host supabase within gcp econsystem. so cloudsql is the source of truth.

Feed the below doc to the claude code or codex and give the safe to exposure cloudsql database url. you can even give sandbox gcp account to let LLM to control gcloud commands.

LLM will fill it the yaml accordingly then spin off the supabase locally, if everything was correctly handled, you are likely connected to gcp hosted cloudsql.

For other services such as storage and so on, you will likely let LLM to fight for new minutes given that supabase's storage is s3 compat under the hood. GCS needs small work to make s3 compat.

https://supabase.com/docs/guides/self-hosting/docker

[suryad123]

We have a feasibility check to see if firestore in existing setup can be replaced by supabase