Skip to Main Content
  • Questions

  • Connecting db to Jupyter notebook (or alternative notebook)

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, James.

Asked: May 19, 2025 - 4:03 pm UTC

Last updated: July 09, 2025 - 7:06 am UTC

Version: 19c Enterprise

Viewed 100+ times

You Asked

I would like to link a notebook (preferably Jupyter) to an on-prem Oracle DB. I understand that I can do this by making calls with Python, but this is NOT what I am looking for. I am looking a way to run the native SQL. Can I do this via SQL Developer on VS Code? Is there an Oracle kernel for Jupyter?

Thanks!

and Connor said...

There are various libraries around, but effectively these are most commonly going to be abstractions on top of Python anyway.

eg JupySQL

https://jupysql.ploomber.io/en/latest/quick-start.html

SQL Alchemy

https://www.sqlalchemy.org/

Pandas

https://blog.jetbrains.com/datalore/2022/02/14/how-to-run-sql-from-jupyter-notebook-two-easy-ways/

Under the covers, we're still talking Python here, but these let you mask a lot of that away
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's channel and Chris's channel from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.