How to Use VS Code to Run SQL on a Database

VSCode is a popular editor for development. If you have any need to work with an SQL database, then you’ll likely be using another IDE as well, such as SSMS, MySQL Workbench, pgAdming, or Oracle SQL Developer.

However, if you use VSCode, you can access the database directly from within VSCode. You can do this by using an extension.

This means you can run queries and see your data all within the same application, saving time from using different applications. You may also find it easier to use one application instead of two.

It’s not as powerful as a full SQL IDE, but for simple stuff, it’s quite useful.

In this video, you’ll learn how to install the extension and drivers in VSCode, how to create connections to SQL Server, MySQL, and PostgreSQL, how to run some SQL queries, and some features of the extension (including the Run Query keyboard shortcut).

The extension we use does not support Oracle, but there is a different extension for that.

Timestamps:
00:00 Introduction
00:29 Prerequisites
01:09 Install extension and drivers
03:53 Adding a new connection
04:22 Create MySQL connection
06:14 Create SQL Server connection
07:48 Create PostgreSQL connection
09:14 Connect to database
09:47 Write and run SQL
12:38 More features

[pirithoven_tech]

This video is insanelly underrated... Amazing...🙏

[CodeIsForBros]

Bro I'm gonna kiss you on the lips. You just saved me hours of work <3

[memeti]

ı thing you are god :D, I was constantly getting errors, no one explains it as well as you 👍

[LowQualitty]

Helped me run specific queries, thanks!

[aswinipenneru]

After installing SQL tools error occurred like "error opening connection client option 'pooling.maxIdleTime' doee not support value Nan. Pl help me

[gregjerry]

Has anyone told you that you have a nice teaching voice, because you do

[LimitlessEI]

im trying to learn sql on my own through youtube. at 5:20 where you link the database you put new_app what does this mean and what do i need to do to create my own. thank you for the great video

[theoriarinne]

Very helpful and easy to understand, thank you so much.

[JoshuaJameson-eb]

Hey mate - thanks for the video, very helpful! When you say you've just created a new database using MySQL workbench - any chance you could give some more detail on that please?
Thanks again!

[kelsihill]

Hi at your time stamp 4:46, the screen where it says "Use password", mine does not say that. It says "password mode" and gives the options 'SQLTools driver credentials', 'Ask on connect', 'Use empty password', and 'Save as plaintext in settings'. When I attempted to try each of these it gave me an error once I clicked save connection. I tried uninstalling and reinstalling all of my extensions and even tried downloading different versions of vsc but it still shows this. Any idea how to fix this??

[itsryanpretorius]

this video was so awesome thank you so much!!!

[gastonmarengo]

Whenever I'm in the SQLTools Settings and I click on "Test Connection" I get a red error message saying "The server has gone away" I read that I can change the timeout time in the PHP document for SQL but I'm unsure of doing this, anyone knows another solution?

[mohammed]

it says ECONNREFUSED
using postgreSQL

[ZedTheThrid]

Solid video, though how would you connect this and python together?

[attilatasnadi]

Hey,
I successfully added the database but when i try to connect i got the next error message:
Request failed with message: Handshake inactivity timeout
What should i do?

[biddragon]

really like your video, waiting for the Oracle SQL video

[Rice]

MySQL:
Error opening connection Client option 'pooling.maxIdleTime' does not support value 'NaN'.
:(

[tobyhamilton]

In the video you mentioned you'd be creating a video on how to use the orcale database VS Code extension, I have seen some videos where you use it with docker (I don't know what docker is), but have you created a similair style video to this were in the beginning you just run through how to connect properly, without brining any other technologies like docker.

[cobbyrichie]

Hi boss, thanks very much for this wonderful tutorial, my question is, can I run this offline without internet connection??

[thefamousdjx]

Companies actually allow people to connect to databases using random extensions from the internet?