I have a file, let’s say, working.sql.

I want to do some work on my code until I’m happy with it.

And now I want to connect to a database, and execute it…but I don’t want my fingers to leave the keyboard.

Of course, you’ll need the SQL Developer extension in addition to VS Code.

Demo: Look ma, no mouse!

I’m hitting on my Mac, option+command+Z to select a connection, followed by fn+F9 to execute the query.

Oh, I also had to use the arrow keys and the Return key to choose the connection I wanted.

That looks like this –

How to make it work

In VS Code, pull up the Keyboard Shortcuts dialog.

Then search on ‘connect’ – and look for this –

Click the ‘pencil’ icon, and then assign a keyboard combo. option+command+Z was unused, so I grabbed it.

And that’s it!


I'm a Distinguished Product Manager at Oracle. My mission is to help you and your company be more efficient with our database tools.

Write A Comment