# Connect with Superset

Apache Superset is an open-source business intelligence (BI) and data visualization tool. It enables you to run queries and build interactive dashboards on your SingleStore databases, supporting both SQL-based workflows and visual dataset exploration for the SingleStore database.

To connect with SingleStore, specify the connection URL using the [SingleStore SQLAlchemy dialect](https://github.com/singlestore-labs/sqlalchemy-singlestoredb) (`singlestoredb://`) in the following format:

`singlestoredb://<username>:<password>@<hostname>:<port>/<database>`

where,

* `hostname`: IP address or hostname of the SingleStore cluster.
* `port`: Port of the SingleStore cluster. Default is `3306`.
* `username`: Username of the SingleStore database user with which to connect.
* `password`: Password for the SingleStore database user.

## Prerequisites

Install the `sqlalchemy-singlestoredb` package.

## Connect Superset to SingleStore

To connect your SingleStore database, configure a database connection in Superset:

1. Log in to Superset.

2. From the **Settings** list, select **Database Connections**.

3. On the **Databases** page, select the **+ Database** button.

4. On the **Connect a database** dialog, from the **Supported databases** list, select **SingleStore**.

5. On the **Basic** tab, enter the following:

   * **Display Name**: Enter **SingleStore**.
   * **SQLAlchemy URI**: Enter the connection URL in the following format:

     `singlestoredb://<username>:<password>@<hostname>:<port>/<database>`
   * Select **Test Connection** to verify connectivity to your SingleStore database.

6. Select **Connect**.

The SingleStore database is now added as a database connection in Superset. Either create a dataset or query with SQL to explore your SingleStore database. Refer to [Superset Documentation](https://superset.apache.org/user-docs/) for more information.

***

Modified at: April 7, 2026

Source: [/db/v9.1/query-data/connect-with-analytics-and-bi-tools/connect-with-superset/](https://docs.singlestore.com/db/v9.1/query-data/connect-with-analytics-and-bi-tools/connect-with-superset/)

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