Database Table

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.

Usage

• Choose a Data Connection that is already configured and tested to ensure reliable access to your database.
• The selected connection controls authentication, server location, and provider-specific options for all queries performed by the AI Assistant against the specified table.

Impact of Changes

• Changing the connection will affect which database is queried and may alter the available tables and data.
• If the connection is removed or becomes invalid, the AI Assistant will not be able to access the table or retrieve schema information.

Example

• Select a connection named Production SQL Server to expose tables from your production environment.

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.

Usage

• Enter the table name as it appears in your database (case-sensitive, if required by your DBMS).
• Use the drop-down list to select from available tables once a Data Connection is chosen.

Impact of Changes

• Changing the table name will update the schema and data available to the AI Assistant.
• If the table does not exist or is renamed in the database, queries will fail until the property is corrected.

Example

• Enter Orders to expose the Orders table for customer order lookups.

Optionally specify the name of an extended property from your database table columns to be used as a description for each column. This property allows the AI Assistant to access additional context or documentation for each column when presenting the table schema.

Usage

• Leave blank to omit column descriptions.
• Enter the name of an extended property (such as MS_Description or a custom property) if your database columns include descriptive metadata.
• Use the drop-down to select from available extended property names detected on the table columns.

How It Works

• When set, the AI Assistant will include the value of the specified extended property (if present) as the description for each column.
• If the property name does not exist on a column, no description will be shown for that column.

Example

• Enter MS_Description to use SQL Server's standard column description property.

Impact of Changes

• Setting or changing this property immediately affects the schema information presented to the AI Assistant.
• If the property is removed or renamed in the database, column descriptions will no longer appear until the value is updated.

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.

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.

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.