Features
Solutions
Docs
Resources
Enterprise
GPTBots Docs > TUTORIAL > Workflow > Nodes > Data Table
GPTBots Docs > TUTORIAL > Workflow > Nodes > Data Table
Data Table
Last updated：2025-04-07

Data Table

The Data Table node can link to specified data tables within AI agents or applications, supporting common operations such as insertion, query, modification, and deletion to achieve dynamic data management. This node requires specifying data table and corresponding SQL statements.

Node Configurations

image-20250415150504132

  • Associated Data Tables: Defines the scope of data tables to be queried. Supports selecting multiple data tables as the query scope. You must first add the required data tables to the workflow's database.

  • SQL Query: The SQL statement to execute queries. Currently only supports "SELECT" statements.

Output

image.png

The node output parameters consist of the SQL execution results, containing two fixed items:

  • output_list: Fields and data from the data table after SQL execution. Note that the variable names must match field names defined in the SQL statement, and data types must align with those defined in the data table.

  • row_num: The number of affected rows during SQL operations. For query operations, this value is fixed at 0.