The Database Hub (DB) in Chat360 allows you to create and manage structured database tables consisting of rows and columns. Each column has a defined name and data type, enabling the bot to store and retrieve structured information. The database acts as the bot’s memory layer, allowing it to deliver personalized, contextual, and responsive interactions.

Typical data stored in the Database Hub includes:

• User Details – Profiles, preferences, and credentials

• Interaction History – Logs of previous conversations and user activities

• Feedback Data – Ratings, reviews, and survey responses

• Operational Data – Configuration settings and knowledge base content

• Transactional Records – Orders, payments, and other transaction details

• Integration Data – Data received from external APIs and connected systems

Creating a Database Table

You can create a database table with multiple columns, each defined by a field name and data type.

Database tables must be created in the Development environment. The table structure becomes visible in higher environments only after the bot is published:

Development → Staging → Production

Supported Data Types and limitation:

Data Types	Limitations
String	You can create a maximum of 47 string data type columns per table.
Integer	You can create a maximum of five integer data type columns per table.
Boolean	You can create a maximum of two boolean data type columns per table.
Date	You can create a maximum of two date data type columns per table.
JSON	You can create a maximum of one JSON (object) column in a database table.

Creating a Table

Follow these steps to create a new database table:

1. Navigate to the sidebar menu.

2. Select Database → Go To + → Create Collections.

3. Click Save.

Then define the required table fields.

Table Configuration Fields

Table Name

• Enter a name for the table.

• Must contain at least 3 characters.

Field Name

• Enter a unique column name.

• Each field name must be unique.

• Minimum 3 characters required.

Field Type

• Select the data type for the column.

• The data type cannot be changed after creation.

Searchable Field

• Enable this option to make a String field searchable within bot flows.

• Unlimited searchable string columns can be created.

• This setting cannot be modified once saved.

Masked Field

• Enables masking for String fields when used in database nodes.

Adding Data to a Database Table

When the bot is published, only the database structure (table and column names) is transferred between environments.

To transfer the actual data, you must:

1. Download the data from the current environment.

2. Upload it to the target environment.

There are multiple ways to add data to the database.

Add individual records to the Database table Manually

To insert individual records manually:

1. Select the target environment.

2. Navigate to Navigation Menu → Database.

3. Open the table where you want to add records.

4. Click the three-dot menu and Select Add Rows.

5. Enter values for each field and Click Save.

6. You can also add new columns from the same interface.

Import Bulk Data Using CSV

Uploading large datasets manually can be time-consuming. Instead, you can import records using a CSV file.

CSV Upload Guidelines

• Column Headers: Must be in lowercase.

• Data Types: Ensure values match the database column data types.

• Exponential Notation: Avoid formats like 3.67406E+15. Convert them to numbers or strings.

• Formatting Tip: Upload the CSV to Google Sheets or Microsoft Excel, then export it again as a CSV file before importing.

Import CSV File

To upload bulk data:

1. Select the desired table.

2. Click Download File to download the current table structure.

3. Open the downloaded CSV file.

4. Add the records you want to import.

5. Navigate to Database Hub.

6. Click Upload File.

Select the updated CSV file from your system.

After the upload completes, the new records will appear in the table.

Managing Records Using the Database Node

Database tables can also be managed directly from bot flows using the Database Node.This is commonly used in workflows such as lead generation, where user data needs to be stored.

• Email

• Phone number

• Product interest

To insert data into the table, follow these steps:

1. Select the Database node and choose 'Insert' operation.

2. In the drop-down, choose the respective table where you want to insert the values

3. Select the required table, then select the required Column, and click on + ADD RECORD to use Operation 2 as well if needed.

4. If Succeed It will return with message “Done”

5. If it fails, Fallback returns with message “Fail”

Update the database table records using the database node​

To update an existing field value in a table, use the database node and select ' Update ' Operation, along with other necessary configurations.

1. Select the Database node and choose 'Update' operation.

2. In the drop-down, choose the respective table where you want to Update the values as here we selected “Details Table”

3. Now Select +ADD FILTER and Enter select required details as per need.

4. Select +ADD FIELD TO UPDATE

Search the database table records using the database node​

To Search an existing field value in a table, use the database node and select ' Search ' Operation, along with other necessary configurations.

Manage database tables​

You can manage individual rows in a database table by editing, updating, truncating and downloading the table data.

Delete database table fields or table

• Go to Database Hub and select the table that you want to delete.

• Click Table and select to drop the table

• Truncate: Deletes all the data that exists in a specific table without removing the table structure.

• Drop: Deletes the entire table structure along with all its the records. All the data will be lost (even in production) if you create a new table with the same name. You will also need to update the reference of this table in all the journey nodes where this table was used.

Edit database table

1. You can add new columns to the current table, rename existing fields, and establish relationships between tables.

2. To edit a table, follow these steps:

• Go to the Navigation Bar > Database and navigate to the base environment according to your environment hierarchy.

• Select the table you want to edit and click Edit Collections to edit the table.

3. Modify the required columns. You cannot modify the datatype or searchability of a column once it is created.

4. To set up relations with other tables, click + Add relations and define the following fields.

• Column: Choose the column of the current table that you want to map.

• Name: Enter a name for the relation.

• Type: Choose the type of association.

• Related table: Choose the table that you want to associate.

• Related column: Choose the column that you want the current column to associate with.

1. Click Save.

2. Publish the bot to observe changes in the subsequent environment within the hierarchy. For instance, you can deploy updates from the Development environment to Staging, and then further push changes from Staging to the Production environment.