How to get schema in json format?

I am writing a tool to migrate data form google sheet to Supabase.
I have created my Supabase tables.
I want to validate all my data before I start inserting them and I need to have schema in my code to validate.
But I want to do it automatically instead of recreating schema in json and remember to update it if supabase tables were changed.

Is there a way to access schema in json format?
Or Is there a way to access the type of specific column in an specific table?
Or is there a way that Supabase API could validate a record without inserting it?

Thanks
Was this page helpful?