Up next in 10
This VSCode Extension Connect MySQL,PostgreSQL & SQLite Database Directly in IDE Full Setup
Feb 21, 2025
Get the full source code of application here:
Watch My Visual Studio Code IDE Setup Video For Fonts,Themes & Extensions
https://youtu.be/Bon8Pm1gbX8
Hi Join the official discord server to resolve doubts here:
https://discord.gg/cRnjhk6nzW
Visit my Online Free Media Tool Website
https://freemediatools.com/
Buy Premium Scripts and Apps Here:
https://procodestore.com/
Show More Show Less View Video Transcript
0:00
uh hello guys welcome to this video so
0:02
in this video I will show you yet
0:04
another uh vs code extension uh which
0:07
supports multiple uh database providers
0:11
uh where you can actually interact with
0:13
your database directly inside vs code
0:16
without having to open external websites
0:19
of respective providers so this is
0:21
actually the extension if you just type
0:23
my
0:25
SQL so the second result which comes
0:28
right here if you just type my SQL in
0:30
the extensions
0:32
tab just go to extensions and just type
0:35
my SQL this is actually the extension
0:38
developed by this
0:40
person simply click the install button
0:43
and as soon as you install this it's
0:45
available for my SQL post
0:48
cql you can see it supports multiple
0:51
providers and after you install this you
0:53
will see this
0:56
inside right here a database simp click
1:00
it and already we
1:04
have so now you can create a connection
1:08
right here uh click on this button and
1:11
now this window will pop in so it
1:14
supports multiple database providers
1:16
companies my SQL Mario DB postc sqls
1:19
sqlite SQL Server
1:22
Oracle and uh now let me just connect to
1:27
my PHP my admin server which comes with
1:30
this exam server which runs on 3306 so
1:33
let me just name this as my SQL you can
1:36
give the name any name and then here by
1:40
default the host is
1:41
127.0.0.1
1:44
and port number is
1:47
3306 username root password is nothing
1:50
and then click on connect and as soon as
1:53
you connect you will see the connection
1:54
is
1:55
successful and now if you see it will
1:58
load all your databases right here here
2:00
which are there and it will also show
2:02
you the tables which are also present
2:04
the structure of the table
2:11
so you can see it will display the
2:14
actual data which is present inside the
2:17
table in this table of structure you can
2:19
directly show it inside vs code and if
2:22
you want to edit this table change the
2:25
column names you can even do that as
2:27
well simply add a new column right here
2:31
the name the type let's suppose I want
2:33
to add
2:35
a
2:37
another I will name the column which is
2:41
country and you will see automatically
2:45
the SQL command will be alter table the
2:48
table name add column and okay and you
2:50
will now see this column name has been
2:53
automatically
2:55
added so if you see now you can see this
2:59
country is all automatically added and
3:03
uh we can display the data here select
3:06
star from user limit Z so it will
3:08
display the
3:09
data and uh in this way you can add edit
3:14
your
3:16
tables you can open query right here you
3:19
can write the SQL code right here any
3:22
SQL code will be valid
3:26
so so after you write this you simply
3:29
execute or you have this run button so
3:33
as soon as you click the Run button you
3:34
will see the data will be returned to
3:36
you and it will be displayed right here
3:38
so it all basically this
3:40
extension automatically does the all the
3:43
things in vs code you need need not have
3:46
to left left vs code so automatically
3:50
it's a great extension totally free and
3:53
uh you can manage multiple connections
3:55
so we are having one connection and
3:58
let's suppose if you want to create new
4:00
database you can create a new database
4:02
just name your database let's
4:06
suppose that's all click on run and now
4:09
you will see your database is created
4:12
and you can see
4:18
that so my database has been
4:21
automatically created and here you can
4:24
create anything we can add a new query
4:27
as well
4:30
we can even open Terminal right here
4:33
directly and also you can see all these
4:37
things you can perform right here and
4:39
let's suppose if you want to add another
4:41
connection from another
4:47
provider this time I want to add any
4:51
other provider I will select site and
4:54
then here need to provide the full path
4:55
of the database stored so my database is
4:58
stored inside the C users this
5:03
is and then whatever is your database
5:06
name so my
5:10
database. DB so simply click on connect
5:14
and you will see the second connection
5:16
to the sqi database has been
5:18
successfully made so in this way you can
5:23
actually perform these multiple
5:25
connections to multiple providers and
5:27
you can manage them inside vs code with
5:29
the help of this extension so in this
5:32
way guys you can use this extension
5:34
thank you very much for watching this
5:36
video and also check out my website as
5:38
well free mediat tools.com uh which
5:41
contains thousands of tools regarding
5:43
audio video and image and I will be
5:46
seeing you in the next video
#Internet Software
#Development Tools