So this post was popular yesterday, and it wasn’t even about AI!!!
new feature unlocked, SQL Notebooks pic.twitter.com/1hqY5xp5Af
— SQL.ProductManager.Oracle.Databases (@thatjeffsmith) July 8, 2025
So, what is a SQL Notebook? It’s a Notebook, that allows you to execute SQL and PL/SQL code, vs say…python code that you might use in a Jupyter notebook.
VS Code supports Notebooks, and their APIs allow for extension developers to build their own, which is what we’ve done in the 25.2 update of our SQL Developer Extension for VS Code (changeLog).
Note: 25.2 will require you’re on the latest version of VS Code which is currently v101.
Two ways to start your first notebook
- right click on your connection
- create a .sqlnb file
So what’s a notebook, really?
Notebooks allow you to have a mix of markdown and application code, and are great for showing how your code evolves over time, or basically just to share a narrative.
So allow me to tell a story via a SQL Notebook. And we’ll use my old, dear friend EMPLOYEES to share the narrative.
Opening a SQL notebook will drop you into a new editor, with an unsaved .sqlnb file, and we’ll give you your first Code widget. The widget will accept what you would normally execute in a SQL Worksheet.
Our Extension’s code support extends to the Notebook, so things like code completion are available. And of course, you can manage the connection, just like you would with a SQL Worksheet.
I’m going to do a DESC to introduce our new table to you.
If I let the completer do it’s job, I have a simple DESC command, and it’s text output, as that’s a SQLcl command, vs a SQL command.
Now here comes the fun part…I can use THIS button to add another Code block, and it will go underneath the first block and its output panel.
Let’s say I want to learn about my employees, in terms of the types of jobs they have. So with my 2nd code block, I can run a GROUP BY query with an optional HAVING clause.
Do you see it?
As Keanu would say, ‘Whoa!’ We now have a vertical, stacking set of code blocks and code output. Contrast this with a SQL Worksheet, where you might have 100 queries, and a single set of Output panels on the bottom of the VS Code desktop, and you can only see 1 query result or script results at a time.
But wait, these Notebooks support Markdown, right?
The ‘Run it on LiveSQL’ link generator is available from LiveSQL, and you can even generate buttons if you want.
As you build up your code blocks, you may want to run them one by one, or maybe you want to run everything before or after the current block. That’s what these buttons are for –
You have a few options on how Notebooks are rendered, you can find those in the VS Code settings.
