Working with SQL with your favorite editor ? Check this 👉

0:00Here's a nice and lightweight workflow when working with SQL in a database. Open your favorite editor. For me, it's VS Code. Okay, we're not here to debate about that. Open a SQL file. Then, open the integrated terminal and launch or connect to the DB. For me here, I'm just gonna use a local DuckDB database database. Now, configure your editor to send any command

0:23from the editor to the terminal. In VS Code, you can open the keyboard shortcut JSON file, do any key binding that you would like to, to this command. And voila, now you can leverage all the features of your editors including linting, formatting, and yes, you can even use

0:42Copilot if you're missing an AI friend. And this setup can of course be reproduced to any other editors.