You can install pymmsql on your Mac for Azure SQL DB by following these three steps.
Step 1: Install Homebrew Go to your terminal and run the following command:
ruby -e "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/master/install)"
Step 2: Install FreeTDS. From the terminal, run the following command:
brew install freetds
This should install freetds on your system.
Step 3: Install pymmsql. From the terminal, run the following command
sudo -H pip install pymssql
Now you can use pymssql to connect to Azure SQL DB and SQL Server.
source share