Creates a Fake SQL databases and uses Runops to execute the queries.
First, start by installing and login into the runops cli. More details here.
Than, copy config.yml.example as config.yml and edit is as you want.
Than, you will need to install rust and cargo in your machine. Details here.
Finally, you can just type cargo run and the fake mysql server will start. You can also compile it as release and run it using cargo run --release.
Create a new MySQL data source. As the host use 127.0.0.1 and use the port that you configured in the config.ymlfile. Add a stub user and password. DO NOT type a database.
This should be enough.
Follow this answer if you got:
note: xcrun: error: invalid active developer path (/Library/Developer/CommandLineTools), missing xcrun at: /Library/Developer/CommandLineTools/usr/bin/xcrun