Azure Static Web App – Re-creating the same development database locally

I’m trying to understand how I can have a development database that I can connect to during development in Azure Static Web App.

I followed SWA documentation, and I can connect to a database during local development, but I obviously do not want to develop against the production database.

One way I can think of is to create a different database that I use only for development, but I also want to be able to reset the state of the database easily because the database will be constantly modified during development.

What’s the typical flow for managing this? Do I need to open Azure Portal, drop the dev database, run SQL queries to re-create it every time? There must be a better way to achieve this.