import pyodbc
connStr = (
    r"DRIVER={SQL Server Native Client 11.0};"
    r"SERVER=(local)\SQLSERVERINSAF;"
    r"Trusted_connection=yes;")
cnxn = pyodbc.connect(connStr, autocommit=True)

crsr = cnxn.execute("SELECT name FROM master.dbo.sysdatabases")
for row in crsr.fetchall():
    print(row[0])

crsr.close()
cnxn.close()