How to Use VS Code to Run SQL on a Database
HTML-код
- Опубликовано: 21 июл 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 Наука
This video is insanelly underrated... Amazing...🙏
I'm glad you think so!
Great video, thanks for creating it!
Glad you liked it!
Helped me run specific queries, thanks!
Glad it helped!
this video was so awesome thank you so much!!!
You're so welcome!
Very helpful and easy to understand, thank you so much.
Glad it was helpful!
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.
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.
ı 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
really like your video, waiting for the Oracle SQL video
Glad you like it! The Oracle one is coming soon.
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.
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.
Amazing tuto!
Thanks!
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.
heyyyy, thanks for such a great video.
You’re welcome!
Thanks that was easy.
Glad you found it easy!
Has anyone told you that you have a nice teaching voice, because you do
Thanks!
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
Nice tutorial! 🥰
Thanks!
🙏 Thank you for your a great work .
You're welcome!
Thank you for this.
No worries!
@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.
best video!!! thanks a lot
You're welcome!
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
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.
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.
Thank you soo much. This was so useful
Glad it was helpful!
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 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
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?
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
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?
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.
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.
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.
Solid video, though how would you connect this and python together?
I imagine you would set up Python as normal, and then access it from within VS Code?
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
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?
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
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.
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
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
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
ruclips.net/video/wzdCpJY6Y4c/видео.html
If it does not work, you may have to use other sql extensons.
I use Jun Han's extension instead.
Thank you!
You're welcome!
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 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.
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.
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.
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
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, 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
I can't thank you enough 🥰🥰.
Glad you liked it!
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?
Thank you
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
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?
is their a way to import an excel file using vscode?
I'm not sure - I'll have to take a look!
Thank you sir
You're welcome!
What to enter in Database name in VsCode? I have installed mysql server on my Mac.
You can probably entere localhost
@@DatabaseStar same issue
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.
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.
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
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.
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.
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???
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.
10:03 I dont have this button for running it :( Anyone knows the problem ?
h that's odd. Are you connected to the database?
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
Will the work also for mac computers?
Yes, it should. I use VS Code all the time on a Mac.
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
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.
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.
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?
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.
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…
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.
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!
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.
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.
I'm having a problem adding a new contact, can you help me please?
Sure, what do you mean by a new contact?
"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.
What about PostgreSQL databases that use SSH?
Is there an option to specify that when connecting?
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.
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
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)?
like new_app....how do i set my database
It depends on your vendor, but you could use the USE command.
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.
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
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?
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.
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.
self signed certificate in certificate chain how to fix this
What is the issue you're having?
SQLServer connection is not working on me. With SSMS yes, not with vsc
What issue are you having with it?
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.
sir am unable to install sql in vscoder please guide us
What issue are you having installing VS Code?
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?
Even though installed step by step I didn't get any connection assistant
Oh that’s strange, I thought it would come up correctly
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.
If you have been banging your head against your desk trying to get MySQL to work then you've found the correct video and the answer is at 4:50
Thanks!
MySQL step second dhow error show not successful request can u help me to solve
Is the MySQL server running?
@@DatabaseStar yes but not show successfully connected 😞