Getting Started with SingleStore Helios

Starter Workspace Compute and Storage

A starter workspace uses a shared compute environment with a compressed storage limit of 1 GB. Refer to Operational Limits for Starter Workspace for more information.

Connection Options

SingleStore Helios supports various connection options to connect and query your data.

Connect to SingleStore

You can connect to SingleStore using your workspace via various application development tools.

To connect using the starter workspace:

Select Deployments in the left navigation pane.
Select <your_starter_workspace> from the list of deployments, and then select Connect. You can connect to your starter workspace using any of the supported tools.

CLI Client

Select <your_starter_workspace> > Connect > External Tools > CLI Client. Use any of the following tools to connect:

Tool	How to Connect
MySQL Client	Select CLI Client > MySQL Client. Refer to Connect with MySQL Client for more information.
SingleStore Endpoints	Select CLI Client > SingleStore Endpoints. Refer to SingleStore Helios Endpoints for more information.

For more information on supported CLI clients, refer to Connect to Your Workspace.

SQL IDE

Select <your_starter_workspace> > Connect > External Tools > SQL IDE. Use any of the following tools to connect:

Tool	How to Connect
Sequel Pro	Select SQL IDE > Sequel Pro. Refer to Connect with Sequel Pro for more information.
SQL Workbench	Select SQL IDE > SQL Workbench. Refer to Connect with SQL Workbench for more information.

For more information on supported SQL IDEs, refer to Connect to Your Workspace.

BI Tools

Select <your_starter_workspace> > Connect > External Tools > BI Tools. Use any of the following tools to connect:

Tool	How to Connect
Tableau	Select BI Tools > Tableau. Refer to Connect with Tableau for more information.
Looker	Select BI Tools > Looker. Refer to Connect with Looker for more information.
Power BI	Select BI Tools > Power BI. Refer to Connect with Power BI for more information.
Other	Select BI Tools > Others. Refer to Connect with Analytics and BI Tools for more information.

Your App

Select <your_starter_workspace> > Connect > External Tools > Your App. Use any of the following application tools to connect:

Tool	How to Connect
Python/SQL Alchemy	Select Your App > Python/SQL Alchemy. Refer to Connect with SQLAlchemy for more information.
Python/MySQL Connector	Select Your App > Python/MySQL Connector. Refer to Supported Python Libraries for more information.
Node.js	Select Your App > Node.js. Refer to Connect with Node.js for more information.
Ruby on Rails	Select Your App > Ruby on Rails. Refer to Connect with Ruby for more information.
Perl	Select Your App > Perl. Refer to Connect with Perl for more information.
Java/JDBC	Select Your App > Java/JDBC. Refer to Connect with Java/JDBC for more information.

For more information on supported application development tools and programming languages, refer to Connect with Application Development Tools.

MongoDB® Client

You can connect to your starter workspace from supported MongoDB® tools and drivers using the mongodb:// endpoint, select <your_starter_workspace> > Connect > External Tools > MongoDB Client. Here's a sample connection string:

mongodb://<user>^<database>:<password>@svc-XXXX-shared-mongo.XXXX.svc.singlestore.com:27017/?authMechanism=PLAIN&tls=true&loadBalanced=true&dbName=<database>

For more information on supported tools and drivers, refer to Supported Tools.

Query Data in Data Studio

You can query your SingleStore database using Data Studio in the Cloud Portal.

SQL Editor

You can query the attached database of your starter workspace using the SQL Editor. Select Data Studio in the left navigation, and then select Open SQL Editor. Alternatively, you can select <your_starter_workspace> > Connect > SQL Editor.

Kai Shell

You can run MongoDB® commands on your starter workspace using SingleStore Kai. Select Data Studio in the left navigation, and then select Open Kai Shell. Alternatively, you can select <your_starter_workspace> > Connect > Kai Shell. Refer to Kai Shell for more information.

Notebooks

SingleStore Helios offers Notebooks in the starter workspace that supports SQL and Python development within a secure and seamless connection environment. Refer to Notebooks for more information.

Gallery is a collection of notebooks designed for use with SingleStore. You can also access this collection externally through Spaces. You can contribute to Spaces by following the steps in the SingleStore Spaces GitHub repository.