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.
-
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
INSERTqueries. -
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):
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