4.2.1 Configure an SQLite Database Connection

The MySQL Shell for VS Code extension enables you to establish a connection to an SQLite database and access the data using DB Notebook. To create a connection:

1. Select Sqlite from the Database Type list.

2. In the Basic tab, locate the Database Path field and then navigate to where the database is installed and select the database to be used for the connection.

   Note

   .SQLite and .SQLite3 files are currently supported.

   .db files are not currently supported.

3. In the Database Name field, enter the database name.

4. In the Advanced tab, specify other parameters to be passed in when making the connection.

5. Click OK.

Figure 4.3 MySQL Shell for VS Code - SQLite Database Connection

When the connection has been successfully made, the tables, views, and so on are available by expanding the database you have connected.