Connect to Database Using Oracle NoSQL Visual Studio Code Extension

This section describes how you can connect to KVLite in a container using Oracle Database Visual Studio Code Extension.

Oracle NoSQL Database Visual Studio (VS) Code extension provides multiple ways to connect to an Oracle NoSQL Database. You can connect to Oracle NoSQL Database cloud service, cloud simulation, or an on-premise installation. For more details, see About Oracle NoSQL Database Visual Studio Code Extension. In the below case, we will connect to the KVLite instance that we are running inside a container by creating an on-premise connection.

  1. Open the Oracle NoSQL DB extension from the left panel in Visual Studio Code.
  2. Choose Show Connection Settings page from the Command Palette.
  3. Choose Onprem. Choose Add New Connection. Provide a Connection Name and provide the Endpoint as http://localhost:8080 (if you are using an external host - provide the name of the host machine). Choose Add.
  4. You will now be able to view the connection in the left panel. Choose the Plus icon or right-click on the database connection name and choose Create Table.