Hi 👋 ! Im sure this has been asked, but I cant find the answer. How do I export just the structure / schema of a database? My use case is if I have an open source website template that uses a Supabase DB, and I want people to be able to spin up their own DB with all the correct tables and connections. Thanks!

Hello @KenPizza! This thread has been automatically created from your message in #843999948717555735 a ``few seconds ago``. Pinging @User so that they see this as well! Want to unsubscribe from this thread? Right-click the thread in Discord (or use the ... menu) and select Leave Thread to unsubscribe from future updates. Want to change the title? Use the

/title

command! We have solved your problem? Click the button below to archive it.

You can use a tool like TablePlus, DataGrip,, Beekeeper Studio or PGAdmin to export the table schema. You can find the connection information for the database inside the dashboard under

Settings/Database

then scroll down to the connection string.

KenJonesPizza (2022-03-30)

HI @User . Thanks for the response! This is interestingly not as "simple" as I thought it would be. Im sure there is good reason why it isnt a simple export/import It would be addition in the future if there was just an export feature that exported a file that I could drop in my git repo, and that could be used by someone else to spin-up an empty or Supabase DB with the same structure. OR maybe this kinda does exist, Im just to new to Supabse to understand it

did you check this https://supabase-schema.vercel.app/ you can inspect the code on github https://github.com/zernonia/supabase-schema