Create a connection

Set up a new database connection, link a cloud provider, or explore with the sample database included in the DBCode extension.

1. Open DBCode:

   • Select the DBCode icon in the Activity Bar.

2. Add a connection:

   • Select Add Connection in the Connections view, or select the + icon in the Connections header.

   

3. Choose a database type:

   • Select a database tile, filter the available databases, or paste a connection string into the search field.

   

4. Enter the connection details:

   • Connection name: Enter a recognizable name for the connection.
   • Host and port or socket: Enter the server address and port, or select a socket connection when supported.
   • Authentication method: Choose the method required by your database.
   • Username and password: Enter the credentials when the selected authentication method requires them.
   • Password storage: Choose whether DBCode stores the password in Visual Studio Code Secret Storage.
   • Database: Select or enter the database to open.
   • SSL and advanced settings: Configure these options when your server requires them.

   The available fields vary by database type.

5. Test and save the connection:

   • Select Test to verify the details, then select Save connection.

   

   The saved profile appears under Connections. Select or expand it to connect and explore the database.

Connecting a Cloud Provider

Connecting a cloud provider allows you to access multiple databases within that provider, without the need for individual configurations. For more detailed instructions, refer to the Cloud Provider Integration Guide.

Exploring with the Sample Database

To quickly explore DBCode’s features, use the built-in sample database:

1. Open the DBCode view in the Activity Bar.
2. Select Explore With a Sample Database in the Connections view.

DBCode creates and opens the built-in SQLite sample connection so you can explore its tools without configuring a server.