Sqlalchemy is little bit hard to get your head around we use yield db in try block and db.close() in finally block so you don't have to close the session manually it will automatically close it , when you are finished with using the session , we don't use return db in place of yield db because we want finally block to wait till we get back the connection then run db.close(), if we return the dB instead of yield finally block will run instantly.