A VS Code extension that provides SQL language support for SingleStore by connecting to the SingleStore Language Server via LSP.
This extension requires a running SingleStore Language Server to function. You can download the latest server release from the singlestore-labs/language-server GitHub repository.
- Download the
.vsixfile from the Releases page. - In VS Code, open the Command Palette (
Ctrl+Shift+P) and run Extensions: Install from VSIX… - Select the downloaded
.vsixfile.
Alternatively, search for SingleStore Language Client on the VS Code Marketplace, in the Extensions view (Ctrl+Shift+X).
Open the configuration panel by running the command SingleStore: Connection Configuration from the Command Palette (Ctrl+Shift+P).
| Setting | Default | Description |
|---|---|---|
singlestore.host |
127.0.0.1 |
SingleStore database host address |
singlestore.port |
3306 |
SingleStore database port number |
singlestore.username |
Username for database authentication | |
singlestore.password |
Password for database authentication | |
singlestore.databaseName |
Name of the database to connect to | |
singlestore.useSSL |
false |
Enable SSL for the database connection |
singlestore.languageServerAddress |
127.0.0.1:4040 |
TCP address (host:port) of the language server |
These settings can also be configured directly in VS Code's Settings (Ctrl+,) under SingleStore connection settings.
- Start the SingleStore Language Server (see singlestore-labs/language-server for instructions).
- Open VS Code and configure the connection using the SingleStore: Connection Configuration command.
- Open or create a file with the
.s2db.sqlextension to activate SQL language features.
This extension works well alongside the SQLTools extension, which provides database management features such as browsing database objects and running queries. To connect SQLTools to a SingleStore database, install the SingleStore Driver for SQLTools.
The extension associates with files using the .s2db.sql extension and provides syntax support for SingleStore SQL.