> For the complete documentation index, see [llms.txt](https://docs.flowiseai.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.flowiseai.com/integrations/langchain/vector-stores/singlestore.md).

# SingleStore

## Setup

1. Register an account on [SingleStore](https://www.singlestore.com/)
2. Login to portal. On the left side panel, click **CLOUD** -> **Create new workspace group.** Then click **Create Workspace** button.

<figure><img src="/files/81JkFdXDDuDpHvVyGFJO" alt=""><figcaption></figcaption></figure>

3. Select cloud provider and data region, then click **Next**:

<figure><img src="/files/8isSTO2RrNfrMJpHMnpi" alt=""><figcaption></figcaption></figure>

4. Review and click **Create Workspace**:

<figure><img src="/files/6N8A2mJWwIx7ETs3nvy1" alt=""><figcaption></figcaption></figure>

5. You should now see your workspace created:

<figure><img src="/files/LaYIRMiwDxcgDfKfYG9T" alt=""><figcaption></figcaption></figure>

6. Proceed to create a database

<figure><img src="/files/Qzbar24y6LnSFtxAHgq8" alt="" width="485"><figcaption></figcaption></figure>

7. You should be able to see your database created and attached to the workspace:

<figure><img src="/files/mElBwwx1xhtpy4NnxFku" alt=""><figcaption></figcaption></figure>

8. Click Connect from the workspace dropdown -> Connect Directly:

<figure><img src="/files/w7Awhx7HrrOKVtB50uhY" alt="" width="418"><figcaption></figcaption></figure>

9. You can specify a new password or use the default generated one. Then click Continue:

<figure><img src="/files/3ufEcSj8NJW3aaLF0NwU" alt="" width="485"><figcaption></figcaption></figure>

10. On the tabs, switch to **Your App**, and select **Node.js** from the dropdown. Take note/save the `Username`, `Host`, `Password` as you will need these in Flowise later.

<figure><img src="/files/0QXiTmCQkop9fzyzlD1U" alt="" width="563"><figcaption></figcaption></figure>

11. Back to Flowise canvas, drag and drop SingleStore nodes. Click **Create New** from the Credentials dropdown:

<figure><img src="/files/71miPt0w5njkND7CoI5E" alt="" width="271"><figcaption></figcaption></figure>

11. Put in the Username and Password from above:

<figure><img src="/files/iU6DropFDpCvEi3fxqdR" alt="" width="563"><figcaption></figcaption></figure>

13. Then specify the Host and Database Name:

<figure><img src="/files/goU2OLi83A8pnaGGoex5" alt="" width="272"><figcaption></figcaption></figure>

13. Now you can start upserting data with SingleStore:

<figure><img src="/files/HgeYzLky9pvK4WBwGZxP" alt=""><figcaption></figcaption></figure>

<figure><img src="/files/VoarmA9SRslSQZLBzktz" alt=""><figcaption></figcaption></figure>

14. Navigate back to SingleStore portal, and to your database, you will be able to see all the data that has been upserted:

<figure><img src="/files/wj5glSyVASWf6FiDRcyx" alt=""><figcaption></figcaption></figure>
