shell brew tap microsoft/mssql-release https://github.com/Microsoft/homebrew-mssql-release brew update brew install msodbcsql mssql-tools shell sudo apt-get update sudo apt-get install msodbcsql mssql-tools shell pip install pymssql python import pymssql conn = pymssql.connect( server='your_server_address', user='your_username', password='your_password', database='your_database_name' ) cursor = conn.cursor() sql = 'SELECT * FROM your_table' cursor.execute(sql) result = cursor.fetchall() for row in result: print(row) conn.close()