Connect with Visual Studio Code

On this page

You can connect to your SingleStore cluster from Visual Studio Code using the SQLTools SingleStore Driver (aka "SingleStore Driver for SQLTools") extension. This driver allows you to perform the following tasks:

Connect to your SingleStore cluster.
Manage connections in the Database Explorer.
Run SQL queries. You can also export query results in JSON and CSV formats.
View tables, views, columns, functions, procedures, etc.
Generate INSERT queries.
Autocomplete SQL keywords, table and view names, column names, SingleStore built-in functions, etc.

Refer to SingleStore Driver for SQLTools for more information.

Install the SQLTools SingleStore Driver Extension

To install the SQLTools SingleStore Driver in Visual Studio Code, run the following command in the Visual Studio Code Quick Open (Cmd+p/Ctrl+p):

VS Code

ext install singlestore.sqltools-singlestore-driver

You can also install this extension in Visual Studio Code IDE from the Extensions tab.

Connect with SingleStore from Visual Studio Code

To connect to your cluster from Visual Studio Code, perform the following tasks:

In Visual Studio Code IDE, on the navigation pane, select SQLTools.
Under Connections, select Add New Connection.
On the SQLTools Settings tab, select the SingleStore database driver.
Under Connection Settings, enter the following details:
- Connection name (Required): Name for this connection.
- Server Address (Required): IP address or hostname of your SingleStore cluster.
- Port (Required): Default is 3306.
- Username (Required): Username for your SingleStore cluster.
To test connectivity, select TEST CONNECTION.
Select SAVE CONNECTION.
Under Review connection details, select CONNECT NOW.

You can now explore your SingleStore databases in Visual Studio Code.

Last modified: June 8, 2023

Was this article helpful?

Verification instructions

Note: You must install cosign to verify the authenticity of the SingleStore file.

Use the following steps to verify the authenticity of singlestoredb-server, singlestoredb-toolbox, singlestoredb-studio, and singlestore-client SingleStore files that have been downloaded.

You may perform the following steps on any computer that can run cosign, such as the main deployment host of the cluster.

(Optional) Run the following command to view the associated signature files.
Shell
```
curl undefined
```
Download the signature file from the SingleStore release server.
- Option 1: Click the Download Signature button next to the SingleStore file.
- Option 2: Copy and paste the following URL into the address bar of your browser and save the signature file.
- Option 3: Run the following command to download the signature file.
  Shell
```
curl -O undefined
```

After the signature file has been downloaded, run the following command to verify the authenticity of the SingleStore file.

Shell

echo -n undefined |
    cosign verify-blob --certificate-oidc-issuer https://oidc.eks.us-east-1.amazonaws.com/id/CCDCDBA1379A5596AB5B2E46DCA385BC \
      --certificate-identity https://kubernetes.io/namespaces/freya-production/serviceaccounts/job-worker \
      --bundle undefined \
      --new-bundle-format -

Verified OK