How to Use VS Code to Run SQL on a Database
Vložit
- čas přidán 7. 07. 2024
- 📝 Get my free SQL Cheat Sheets: www.databasestar.com/get-sql-...
🎓 Learn and become confident in SQL: databasestar.mykajabi.com/sql...
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 - Věda a technologie
This video is insanelly underrated... Amazing...🙏
I'm glad you think so!
Great video, thanks for creating it!
Glad you liked it!
this video was so awesome thank you so much!!!
You're so welcome!
really like your video, waiting for the Oracle SQL video
Glad you like it! The Oracle one is coming soon.
Helped me run specific queries, thanks!
Glad it helped!
ı thing you are god :D , I was constantly getting errors, no one explains it as well as you 👍
Thanks a lot! I’m glad you liked the video
Very helpful and easy to understand, thank you so much.
Glad it was helpful!
Thanks that was easy.
Glad you found it easy!
Bro I'm gonna kiss you on the lips. You just saved me hours of work
Hahah thanks!
kiss his ass🎉
Ayo
Tf u gay
No no no this should only be done to your wife! NO EVEN YOUR MATURED DAUGHTER
Amazing tuto!
Thanks!
Hi Ben, as always, thank you for your teaching! On a different topic, can I run Postgresql on Visual Studio (not Visual Studio Code)? Would you please send some instruction? Thank you!!!
Thanks Tim! I'm not sure how, but I am guessing you can. There may be an extension for Visual Studio, just like the one in VS Code, that can be used to access a database. I'll create a video on this in the future.
Do i need to download MySQL before doing all these steps or is it usable with just the plugin? (Like an internal VSC sql server)
Yes, you'll need to have access to a database, such as MySQL. You can download and install MySQL on your computer. There is no internal database included with the plugin.
🙏 Thank you for your a great work .
You're welcome!
Has anyone told you that you have a nice teaching voice, because you do
Thanks!
heyyyy, thanks for such a great video.
You’re welcome!
Hi, thanks for the great easy-to-follow-content! I only have one minor problem that bothers me, around 10:20 whenever I run any query, I don't see the green box even when it's successful, it does show errors, however a feedback on successful queries is essential for me. Any idea how to fix this? Thanks in advance
That's interesting. Is the query successful? I'm not sure why the box would not be appearing. Perhaps there's a setting that shows or hides this panel. Or perhaps it's a known issue in a certain version of the extension.
@@DatabaseStar The query is successful. I checked the settings and wasn't able to find it anywhere.
Nice tutorial! 🥰
Thanks!
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.
Hey, that’s a good suggestion. I don’t have a video on using vs code with oracle on a regular database like Oracle Express. But I can create a video like that. The only difference would be the connection details.
Hi, I’m working on the Coursera Capstone project and I’m trying to figure out how to utilize .csv files. Is that possible?
Hey, you can import CSV files into your database as a table. I don't know if you can do this in the VS Code extension, but you can do it in most SQL Editors.
Hey, I love everything you showed me and although i had like 30 different errors i was able to work them all out except for one, where you talk about things at 11:15 , it keeps saying that it cannot find the table that I had just created, do I have to refresh it or what? I went into mysql and typed in the exact same things and it worked and went back into sqltools and was editting stuff there, but is there a delay or a refresh that has to happen? Thank you
Thanks! I'm not sure, perhaps there is a refresh that needs to happen. The object explorer that shows the tables may need to be refreshed, but if you write a query that refers to the table it should work. Did you happen to use square brackets or single quotes around your table name?
@@DatabaseStar hey, I figured it out, I needed to route my usenode thing in settings to my node application on my computer and it auto updates now!! Thanks for everything
Thank you for this.
No worries!
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!
No prolem! Sure, I mean that I used MySQL Workbench to create a database. I opened MySQL Workbench and connected to MySQL running on my computer. I then created a new database which is an area that can hold database objects such as tables.
Thank you soo much. This was so useful
Glad it was helpful!
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??
Oh that's strange, perhaps the authors have updated the extension. Is your password correct? If it is, I would suggest contacting the author or developer of the extensions.
same
@Database Star i installed all there extensions from market place but in add new connection second one that is SQL Tool Post GRE is not visible.
Oh that's strange, perhaps there's an issue with the extension with Postgres not appearing.
I have a question. When I did this, I already made schemas and databases in the past. When I access them (such as Select/Desc), it returns with "No Data" even when the databases already have data. Is there a fix for this?
Or do I have to create all databases from the start again?
That's interesting. Do you see them if you access them using another editor such as SQL Developer? Do you see the tables in the object browser on the left panel?
After installing SQL tools error occurred like "error opening connection client option 'pooling.maxIdleTime' doee not support value Nan. Pl help me
Several others had this issue in the comments, so you can probably have a look there.
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?
There's a setting on the connection screen about the timeout which you can increase to a higher number, and this may solve the issue. If not, then it may be a MySQL issue.
Hi Ben, thanks for the video, but i am getting a this error: 'Error opening connection Unknown database 'mysql_database'' . Not sure how to go about it
Hmm. Do you have a database with that name on your server? You can check which database are available in another IDE such as MySQL Workbench
best video!!! thanks a lot
You're welcome!
Are Port Number and Process ID the same thing?
I believe they are different. Port number is like the gate that is used to communicate between two things. A process ID is a unique number for a process that runs on the computer.
Have i understood that correctly, do i need to install the MySQL server on my laptop first, in order to create a MySQL Connection in VS Code Studio?
Yes that’s right!
Hi, what if I want to import the csv file directly into vscode instead of going through pgAdmin4, is that possible?
Good question, I'm not sure if VS Code allows you to do this!
@@DatabaseStar yeah you right, we have to import first on pgAdmin, thanks for answer my question sir. God bless you
I can't thank you enough 🥰🥰.
Glad you liked it!
Does MS SQL Extension enough to use SQL with Visual Studio Code? Thanks
Yes, it has enough of the basic functionality to let you write queries and see results. For more advanced stuff, you may want to use another IDE such as SSMS.
Hey,
I successfully added the database but when i try to connect i got the next error message:
Request connection/GetChildrenForTreeItemRequest failed with message: Handshake inactivity timeout
What should i do?
Hmm I’ve never heard of that message. Could you check the GitHub repo of this plugin to see if others have the same issue? Or some Googling if you have t some so already.
Me2
Hello Attila, please were you able to fix the problem?
Try this
czcams.com/video/wzdCpJY6Y4c/video.html
If it does not work, you may have to use other sql extensons.
I use Jun Han's extension instead.
Hey, I have installed the extension sqltools but I cant see it in the side bar. what might be wrong?
Maybe there is a setting in VS Code that needs to be adjusted? Or maybe you need to restart VS Code?
In 4:23, when I tried the connection I have an error that says: Client option 'pooling.maxIdleTime' does not support value 'NaN'.
can someone help me with this.
I think you'll need to enter a value somewhere on the connection screen. There are some other comments on this error I believe.
Thank you
You’re welcome!
6:54 I'm trying this on mac os and I'm stumped by what to put in the Database. SSMS isn't available for Mac so how do I create a database on my local machine for visual studio to access?
Ah good question. If you want to run SQL Server on your Mac, you could use a tool called Docker. That’s what I use and I have a video about it on my channel.
If you don’t necessarily need to use SQL Server, you could install either MySQL or Postgres, both of which work directly on Mac.
@@DatabaseStar Thanks for the response. I'll look into setting up docker. As for mysql and postgresql, I'm not sure about them. I'm not too educated about sql actually. But I've joined a course to learn it and I wanted to set it up on my MacBook beforehand. The instructor is just going to use SSMS so I doubt he will be able to help me
Thank you!
You're welcome!
In SSMS I enter LAPTOP-QFUJTI9Q\SQLEXPRESS for the Server name. In SQL Tools where do I enter the server name?
I'm not sure. Could you try connect without it? Perhaps it's in the server name field.
is their a way to import an excel file using vscode?
I'm not sure - I'll have to take a look!
Great Video!!!
but i have an issue/error... it say "Request connection/GetChildrenForTreeItemRequest failed with message: Client option 'pooling.maxIdleTime' does not support value 'NaN'."
Can you help me?
Thanks! I think others have left comments with this error. If that doesn't work then perhaps Google can help.
Hey, I had this same error
Can you please tell me how you fix this
Hi Thanks for the video. When I try to test connection I keep getting this error "connect ECONNREFUSED ::1:3306" I don't know how to move past this. any help on how to fix this?
I’m not sure how to solve that one unfortunately
You truly did a good job, but when following your steps, I stuck in this error: Failed to connect to localhost:1433 - Could not connect (sequence). Tell me how can I solve it
Thanks! I'm not sure how to solve that one, perhaps you'll have to Google it.
Thank you sir
You're welcome!
I got 'failed to connect to localhost:1433 - could not connect (sequence)' . What should I do?
Hmm I’m not sure. Is the database running? What does Google say?
Have you resolved the problem? I am facing the same problem
Hi~I have a problem for my sql server 2008 using vscode to connect database ,I have no idea which one extension that I can use?any one can help ? Thank you guys assistance.
Hi, you should be able to use this extension mentioned in the video to connect to SQL Server.
@@DatabaseStar Thanks for you answer,but I'd tried to use SQL Server given connect String as like
"Data Source=,;Initial Catalog=;User ID=;Password=",
step by step...then I just could see the database cluster shown
,when I use sql code "select * top 1000 from ....",
it appeared :
This is likely caused by the extension that contributes mssql.scriptSelect....
So I thought that Sql2008 is the reason why ?and what's you opinion?
Well, my issue is I'm using a CA Certificate to authenticate to my Azure MySQL server, and this extensions appears to not have an option to select the path to it.
Oh that's a shame it's not available
Hi, thanks for this video but I got "read ECONNRESET" error could you help me out on this problem....
Hmm I’m not sure what that error means unfortunately
Please can you tell me how i can connect to multiple databases in the same time using sql server driver
Thanks in advance.
I think you can set up multiple connections in the connections panel?
@@DatabaseStar would you please tell me how?
when i connect to the sql sever in chromebook i got this error: error opening connection failed to connect localhost, how can i fix it?
Is SQL Server running on your computer? Can you connect with another editor such as SSMS?
Hello, while trying to create a connection for mysql, it's showing this error- 'Client option 'pooling.maxIdleTime' does not support value 'NaN'. I'm unable to figure out what this is. Could you please help me with that?
I think to solve this you need to put a value into one of the fields on the connection screen. There are other comments with the same issue I believe.
hi,installing databases in visual studio codes met this problem, how can you help me please...
this error: Request connection/GetChildrenForTreeItemRequest failed with message: Client option 'pooling.maxIdleTime' does not support value 'NaN'.
Hi Mohamed, I'm not sure what this error means. I would suggest Googling it, if you haven't done so already. Or, set a value for Max Idle Time when you create the conneciton.
@@mohamednabe7203 Hi, I got the same error, did you manage to solve this problem?
@@mohamednabe7203 I got the same error too
Hey man, your videos are super helpful. I just wanna ask, what do I do at 5:55 when I try to Test Connection it tells me ("Client option 'pooling.maxIdleTime' does not support value 'NaN'. ")
When I put a value of 30 like you said, it says ("The server has gone away") Yours came so quickly so I'm stumped
Thanks!
I’m not sure why you’re getting that error about the server going away. The NaN issue is mentioned in a few other comments and I think adding that value like you have would resolve it. Unsure about the other error thought.
@@DatabaseStar That's ok. Thanks for the reply. I'm sure I'll find a way.
@@unruly_ronin hey did you find the way ??
@@harshitkhandelwal9983 did you find a way? I need help too
I got the same error , change authentication protocol to default then it will be successful.
What to enter in Database name in VsCode? I have installed mysql server on my Mac.
You can probably entere localhost
@@DatabaseStar same issue
I love the video. Is there by any chance a way i can connect to IBM informix???
Thanks! I’m not sure as I don’t have any experience with IBM Informix.
Hi, I have a problem in here. When I tried to create SQL server connect, I couldn't connect with "Login failed to user "testdb". Can someone help me fix this out? Tks
Is there a user called test db? Or is that the database name?
@@DatabaseStar no, thats just database name. Btw, I figure out to fix this.
@@DatabaseStar I just have subcribed your channel, very useful and great. Thank you
10:03 I dont have this button for running it :( Anyone knows the problem ?
h that's odd. Are you connected to the database?
how to dump data from csv to compact edition data base file.
You can use an IDE to import the CSV into your database, and the process is different for each IDE. In Visual Studio Code, I'm not sure how it's done. I'm not sure if the extension has this feature.
MySQL:
Error opening connection Client option 'pooling.maxIdleTime' does not support value 'NaN'.
:(
Ah I think you'll need to enter a value in one of the fields. I think some of the other commenters had the same issue.
@@DatabaseStar I wrote the same like in your video, but cant establish connection...
@@DatabaseStar I suspect this is because of i dont have any local databases created on my localhost, or i didnt create sql server or didnt create appropriate service.
Will the work also for mac computers?
Yes, it should. I use VS Code all the time on a Mac.
Hi boss, thanks very much for this wonderful tutorial, my question is, can I run this offline without internet connection??
Glad you like it! Yes, assuming you have a database installed on your own computer. You can connect to that and it should work.
sir mySQL is not showing me that exact icone which is appearing in your window on connection time, kindly help to access those icons so i can be able to connect it with VS code.
I really have no time for wait, I've only one day, bcz my project's viva is almost on my head
Which icon are you missing? Is it the cylinder icon on the left panel? Or something else?
@@DatabaseStar Sir my VS code is showing the error "Found that duplicate Database Client extensions are installed, please uninstall the duplicate!"
Kindly guide me that how can I know that which is this duplicate extension???
I keep getting this error message when setting up a new connection: sqltools error error : connect econnrefused :: 1:33060
Hmm is the database running? I assume this is MySQL as it uses port 3306.
i have sql plus in my pc , so how do it in VS code
You can use this video to connect to your database using VS Code. SQL Plus is a command-line tool for Oracle.
6:52 I use mssql and I log in with windows authentication. How do I find the password for connecting it on vs code?
It should be the same password you use when connecting with other editors such as SSMS. The password depends on your database setup - e.g. the one you set when you installed SQL Server Express, or for a different user.
I'm having a problem adding a new contact, can you help me please?
Sure, what do you mean by a new contact?
How do I solve the 'the server has gone away' error
I’m not sure. I did a quick search and it seems to be a timeout issue or something like that. Perhaps restarting your computer or VS code could fix it.
I keep getting this error "Failed to connect to localhost:1433 - Could not connect (sequence)" Plz Help !!
Oh I’m not sure how to solve that unfortunately. Other commenters may have had the same issue though.
Error opening connection Login failed for user 'sys' .......how to resolve this?
Is the password correct? Are you trying to connect to an Oracle database (I think SYS is part of Oracle)? If it's Oracle then you'll need to use a different extension. I've got another video on how to use Oracle with VSCode on my channel.
Wow thank you so much for this video! this works on windows with WSL2? I need something like that :(
Thanks, I'm glad you liked it. I don't know a lot about WSL2 so I don't know why it won't work.
@@DatabaseStar it works! Thanks so much
Good day. How to remove the "highlight" like you have in the video 10:02
I use postgresql and this glow never goes out
I solved this problem, I just had to remove the check mark in the extension settings
Oh good to know. Thanks for sharing your solution.
Hi, Please i have been looking for a video tutorial of how I can link my HTML, CSS and JS to SQL file for web app
I think you'll need some kind of server-side programming language involved to connect HTML and JS to a database. You could use something like Node.js, or PHP, or .NET, or something else.
Error opening connection Client option 'pooling.maxIdleTime' does not support value 'NaN'. why this error?
I think you may need to put a value in one of the fields on the screen. I think other commenters had the same issue.
Hey, thank you for the video, it helps a lot. but i have recived "Login failed for user 'sa'", any reason for that? (P.S: i entered the corrected password)
Hmm it could be the database is not running. Are you able to connect using another tool such as SSMS? It could also be the server name is incorrect
@@DatabaseStar yes, I can connect to the database with SSMS, I am not sure what is going on…
What username and password should I be using?
It’s whatever username and password is set up on your database already. This depends on what database you’re using, eg it could be root for MySQL or sa for SQL Server or something else.
like new_app....how do i set my database
It depends on your vendor, but you could use the USE command.
What about PostgreSQL databases that use SSH?
Is there an option to specify that when connecting?
Failed to connect localhost:1433 -could not connect (sequence)
same here!
Hmm I would suggest checking your username and password, or trying to connect using a different IDE to see if it's a problem with VSCode. Otherwise a Google search may give a solution.
@@DatabaseStar I got the same error and cant fix it. Any suggestion?
Companies actually allow people to connect to databases using random extensions from the internet?
Yeah, some do. Some would limit it to only one specific tool such as SSMS, but others have a more relaxed policy or a recommendation, especially if the extension an be assessed by the company’s security team.
Good point about trusting extensions though!
sir having problem with database name, which name is to be used, it's not accepting, when i click on test connection getting error
It depends on which vendor you’re using and what your existing database is. You can usually use the same details from another sql editor such as SSMS or MySQL Workbench.
"Add new connection" opens up a blank window for me. Trying it out on a linux vm.
Oh that’s not good. I would suggest contacting the plugin team for this. Not sure why it would show a blank screen.
sir am unable to install sql in vscoder please guide us
What issue are you having installing VS Code?
awesome tools but not sure how to use this with ssh.
Good point, I'm not sure how to use it either. Do you mean ssh within VS Code, or separately?
@@DatabaseStar yes ssh within vscode to access mysql.
My problem is that I don't see any of the buttons up top like "run on active connections". Can anyone help please?
Oh that’s strange. Have you connected to a database? If so which database vendor is it?
This is a great tutorial, but can't get it to work with MSSQL using MFA. There's no option for it :(
Oh that’s strange. I’m not sure how to fix that so I hope there’s something on Google
Request connection/GetChildrenForTreeItemRequest failed with message: Unknown database 'myshop' i got this error please help me😭😭😭
Does the database "myshop" exist on your database server?
Not sure why but i got an ECONNREFUSED error when i tried running the MySQL connection
That’s strange. I’m not sure why either. Hopefully something on Google can help.
Error opening connection Access denied for user 'admin'@'localhost any solution whenever i run my connection
Do you use the same details as when you connect using another editor (such as MySQL Workbench)?
The error i keep getting is just "The server has gone away" and not matter what i set the time out value to, it errors straight away
That's strange. I haven't seen that before. It might be something that Google/StackOverflow could help with (unless you've already tried that)
I encountered the same problem too...pls help
I got a query error message on the right side
Ah what error message did you get?
self signed certificate in certificate chain how to fix this
What is the issue you're having?
read ECCONRESET error on test connection
What do you mean?
Hello, I am having this issue when testing my conncetion "Client option 'pooling.maxIdleTime' does not support value 'NaN'.", What should I do?
You can check out some of the other comments and responses for some solutions.
SQLServer connection is not working on me. With SSMS yes, not with vsc
What issue are you having with it?
Hello Thanks for this amazing video. I am complete beginner I lost my $sa_password so I am not able to connect to sql server. How can I change it or retrieve it?
Thanks for your help and all the content you are providing
Thanks! I’m not sure how to change it unfortunately. But there is probably some helpful Stack Overflow posts about it.
what if it doesnt connect?
You can try in another editor or resolve the connection issue, which depends on your database vendor and the error message.
Even though installed step by step I didn't get any connection assistant
Oh that’s strange, I thought it would come up correctly