I like the ipython-sql magic in Jupyter: https://github.com/catherinedevlin/ipython-sql https://github.com/catherinedevlin/ipython-sql Depending on what you're

I like the ipython-sql magic in Jupyter: https://github.com/catherinedevlin/ipython-sql https://github.com/catherinedevlin/ipython-sql Depending on what you're doing you might be able to get away entirely with just using it and some basic queries, i.e. no python glue code in the notebook at all. But worst case you might need a cell to open up the DB connection and make the magic aware of it, then you can execute clean and simple SQL queries in cells using the magic.