Stay in flow with Improved FixIt

FixIt is one of our most popular UI features. The premise is simple: when you hit a SQL error, FixIt suggests quick fixes to keep you in flow rather than forcing you to break your concentration to figure out how to do the fix yourself.

While FixIt excels at simple fixes, more complex scenarios can disrupt your flow. Long queries, complicated changes, or times when you need uninterrupted focus can make the current implementation feel intrusive. Today's enhanced version addresses these pain points.

In order to make this work nicely in the UI, we had to change a few things.

First, we redesigned the UI around FixIt. Rather than embedding the controls next to the Fix line, we stick it to the bottom of the editor pane. This makes it much easier to work with very long queries and will support multi-line fixes in the future.

Second, new key bindings. We got feedback from users that they'd love to be able to accept or reject fixes with key binding so that their hands can stay on the keyboard. Simply press Cmd/Ctrl + Enter to accept the change and run the query, or Shift + Cmd/Ctrl + Enter to reject it.

Third, the ability to toggle FixIt on and off from within the editor. When FixIt works, it works incredibly well. But when you don't want it on, you previously would have to go to the Settings panel and then go to Preferences and then toggle off FixIt. This made it really cumbersome to turn it off when you just needed to be in your own flow state, and it also made it really easy to forget about it when you might have actually wanted it later. So now it's dead simple to turn FixIt on and off from within the same flow. When FixIt is off, you have the option to manually run it for a given error.

Inline Edits: Natural Language to SQL

We've also rolled out a new inline editing feature. If you use popular AI IDEs such as Cursor, you're probably familiar with the Cmd + K feature. The idea is that wherever your cursor is or whatever you've selected, you can pop up a tiny prompt window, ask it to change something in natural language, then see the suggestion.

We've been using our new inline edit feature internally, and we all love it. While FixIt helps you fix errors, inline edits help you write correct SQL from the start. Sometimes you know what you want, but you don't know how to express it in SQL. Inline edits makes it really simple to just say what you want and then get to something that actually will run.

If you use inline edits on an empty cell, we will pass the prompt to our server and use it to filter out the columns, tables, and schemas of the currently selected database. So you can use natural language to write your initial query and get most of the table and column references right on first pass. It's a really great way to jump-start a query.

Inline edits work great when you're just trying to work on a query, but it works even better when you're running it with instant SQL. As the AI suggests SQL changes, Instant SQL updates your results in real-time, making it easy to verify that the suggestions are correct.

Getting Started with the New Features

Both of these features are live now in the MotherDuck UI, available for you to use.

FixIt runs automatically on your behalf when a SQL query returns an error.

As a user, you can accept or reject the changes, or disable FixIt for your user. Accepting the changes runs the query immediately. Rejecting them removes the change, or if its not helpful for the query you are debugging, you can disable it entirely.

For inline edits, you can activate the feature with Cmd/Ctrl + K. There are two modes for using this: an empty page, where you can write a sql query from scratch, or to modify an existing query - the highlighted text will be passed into the prompt as further context. This feature is designed to help you stay in flow while working on solving problems with SQL, and highlights our commitment to delightful SQL workflows.

To really cook with this feature, its best to enable Instant SQL first, by clicking the icon or by pressing Shift + Cmd/Ctrl + . Once it is enabled, the SQL queries from inline edits will render against a sample of the data, allowing you to troubleshoot and identify correctness with lightning speed.

We hope you find these new features are both a joy to use and incredibly functional. Now get quacking!

P.S. Ready to truly play SQL like an instrument? Explore all our keyboard shortcuts to unlock the full potential of the MotherDuck experience.