Then use a Windows VM (Parallels/VirtualBox) to run SSMS. import pyodbc import pandas as pd import matplotlib.pyplot as plt Connect to SQL Server on Mac conn = pyodbc.connect('DRIVER={ODBC Driver 17 for SQL Server};' 'SERVER=localhost;DATABASE=yourDB;UID=sa;PWD=YourPassword') Query data df = pd.read_sql("SELECT * FROM your_table", conn) Create report df.groupby('category').size().plot(kind='bar') plt.title('Report') plt.savefig('report.png') Quick Report Template for Azure Data Studio Monthly Sales Report:
Here are the steps to : Important Note First SQL Server Management Studio (SSMS) does not have a native Mac version. It's Windows-only. However, you can still create reports using alternatives. Options for Mac Users Option 1: Use Azure Data Studio (Recommended) Azure Data Studio is the cross-platform alternative to SSMS. mac sql management studio