I am building a software with NextJS and Supabase.

What is the easiest, most efficient way of managing my database schema within VSCode.

For example, instead of going to the Supabase backend to write SQL to build my data architecture, I can have my schema defined in my codebase when building the application. And I can make changes to the schema (adding, revising, removing) and push it to the backend.

Ideally, I would be able to do most of the work without almost ever having to back to the Supabase webapp for writing SQL.