Database Table

Exposes a database table as a resource that an AI Assistant can use to answer questions or provide data-driven insights.

Remarks

A Database Table allows the AI Assistant to access structured data directly from a relational database table. By configuring this resource, you enable the assistant to query and retrieve information from the specified table, making it possible to answer questions, generate reports, or provide context-aware responses based on live data.

To use a Database Table, specify the Data Connection and the name of the table you wish to expose. The assistant will use this configuration to understand the available columns and their data types, and can leverage this information when constructing responses.

Use Cases:

• Retrieve the latest order status for a customer by querying an 'Orders' table.
• Generate a summary report of sales figures from a 'Sales' table for a given date range.
• Answer questions such as "How many active users are there?" by referencing a 'Users' table.
• Provide detailed information about a specific product by looking up its record in a 'Products' table.

These examples illustrate how a Database Table can empower the AI Assistant to deliver accurate, data-driven answers and insights based on the contents of your database.

Properties

Name	Type		Description
Connection	Data Connection	►	The Data Connection containing the database table to be exposed. EditorNode Reference Editor Requiredtrue Select the Data Connection that provides access to the database where the target table resides. This connection determines which database server and credentials are used when querying the table.
Table Name	String	►	The name of the database table to expose. ConverterTable Name Converter Requiredtrue Specify the exact name of the table within the selected Data Connection that should be made available to the AI Assistant. The assistant will use this table as a source for answering queries and providing structured data.
Resource Name	String	►	The name used to identify this resource. The 'Resource Name' is shown in the user interface and is used to reference this resource in configuration and during chat interactions. If an 'Alias' is provided, it will be used as the display name; otherwise, the default 'Name' is used.
Description	String	►	A description of the resource to help the AI Assistant understand its purpose and relationship to other resources. EditorText Property Editor Provide a clear and concise explanation of what this resource is for, what information or capabilities it provides, and how it should be used in relation to other available resources. This description is used by the AI Assistant to determine when and how to utilize the resource during a conversation.
Alias	String	►	An optional alias for the resource, used to resolve naming conflicts. If two resources would otherwise have the same 'Resource Name', you can specify an 'Alias' to ensure each resource can be uniquely identified. The alias will be used as the display name in the user interface and in chat interactions.

See Also

Data Connection