You can not install MS SQL server directly on Mac like on other machine. You need to install Docker first:
Step 1: Download the Docker form Docker Hub.
Step 2: Increase Docker Memory. Go to Docker -> Preference. In Advance Increase memory to 4 GB.
Step 3: Open a Terminal window, and download the latest SQL Server for Linux Docker image using below command
docker pull microsoft/mssql-server-linux:2017-latest
Step 4: Launch the instance of Docker Image using below command
docker run -d --name Homer -e 'ACCEPT_EULA=Y' -e 'SA_PASSWORD=myPassw0rd' -p 1433:1433 microsoft/mssql-server-linux
Now use SQL CLI or any other tool to execute your commands. To connect use username sa and password given in above command.
Tags