There’s a new built-in feature to rename your schema within the App Builder. ☺️
If you know your old database name, you can rename and update your schema name to the new one using the Rename Database button in WP Data Access > App Builder > Rename Database.