Trying to add site but it self deletes after opening SQL Database

Local doesn’t include all the older WordPress versions and the themes and plugins on that site likely aren’t compatible with newer versions. In your Local app when you’re looking at the site UI what does the WordPress version say? Probably 6.2.2

This comes up from time to time and users find ways to get older versions working. One of our users mentions this plugin works well: