Better SQL autocomplete, AI custom instructions & code folding

Better SQL autocomplete

Writing SQL just got a whole lot smoother! We've given our autocomplete a major upgrade to make writing queries faster and more intuitive. See these improvements in action in our short video:

We've significantly expanded what your autocomplete can handle - it now works smoothly with schemas containing up to 400k tables, so most of you will never hit size limitations. No matter how many columns your tables have, you'll get reliable suggestions as you type.

The search experience is now much more powerful too. Partial matches work out of the box, so you don't need to remember exact table or column names. Suggestions work seamlessly with qualified entities and ignore backticks and double-quotes - one less thing to worry about as you write.

The autocomplete is now smarter in more ways: it uses table aliases and CTEs; provides context-aware keyword completions; and (our personal favorite!) suggests relevant columns when you're writing join conditions.

There are plenty more improvements waiting for you to discover. Happy querying - we hope these updates help your SQL flow more naturally than ever!

Deepnote AI: custom instructions

Now you can personalize how Deepnote AI works with you! Add your preferences once, and our AI will remember them for all future interactions - whether it's your favorite visualization library or preferred coding style.

Setting up your preferences is simple: click your avatar in the upper right corner, head to Account settings, and find the "Deepnote AI: custom instructions" text box. Whatever you write here becomes part of the AI's context for all your future tasks. And don't worry - these instructions are just for you; they won't affect your teammates' experience.

Go ahead and make Deepnote AI your own - time to tailor it to your style!

Code folding

Keep your longer code blocks tidy with our newest feature: code folding! If you're working with Python code blocks longer than 20 lines, you can now collapse functions, loops, and other code structures to focus on what matters most.

Using it is simple - just hover over the line number next to any collapsible structure and click to collapse or expand it. Want to fold everything at once? Use opt+shift+[ and opt+shift+] on Mac, or alt+shift+[ and alt+shift+] on Windows. Perfect for making your notebooks more organized, especially when working with longer functions.