# Connect with the SQL Editor

The SQL Editor in the [Cloud Portal](https://portal.singlestore.com) allows you to easily run queries against your workspace.

## Multi-tab SQL Editor

The multi-tab SQL Editor allows you to open and work with multiple SQL files in parallel within a single browser session. You can load, edit, and run queries against different workspaces and databases, and save individual SQL files for future use.

## Create and Open a New SQL File

**Note**: Ensure that the correct workspace and database are selected at the top of the file, and all queries are run against the intended database.

1. On the [Cloud Portal](https://portal.singlestore.com/), select **Editor** > **Open SQL Editor**.

2. Navigate to the **+ New **button on the right, and select **New SQL file**.

   A new tab opens with an untitled SQL Editor (for example, Untitled-1.sql). Each additional untitled tab is automatically numbered incrementally (such as Untitled-2.sql, Untitled-3.sql, etc.).

## Save a SQL File

To save an untitled SQL file, select the **Save As** button on the top right. In the dialog, enter the filename and confirm its storage location.

**Note**: SQL files can only be saved in the **Personal** folder.

For further modifications, select **Save**, or you can rely on autosave. The editor autosaves content every 5 seconds, as indicated by the **Save** button changing to **Saved**. 

If you try to close a file with unsaved changes, you will be prompted to save, discard, or cancel. Unsaved or untitled files are lost permanently when closed.

## Set a Row Limit for Results

To limit the number of rows in the query result:

1. Select the three dots icon in the top right corner of the editor.From the list, select **Settings**.

2. The Settings panel shows a **Limit results to** option.

3. Select a row limit: 300,1000, or 3000. The default is 300 rows.

Alternatively, you can set the row limit by running the following command in the SQL Editor:

```sql
SET SESSION SQL_SELECT_LIMIT = 5000;
```

This example sets the value to 5000.

## Troubleshooting

* If you experience connection errors when running queries, verify that your IP address is allowed in the workspace group's firewall settings.
* For additional assistance, contact [SingleStore Support](https://support.singlestore.com/).

***

Modified at: May 22, 2026

Source: [/cloud/connect-to-singlestore/connect-with-the-sql-editor/](https://docs.singlestore.com/cloud/connect-to-singlestore/connect-with-the-sql-editor/)

(An index of the documentation is available at /llms.txt)