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.

   The available fields vary by database type. To fill in the host, port, login and database from a connection string, select Import connection string.

   Everything else, such as SSL / TLS, Permissions and Timeouts and pool, has its own section in the list on the left. Settings specific to your database are under its name, for example MySQL settings. Type in Find a setting to search them all.

   A blue dot beside a section name means that section has settings changed from their defaults. Select the dot beside Find a setting to show only those changed settings, and select it again to show everything.

   Unsaved changes are listed on the right, where Reset undoes one. Below them, Set on this connection lists every setting that differs from its default.

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.