> ## Documentation Index
> Fetch the complete documentation index at: https://docs.neum.ai/llms.txt
> Use this file to discover all available pages before exploring further.

# SingleStore Connector

> Retrieve data from a SingleStore table

Connect to an existing SingleStore database and extract the content. Data is extracted as JSON objects for each row in the table.

## Properties

Required properties:

* `connection_string`: Connection URL to the SingleStore database (i.e. `<user>:<password>@<host>:<port>/<database_name>`)
* `query`: SQL query to extract data (i.e. Select \* From TableName)

Optional properties:

* `batch_size`: The size of batches of rows. Affects performance and latency.

Compatible loaders:

* NeumJSONLoader

## Usage

<CodeGroup>
  ```python Local Development
  from neumai.DataConnectors import SingleStoreConnector
  from neumai.Shared import Selector

  singlestore_connector =  SingleStoreConnector(
      connection_string = "<user>:<password>@<host>:<port>/<database_name>",
      query = """ Select * From "TableName"; """
  )
  ```

  ```json Cloud
  {
      "sources":[
          {
              "data_connector": {
                  "connector_name":"SingleStoreConnector",
                  "connector_information":{
                      "connection_string":"<user>:<password>@<host>:<port>/<database_name>",
                      "query":"Select * From TableName"
                  },
              }
          }
      ]
  }
  ```
</CodeGroup>