How to open SQlite3 Database in VsCode in Ubuntu

Step 1:

first you need to install sqlite3 on your ubuntu desktop for that run following command.

sudo apt update

sudo apt install sqlite3

Step 2:

Install the following extension in your VSCode.

STEP 3:

Now open the directory in VSCode in which your sqlite3 database is present.In my case it is a customer.db database as you can see in the following image.

step:4

In this step you need to open command palette and write SQLite as shown in the following image and click on SQLite:Open Database and choose your database in mycase i will choose customer.db.

Step:5

Now you will see at the left corner there will be a sqlite explorer .

from there you just need to click on customer.db in my case there is table called customer i will see that one .

what if it does not work for some reason:

if this thing does not works for some reason then the only way to see the database in your vscode is the terminal. As previously we have installed sqlite3 in the ubuntu so you just need to open your terminal in vscode and write the command given below.